{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Uvod","csv"],"not_rendered":{"charts":0,"images":1,"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":"Uvod","index":0,"n_rows":40,"n_cols":2,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,1,6]]}
[" 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,"    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":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}