{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Řádky sloupce","Záloha dat"],"not_rendered":{"charts":0,"images":5,"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":"Řádky sloupce","index":0,"n_rows":50,"n_cols":7,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
["ID",null,"Jméno","Věk"]
[1,null,"Iva",20]
[2,null,"Ida",22]
[3,null,"Ema",24]
[]
[5,null,"Ivo",28]
[6,null,"Jan",30]
[]
[]
[null,null,null,null,null,"Poslední řádek"]
[null,null,null,null,null,null,"For Radek = 1 To 65536"]
[]
[null,null,null,null,null,null,"If Cells(Radek, 1) = \"\" Then    'hledáme ve sloupci A"]
[null,null,null,null,null,null,"    PrvniPrazdnyRadek = Radek"]
[null,null,null,null,null,null,"Exit For"]
[null,null,null,null,null,null,"End If"]
[]
[null,null,null,null,null,null,"Next Radek"]
[null,null,null,null,null,null,"    MsgBox \"Poslední obsazený řádek má číslo: \" & PrvniPrazdnyRadek - 1"]
[]
[]
[null,null,null,null,null,"Poslední řádek 2"]
[null,null,null,null,null,null,"PosledniPlnyRadek = Cells(Rows.Count, \"A\").End(xlUp).Row ' Ve sloupci A "]
[null,null,null,null,null,null,"MsgBox \"Poslední obsazený řádek má číslo: \" & PosledniPlnyRadek"]
[]
[]
[null,null,null,null,null,"Poslední sloupec"]
[null,null,null,null,null,null,"PosledniPlnySloupec = Cells(1, Columns.Count).End(xlToLeft).Column ' V řádku 1"]
[null,null,null,null,null,null,"MsgBox \"Poslední obsazený sloupec má číslo: \" & PosledniPlnySloupec"]
[]
[]
[null,null,null,null,null,"Smazání prázdných řádku"]
[null,null,null,null,null,null,"For i = 1 To 7"]
[null,null,null,null,null,null,"  If Cells(i, \"A\").Value = \"\" Then"]
[null,null,null,null,null,null,"      MsgBox i"]
[null,null,null,null,null,null,"      Rows(i).Delete"]
[null,null,null,null,null,null,"  End If"]
[null,null,null,null,null,null,"Next i"]
[]
[]
[null,null,null,null,null,null,"For i = 7 To 1 Step -1"]
[null,null,null,null,null,null,"  If Cells(i, \"A\").Value = \"\" Then"]
[null,null,null,null,null,null,"      MsgBox i"]
[null,null,null,null,null,null,"      Rows(i).Delete"]
[null,null,null,null,null,null,"  End If"]
[null,null,null,null,null,null,"Next i"]
[]
[]
[null,null,null,null,null,"Další kódy"]
[null,null,null,null,null,"http://office.lasakovi.com/excel/vba-listy-bunky/radky-sloupce-excel-vba-kody/"]

{"sheet":"Záloha dat","index":1,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["ID",null,"Jméno","Věk"]
[1,null,"Iva",20]
[2,null,"Ida",22]
[3,null,"Ema",24]
[]
[5,null,"Ivo",28]
[6,null,"Jan",30]