{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Úvod","Základ","Hodnoty z buňky","List2"],"not_rendered":{"charts":0,"images":22,"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":"Úvod","index":0,"n_rows":28,"n_cols":8,"rows_kept":28,"cut":false,"hidden":false,"merged":[[27,1,27,11],[1,2,1,9],[2,2,2,9],[12,2,13,6],[15,3,16,6],[16,7,16,9]]}
[]
[null,null,"Jak na Excel "]
[null,null,"MUNI"]
[]
[]
[null,null,null,"Obsah cvičení"]
[null,null,null,null,"Přečti údaj z buňky - základy"]
[null,null,null,null,"Přečti údaj z buňky"]
[]
[]
[]
[]
[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,null,null,null,"http://office.lasakovi.com/excel/vba-listy-bunky/precti-udaj-do-bunky-excel-vba/"]
[]
[]
[]
[]
[null,"Copyright, Pavel Lasák 2017"]

{"sheet":"Základ","index":1,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,0,1,2]]}
["Přečti údaj - Excel VBA"]
["http://office.lasakovi.com/"]
[]
[]
[null,"Ahoj ;)"]
[]
[]
[null,"HodnotaVBunceB5 = Range(\"B5\").Value"]
[null,"MsgBox (HodnotaVBunceB5)"]
[]
[]
[]
[null,"Zjednodušení v jednom řádku:"]
[null,"    MsgBox (\"Hodnota Value B5 = \" & Range(\"B5\").Value)"]

{"sheet":"Hodnoty z buňky","index":2,"n_rows":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8],[35,0,35,8],[36,0,37,4],[13,2,13,4],[13,6,13,8],[30,3,30,7]]}
["Přečti údaj - Excel VBA"]
["http://office.lasakovi.com/"]
[]
[null,null,null,null,null,null,null,null,null,null,"    MsgBox (\"Hodnota Value B5 = \" & Range(\"B5\").Value)"]
[null,{"$f":"TODAY()+B6","v":"2018-03-11"},null,null,null,null,null,null,null,null,"    MsgBox (\"Hodnota Value2 B5 = \" & Range(\"B5\").Value2)"]
[null,null,null,{"$f":"TODAY()","v":"2018-03-11"},null,{"$f":"B5","v":43170},null,{"$f":"B5","v":"2018-03-11"},null,null,"    MsgBox (\"Hodnota Text B5 = \" & Range(\"B5\").Text)"]
[null,null,null,null,null,null,null,null,null,null,"    MsgBox (\"Hodnota Text B5 = \" & Range(\"B5\").Formula)"]
[null,null,null,null,null,null,null,null,null,null,"    MsgBox (\"Hodnota Text B5 = \" & Range(\"B5\").FormulaLocal)"]
[null,null,null,"=TODAY()+B6",null,"=DNES()+B6",null,null,null,null,"    MsgBox (\"Hodnota Text B5 = \" & Range(\"B5\").FormulaR1C1)"]
[null,null,null,null,null,null,null,null,null,null,"    MsgBox (\"Hodnota Text B5 = \" & Range(\"B5\").FormulaR1C1Local)"]
[]
[null,null,null,null,null,null,null,null,null,null,"    MsgBox \"Hodnota Value B13 = \" & Range(\"B13\").Value"]
[null,{"$f":"NOW()","v":"2018-03-11T08:34:13.730"},null,null,null,null,null,null,null,null,"    MsgBox \"Hodnota Value2 B13 = \" & Range(\"B13\").Value2"]
[null,null,{"$f":"B13","v":"2018-03-11T08:34:13.730"},null,null,{"$f":"B13","v":43170.35710335648},{"$f":"B13","v":"2018-03-11T08:34:13.730"},null,null,null,"    MsgBox \"Hodnota Text B13 = \" & Range(\"B13\").Text"]
[]
[]
[]
[null,{"$f":"B5+2","v":43172},null,null,null,"=B5+2",null,null,null,null,"    MsgBox \"Hodnota Formula B18: \" & Range(\"B18\").Formula"]
[null,null,null,null,null,null,null,null,null,null,"    MsgBox \"Hodnota Formula B18: \" & Range(\"B18\").FormulaLocal"]
[]
[null,null,null,null,null,null,null,null,null,null,"Jiné listy"]
[null,null,null,null,null,null,null,null,null,null,"MsgBox (\"Hodnota na List 2 B3: \" & Worksheets(2).Cells(3, 2).Value)"]
[null,"Worksheets(2)",null,"Worksheets(\"List2\")",null,"Range+Cells",null,null,null,null,"MsgBox (\"Hodnota na List 2 B3: \" & Worksheets(\"List2\").Range(\"B3\").Value)"]
[null,null,null,null,null,null,null,null,null,null,"MsgBox \"Hodnota na List 2 B3: \" & Worksheets(2).Range(\"B3:C7\").Cells(1, 1).Value"]
[]
[]
[]
[null,1,null,null,null,null,null,null,null,null,"MsgBox \"Hodnota Value B28 = \" & Range(\"DefinovanyNazev\").Value"]
[]
[]
[1,null,null,"načítaní vzorců"]
[2,{"$f":"SUM(A31:A33)","v":6}]
[3]
[]
["Příklad k článku:"]
["http://office.lasakovi.com/excel/vba-listy-bunky/precti-udaj-do-bunky-excel-vba/"]
["Pavel Lasák 2015"]
[]
[]
[null,"Naítání v cyklu a pomocí podmínek další list"]

{"sheet":"List2","index":3,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"dda"]
[]
[]
[null,10]