{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Uvod","csv"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":0,"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":7,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,1,6]]}
["Načtení csv souboru do tohoto souboru"]
["http://office.lasakovi.com/"]
[]
["K dispozici ve stejném adresáři soubory:"]
[null,"csv-oddelovac-carka.csv"]
[null,"csv-oddelovac-strednik.csv"]
[]
["otevření načtení csv - samostatný soubor bez Local "]
[]
[]
[null,null,null,null,null,null,"    CestaAdresare = ThisWorkbook.Path"]
[null,null,null,null,null,null,"    Workbooks.Open Filename:=CestaAdresare & \"\\csv-oddelovac-strednik.csv\""]
[]
[null,null,null,null,null,null,"    CestaAdresare = ThisWorkbook.Path"]
[null,null,null,null,null,null,"    Workbooks.Open Filename:=CestaAdresare & \"\\csv-oddelovac-carka.csv\""]
[]
["otevření načtení csv - samostatný soubor s Local "]
[null,null,null,null,null,null,"    CestaAdresare = ThisWorkbook.Path"]
[null,null,null,null,null,null,"    Workbooks.Open Filename:=CestaAdresare & \"\\csv-oddelovac-strednik.csv\", Local:=True"]
[]
[null,null,null,null,null,null,"'pro CZ Excel nenačte správně oddělovač čárka"]
[null,null,null,null,null,null,"    CestaAdresare = ThisWorkbook.Path"]
[null,null,null,null,null,null,"    Workbooks.Open Filename:=CestaAdresare & \"\\csv-oddelovac-carka.csv\", Local:=True"]
[]
["Načtení do listu csv"]
[null,"list musí existovat",null,null,null,null,"    CestaAdresare = ThisWorkbook.Path"]
[null,null,null,null,null,null,"    Workbooks.Open Filename:=CestaAdresare & \"\\csv-oddelovac-strednik.csv\", Local:=True"]
[null,null,null,null,null,null,"     "]
[null,null,null,null,null,null,"    Windows(\"csv-oddelovac-strednik.csv\").Activate"]
[null,null,null,null,null,null,"    Selection.CurrentRegion.Select"]
[null,null,null,null,null,null,"    "]
[null,null,null,null,null,null,"    Selection.Copy Workbooks(\"07e - nacteni-csv-excel.xlsm\").Worksheets(\"csv\").Cells"]
[null,null,null,null,null,null,"     "]
[null,null,null,null,null,null,"    Application.DisplayAlerts = False"]
[null,null,null,null,null,null,"    'vypnutí dialogového okna na zachování dat ve schránce"]
[null,null,null,null,null,null,"    ActiveWindow.Close ' zavře dočasné csv"]
[null,null,null,null,null,null,"    Application.DisplayAlerts = True"]
[]
[null,null,null,null,null,null,"Přeblikavání"]
[null,null,null,null,null,null,"With Application \n.ScreenUpdating = False\n.EnableEvents = False \nEnd With "]

{"sheet":"csv","index":1,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Datum","Navstiveno"]
["2013-07-07",2701]
["2013-07-14",2709]
["2013-07-21",2710]
["2013-07-28",2713]
["2013-08-04",2714]
["2013-08-11",2715]
["2013-08-11",2715]
["2013-08-11",2715]
["2013-08-04",2714]