{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Úvod","Do while","Do Until"],"not_rendered":{"charts":0,"images":14,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Úvod","index":0,"n_rows":28,"n_cols":8,"rows_kept":28,"cut":false,"hidden":false,"merged":[[27,1,27,11],[1,2,1,9],[2,2,2,9],[12,2,13,6],[15,3,16,6],[16,7,16,9]]}
[]
[null,null,"Jak na Excel "]
[null,null,"MUNI"]
[]
[]
[null,null,null,"Obsah cvičení"]
[null,null,null,null,"Do Loop  Until"]
[null,null,null,null,"Do Loop  while"]
[]
[]
[]
[]
[null,null,"Pavel Lasák"]
[]
[]
[null,null,null,"Lektor, expert na Microsoft Excel, držitel prestižního ocenění Microsoftu MVP v České republice"]
[null,null,null,null,null,null,null,5002722]
[]
[]
[]
[]
[null,null,null,"Další informace ke cvičení:"]
[null,null,null,null,"http://office.lasakovi.com/excel/vba-teorie-zaklady/do-loop-excel-vba/"]
[]
[]
[]
[]
[null,"Copyright, Pavel Lasák 2017"]

{"sheet":"Do while","index":1,"n_rows":40,"n_cols":13,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,0,1,9],[3,5,3,8],[38,0,38,9],[39,0,40,5],[5,5,5,6],[8,5,8,6]]}
["Do … Loop While  - Excel VBA"]
["http://office.lasakovi.com/"]
[]
[null,null,null,null,null,"While",null,null,null,null,null,null,"While - dokud je podmínka splněna"]
[1,1,null,null,null,null,null,null,null,null,null,null,"Until - dokud podmínka není splněna"]
[2,2,null,null,null,"Sloupec A"]
[3,3]
[4,4]
[5,5,null,null,null,"Sloupec B"]
[6,6]
[7,7]
[8,8]
[9,9]
[null,10]
[]
[]
[]
["While 1"]
[null,"Pocitadlo = 1",null,null,null,null,null,null,null,null,null,null,"Pocitadlo = 1"]
[null,"Do While Pocitadlo < 10 ' Vnitřní smyčka.",null,null,null,null,null,null,null,null,null,null,"Do Until Pocitadlo > 10 ' Vnitřní smyčka."]
[null,"    Cells(Pocitadlo + 4, 1) = Pocitadlo",null,null,null,null,null,null,null,null,null,null,"    Cells(Pocitadlo + 4, 3) = Pocitadlo"]
[null,"    Pocitadlo = Pocitadlo + 1   ' Zvyš počítadlo.",null,null,null,null,null,null,null,null,null,null,"    Pocitadlo = Pocitadlo + 1   ' Zvyš počítadlo."]
[null,"Loop",null,null,null,null,null,null,null,null,null,null,"Loop"]
[]
["While 2"]
[null,"Pocitadlo = 1"]
[null,"Do"]
[null,"    Cells(Pocitadlo + 4, 2) = Pocitadlo"]
[null,"    Pocitadlo = Pocitadlo + 1   ' Zvyš počítadlo."]
[null,"Loop While Pocitadlo < 10 ' Vnitřní smyčka."]
[]
[]
[]
[]
[]
[]
[]
["Příklad k článku:"]
["http://office.lasakovi.com/excel/vba-teorie-zaklady/do-loop-excel-vba/"]
["Pavel Lasák 2015"]

{"sheet":"Do Until","index":2,"n_rows":54,"n_cols":12,"rows_kept":54,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8],[52,0,52,8],[53,0,54,5],[3,5,3,7],[5,5,5,6],[8,5,8,6],[11,5,11,6],[14,5,14,6]]}
["Do .. Loop - Excel VBA"]
["http://office.lasakovi.com/"]
[]
[null,null,null,null,null,"Until",null,null,null,null,null,"While - dokud je podmínka splněna"]
[1,1,1,null,null,null,null,null,null,null,null,"Until - dokud podmínka není splněna"]
[2,2,null,null,null,"Sloupec A"]
[3,3]
[4,4]
[null,5,null,null,null,"Sloupec B"]
[null,6]
[null,7]
[null,8,null,null,null,"Sloupec C"]
[null,9]
[null,10]
[null,null,null,null,null,"Sloupec D"]
[]
[]
["Until 1"]
[null,"Pocitadlo = 1"]
[null,"Do Until Pocitadlo > 4 ' Vnitřní smyčka."]
[null,"    Cells(Pocitadlo + 4, 1) = Pocitadlo"]
[null,"    Pocitadlo = Pocitadlo + 1   ' Zvyš počítadlo."]
[null,"   MsgBox (pocitadlo)"]
[null,"Loop"]
[]
["until 2"]
[null,"Pocitadlo = 1"]
[null,"Do"]
[null,"    Cells(Pocitadlo + 4, 2) = Pocitadlo"]
[null,"    Pocitadlo = Pocitadlo + 1   ' Zvyš počítadlo."]
[null,"Loop Until Pocitadlo > 10 ' Vnitřní smyčka."]
[]
["Until 3 --- znaménko!"]
[null,"Pocitadlo = 1"]
[null,"Do"]
[null,"    Cells(Pocitadlo + 4, 3) = Pocitadlo"]
[null,"    Pocitadlo = Pocitadlo + 1   ' Zvyš počítadlo."]
[null,"Loop Until Pocitadlo < 10 ' Vnitřní smyčka."]
[]
["Until 4"]
[null,"Pocitadlo = 1"]
[null,"   MsgBox (\"Před: \" & pocitadlo)",null,null,null,null,null,null,null,"dokud není není splněna"]
[null,"Do Until Pocitadlo < 10 ' Vnitřní smyčka."]
[null,"    Cells(Pocitadlo + 4, 4) = Pocitadlo"]
[null,"    Pocitadlo = Pocitadlo + 1   ' Zvyš počítadlo."]
[null,"   MsgBox (\"Smyčka: \" &pocitadlo)"]
[null,"Loop"]
[]
[]
[]
[]
["Příklad k článku:"]
["http://office.lasakovi.com/excel/vba-teorie-zaklady/do-loop-excel-vba/"]
["Pavel Lasák 2015"]