{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Excel","Excel - kódy","Word","PowerPoint"],"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":"Excel","index":0,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Datové typy"]
[]
[null,"Datové typy","Počet bajtů","Rozsah hodnot"]
[null,"Boolean","2 bajty","TRUE/FALSE"]
[null,"Byte","1 bajt","0 – 255"]
[null,"Integer","2 bajty","–32.768 – 32.767"]
[null,"Long","4 bajty","– 2.147.483.648 – 2.147.483.647"]
[null,"Single","4 bajty","od -3,402823E38 do -1,401298E-45 pro záporná čísla \nod 1,401298E-45 do 3,402823E38 pro kladná čísla."]
[null,"Double","8 bajtů","od -1,79769313486232E308 do -4,94065645841247E-324 pro záporná čísla\nod 4,94065645841247E-324 do 1,79769313486232E308 pro kladná čísla."]
[null,"Currency","8 bajtů","od -922.337.203.685.477,5808 do 922.337.203.685.477,5807"]
[null,"Decimal","14 bajtů","+/- 79 228 162 514 264 337 593 543 950 335"]
[null,"Date","8 bajtů","1.leden 0100 – 31.prosinec 9999"]
[null,"Object","4 bajty","Odkaz"]
[null,"String (proměnná délka)","10 bajtů + délka řetězce","0 – 2miliardy"]
[null,"String (pevná délka)","délka řetězce","1 až 65000"]
[null,"Variant (s čísly)","16 bajtů"]
[null,"Variant (se znaky)","22 bajtů + délka řetězce","0 – 2miliardy"]
[]
[]
[null,"Ukázka"]
[null,"   Dim HodnotaLg As Long"]
[null,"   Dim HodnotaB As Boolean"]
[]
[]
[null,"Kontingenční tabulky"]
[]
[null,"Dim sht As Worksheet"]
[null,"Dim pvtCache As PivotCache"]
[null,"Dim pvt As PivotTable"]
[null,"Dim pf As PivotField"]

{"sheet":"Excel - kódy","index":1,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["Platnost proměnných"]
[]
[]
[null,"Platnost proměnné",null,"Platnost proměnné pro modul",null,"Veřejná platnost kontanty"]
[]
[null,"stále 1",null,"Dim ModHodnotaLg As Long"]
[null,"   Dim HodnotaLg As Long",null,null,null,"Public Const APOSTROPHE_KEYCODE = 222"]
[null,"   HodnotaLg = HodnotaLg + 1",null,"Sub PlatnostPromenne11()"]
[null,"   MsgBox \"HodnotaLg = \" & HodnotaLg",null,"   ModHodnotaLg = ModHodnotaLg + 1",null,"Sub PlatnostPromenne41()"]
[null,null,null,"   MsgBox \"ModHodnotaLg = \" & ModHodnotaLg",null,"MsgBox (KEYCODE)"]
[null,null,null,"End Sub",null,"End Sub"]
[null,"bude se zvětšovat"]
[null,"   Static HodnotaLg As Long"]
[null,"   HodnotaLg = HodnotaLg + 1",null,"Sub PlatnostPromenne12()"]
[null,"   MsgBox \"HodnotaLg = \" & HodnotaLg",null,"   ModHodnotaLg = ModHodnotaLg + 10",null,"MsgBox (KEYCODE)"]
[null,null,null,"   MsgBox \"ModHodnotaLg = \" & ModHodnotaLg"]
[null,null,null,"End Sub"]
[]
[null,null,null,"jiný modul",null,"Call PlatnostPromenne41"]
[]
[null,null,null,"Sub PlatnostPromenne21()"]
[null,null,null,"   ModHodnotaLg = ModHodnotaLg + 1"]
[null,null,null,"   MsgBox \"ModHodnotaLg = \" & ModHodnotaLg"]
[null,null,null,"End Sub"]
[]
[]
[null,null,null,"Call PlatnostPromenne11"]
[]
[]
[]
[null,null,null,"Call PlatnostPromenne12"]
[]
[]
[]
[]
[null,null,null,"Call PlatnostPromenne21"]
[]
[]
[]
[null,null,null,"volá se z jiného modulu"]

{"sheet":"Word","index":2,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"   Dim objWord As Word.Application"]
[null,"   Dim objDoc As Object"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Set WDDoc = Nothing"]
[null,"Set WDApp = Nothing"]

{"sheet":"PowerPoint","index":3,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"    Dim PPApp As PowerPoint.Application"]
[null,"    Dim PPPres As PowerPoint.Presentation"]
[null,"    Dim PPSlide As PowerPoint.Slide"]
[]
[]
[]
[]
[]
[null,"čištění"]
[null,"    Set PPSlide = Nothing"]
[null,"    Set PPPres = Nothing"]
[null,"    Set PPApp = Nothing"]