{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["List1","Uvod","csv"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":6,"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":"List1","index":0,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[[26,1,26,11],[1,2,1,9],[2,2,2,9],[11,2,12,6],[14,3,15,6],[15,7,15,9]]}
[]
[null,null,"Jak na Excel "]
[null,null,"MUNI"]
[]
[]
[null,null,null,"Obsah cvičení"]
[null,null,null,null,"QUERY"]
[]
[]
[]
[]
[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,"Copyright, Pavel Lasák 2017"]

{"sheet":"Uvod","index":1,"n_rows":40,"n_cols":3,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3]]}
[" QueryTables - Načtení csv souboru do tohoto souboru"]
["http://office.lasakovi.com/"]
[]
["K dispozici ve stejném adresáři soubory:"]
[null,"csv-oddelovac-strednik.csv"]
[]
[null,null,"DU"]
[null,null,"Vyzkoušet dynamické vkládání"]
[]
[]
[null,"    CestaAdresare = ThisWorkbook.Path & \"\\csv-oddelovac-strednik.csv\""]
[null,"            "]
[null,"    Set query_table = Sheets(\"csv\").QueryTables.Add( _"]
[null,"        Connection:=\"TEXT;\" & CestaAdresare, _"]
[null,"        Destination:=Sheets(\"csv\").Range(\"A1\"))"]
[null,"        "]
[null,"    With query_table"]
[null,"        .Name = \"strednik\""]
[null,"        .FieldNames = True"]
[null,"        .RowNumbers = False"]
[null,"        .FillAdjacentFormulas = False"]
[null,"        .PreserveFormatting = True"]
[null,"        .RefreshOnFileOpen = False"]
[null,"        .RefreshStyle = xlInsertDeleteCells"]
[null,"        .SavePassword = False"]
[null,"        .SaveData = True"]
[null,"        .AdjustColumnWidth = True"]
[null,"        .RefreshPeriod = 0"]
[null,"        .TextFilePromptOnRefresh = False"]
[null,"        .TextFilePlatform = 1250"]
[null,"        .TextFileStartRow = 1"]
[null,"        .TextFileParseType = xlDelimited"]
[null,"        .TextFileTextQualifier = xlTextQualifierDoubleQuote"]
[null,"        .TextFileConsecutiveDelimiter = False"]
[null,"        .TextFileTabDelimiter = True"]
[null,"        .TextFileSemicolonDelimiter = True"]
[null,"        .TextFileCommaDelimiter = False"]
[null,"        .TextFileSpaceDelimiter = False"]
[null,"        .Refresh BackgroundQuery:=False"]
[null,"    End With"]

{"sheet":"csv","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}