{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Úvod","Case Select - základ","Case Select -více","Case Select - ukázky"],"not_rendered":{"charts":0,"images":14,"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,"Case"]
[null,null,null,null,"Case více podmínek"]
[]
[]
[]
[]
[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":"Case Select - základ","index":1,"n_rows":29,"n_cols":2,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,0,1,7]]}
["Case Select - Excel VBA"]
["http://office.lasakovi.com/"]
[]
[]
[null,"Porovnání dvou hodnot"]
[]
[null,"a = InputBox(\"Zadej číslo 1:\")"]
[null,"b = InputBox(\"Zadej číslo 2:\")"]
[]
[]
[null,"Select Case a = b"]
[null,"Case True"]
[null,"  MsgBox \"Zadány dvě stejné hodnoty.\""]
[null,"Case False"]
[null,"  MsgBox \"Zadány různé hodnoty.\""]
[null,"End Select"]
[]
[]
[]
[null,"Více něž …"]
[]
[]
[]
[null,"Select Case a >b"]
[null,"Case True"]
[null,"  MsgBox \"Zadány dvě stejné hodnoty.\""]
[null,"Case False"]
[null,"  MsgBox \"Zadány různé hodnoty.\""]
[null,"End Select"]

{"sheet":"Case Select -více","index":2,"n_rows":35,"n_cols":2,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,0,1,7]]}
["Case Select - Excel VBA"]
["http://office.lasakovi.com/"]
[]
[]
[]
[]
[null,"Ovoce a zelenina"]
[null,"Hodnota = InputBox(\"Zadej ovoce, zelenina:\")"]
[null,"' rozhodnutí co bylo zadáno - ovoce, zelenina"]
[null,"Select Case Hodnota"]
[null,"Case \"Jablko\", \"Hruška\", \"Banan\", \"Jahoda\""]
[null,"  MsgBox \"Jde o ovoce ...\""]
[null,"Case \"Mrkev\", \"Petržel\", \"zelí\""]
[null,"  MsgBox \"Jde o zeleninu ...\""]
[null,"Case Else"]
[null,"  MsgBox \"Nemůžu rozhodnout.\""]
[null,"End Select"]
[]
[]
[]
[null,"Rozsah textu"]
[]
[null,"Hodnota = InputBox(\"Zadej text:\")"]
[null,"Select Case Hodnota"]
[]
[null,"          Case \"aa\" To \"dd\""]
[null,"                   MsgBox \"Text: aa - dd\""]
[null,"          Case Else"]
[null,"                 MsgBox \"ostatní text\""]
[null,"         End Select"]
[]
[]
[null,"Více"]
[null,"… Regulární výrazy"]
[null,"později …"]

{"sheet":"Case Select - ukázky","index":3,"n_rows":25,"n_cols":2,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,0,1,7],[23,0,23,7],[24,0,25,3],[14,1,14,2],[15,1,15,2],[19,1,19,2],[20,0,20,7],[18,1,18,2],[8,0,9,3],[3,0,3,3]]}
["Case Select - Excel VBA"]
["http://office.lasakovi.com/"]
[]
["Reakce na tlačítko"]
[]
[]
[]
[]
["zadej jméno ovoce / zeleniny"]
[]
[]
[]
[]
[]
[null,"zadej číslo 1 - 100"]
[null,10]
[]
[]
[null,"zadej text"]
[null,"azzzzT"]
["A < B < E < Z < a < b < e < z"]
[]
["Příklad k článku:"]
["http://office.lasakovi.com/excel/vba-teorie-zaklady/select-case-excel-vba/"]
["Pavel Lasák 2015"]