{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Úvod","Nacitani 1","csv"],"not_rendered":{"charts":0,"images":7,"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":"Úvod","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,"Načtení csv","\"klasické\""]
[]
[]
[]
[]
[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":"Nacitani 1","index":1,"n_rows":50,"n_cols":7,"rows_kept":50,"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,"'vybere načtenou oblast"]
[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,"DU"]
[null,null,null,null,null,null,"Jak upravit přes proměné?"]
[null,null,null,null,null,null,"název souboru, cesta, …"]
[null,null,null,null,null,null,"Nebudete muset ručně měnit"]
[]
[null,null,null,null,null,null,"    CestaAdresare = ThisWorkbook.Path"]
[null,null,null,null,null,null,"    soubor ….."]
[]
[null,null,null,null,null,null,"Přeblikavání, překreslování obrazovky"]
[null,null,null,null,null,null,"With Application \n.ScreenUpdating = False\n.EnableEvents = False \nEnd With "]

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