{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Pole","Pole matice","Metody pole"],"not_rendered":{"charts":0,"images":6,"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":"Pole","index":0,"n_rows":89,"n_cols":13,"rows_kept":89,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Pole Excel VBA"]
[]
[]
[null,"Pole"]
[null,"Dim oddeleni As Variant"]
[null,"oddeleni = Array(\"IT\", \"GR\", \"LOG\")"]
[null,"MsgBox oddeleni(1)"]
[]
[null,">>>  GR"]
[null,"oddeleni = Array(\"0\", \"1\", \"2\")"]
[]
[null,"Pole"]
[]
[null,"Option Base 1"]
[]
[null,"Dim oddeleni As Variant"]
[null,"oddeleni = Array(\"IT\", \"GR\", \"LOG\")"]
[null,"MsgBox oddeleni(1)"]
[]
[null,">>>  IT"]
[null,"oddeleni = Array(\"1\", \"2\", \"3\")"]
[]
[]
[]
[null,"Názvy měsíců"]
[null,"MONTHNAMES = Array(\"Jan\", \"Feb\", \"Mar\", \"Apr\", \"May\", \"Jun\", \"Jul\", \"Aug\", \"Sep\", \"Oct\", \"Nov\", \"Dec\")"]
[]
[null,"Maticová funkce"]
[]
[null,"Function MesicNazvyM()"]
[null,"MesicNazvyM = Array(\"Leden\", \"Únor\", \"Březen\", \"Duben\", \"Květen\", \"Červen\", \"Červenec\", \"Srpen\", \"Září\", \"Říjen\", \"Listopad\", \"Prosinec\")"]
[null,"End Function"]
[]
[null,1,2,3,4,5,6,7,8,9,10,11,12]
[]
[]
[]
[null,"Zadání dat do pole"]
[]
[null,"Dim Films(1 To 5) As String"]
[]
[null,"Films(0) = \"Bez Option Base 1 \""]
[null,"Films(1) = \"Lord of the Rings\""]
[null,"Films(2) = \"Speed\""]
[null,"Films(3) = \"Star Wars\""]
[null,"Films(4) = \"The Godfather\""]
[null,"Films(5) = \"Pulp Fiction\""]
[]
[null,"MsgBox Films(4)"]
[]
[]
[]
[]
[null,"Hodnoty v poli (bez Base 1) !"]
[null,"  Dim arr(5)"]
[null,"  arr(0) = \"1\"           'Number as String"]
[null,"  arr(1) = \"VBScript\"    'String"]
[null,"  arr(2) = 100             'Number"]
[null,"  arr(3) = 2.45                    'Decimal Number"]
[null,"  arr(4) = #10/07/2013#  'Date"]
[null,"  arr(5) = #12.45 PM#    'Time"]
[null,"  "]
[null,"  msgbox(\"Hodnota v poli index 0 : \" & arr(0))"]
[null,"  msgbox(\"Hodnota v poli index 1 : \" & arr(1))"]
[null,"  msgbox(\"Hodnota v poli index 2 : \" & arr(2))"]
[null,"  msgbox(\"Hodnota v poli index 3 : \" & arr(3))"]
[null,"  msgbox(\"Hodnota v poli index 4 : \" & arr(4))"]
[null,"  msgbox(\"Hodnota v poli index 5 : \" & arr(5))"]
[]
[]
[]
[]
[null,"Hodnoty v poli (bez Base 1) !"]
[null,"  Dim arr(2,3) as Variant       ' Which has 3 rows and 4 columns"]
[null,"  arr(0,0) = \"Apple\" "]
[null,"  arr(0,1) = \"Orange\""]
[null,"  arr(0,2) = \"Grapes\"           "]
[null,"  arr(0,3) = \"pineapple\" "]
[null,"  arr(1,0) = \"cucumber\"           "]
[null,"  arr(1,1) = \"beans\"           "]
[null,"  arr(1,2) = \"carrot\"           "]
[null,"  arr(1,3) = \"tomato\"           "]
[null,"  arr(2,0) = \"potato\"             "]
[null,"  arr(2,1) = \"sandwitch\"            "]
[null,"  arr(2,2) = \"coffee\"             "]
[null,"  arr(2,3) = \"nuts\"            "]
[null,"           "]
[null,"  msgbox(\"Value in Array index 0,1 : \" &  arr(0,1))"]
[null,"  msgbox(\"Value in Array index 2,2 : \" &  arr(2,2))"]

{"sheet":"Pole matice","index":1,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[[6,1,6,4]]}
["Adam","jedna",1]
["Babicka","dvě",2]
["Celta","tři",3]
["Delta","čtyři",4]
[]
[]
[null,"Pole"]
[]
[null,"Dim Data(1 To 5, 1 To 3) As String"]
[null,"Dim i As Integer"]
[null,"Dim j As Integer"]
[]
[null,"For i = 1 To 5"]
[null,"    For j = 1 To 2"]
[null,"        Data(i, j) = Cells(i, j).Value"]
[null,"    Next j"]
[null,"Next i"]
[]
[null,"MsgBox Data(4, 2)"]

{"sheet":"Metody pole","index":2,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"Function","Description"]
[null,"LBound","A Function, which returns an integer that corresponds to the smallest subscript of the given arrays."]
[null,"UBound","A Function, which returns an integer that corresponds to the Largest subscript of the given arrays."]
[null,"Split","A Function, which returns an array that contains a specified number of values. Splitted based on a Delimiter."]
[null,"Join","A Function, which returns a String that contains a specified number of substrings in an array. This is an exact opposite function of Split Method."]
[null,"Filter","A Function, which returns a zero based array that contains a subset of a string array based on a specific filter criteria."]
[null,"IsArray","A Function, which returns a boolean value that indicates whether or not the input variable is an array."]
[null,"Erase","A Function, which recovers the allocated memory for the array variables."]