{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["List3"],"not_rendered":{"charts":0,"images":1,"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":"List3","index":0,"n_rows":37,"n_cols":6,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3],[24,0,24,3]]}
["Regulární výrazy Excel"]
["http://office.lasakovi.com/"]
[]
["ss","\\*","FAIL"]
["*abcdabcd","\\*","OK"]
["ab*c","\\*","OK",null,null,"http://analystcave.com/excel-regex-tutorial/"]
["abcdabcdabcd","\\*","FAIL",null,null,"http://stackoverflow.com/questions/22542834/how-to-use-regular-expressions-regex-in-microsoft-excel-both-in-cell-and-loops"]
["aabb","\\*","FAIL",null,null,"https://blog.udemy.com/vba-regex/"]
["abcdabcdabcd","^.bcd$","FAIL",null,null,"http://superuser.com/questions/181005/can-you-do-regular-expressions-in-excel-without-vbscript"]
["abcd","^.bcd$","OK"]
["aabbccdd","^.bcd$","FAIL"]
["abcdee","^.bcd$","FAIL"]
["abbb","^ab{2,3}$","OK"]
["abcd","^ab{2,3}$","FAIL"]
["aabbccdd","^ab{2,3}$","FAIL",null,null,"   Dim strPattern As String"]
["aaabbcdee","^ab{2,3}$","FAIL",null,null,"    Dim regEx As New RegExp"]
["abbb","ab{2,3}","OK",null,null,"    Dim strInput As String"]
["abcd","ab{2,3}","FAIL",null,null,"    Dim Myrange As Range"]
["aabbccdd","ab{2,3}","OK",null,null,"    "]
["aaabbcdee","ab{2,3}","OK",null,null," For i = 4 To 23"]
["ak","^a[klm]$","OK",null,null,"        strInput = ActiveSheet.Cells(i, 1).Value"]
["al","^a[klm]$","OK",null,null,"        strPattern = ActiveSheet.Cells(i, 2).Value"]
["amm","^a[klm]$","FAIL",null,null,"        "]
[null,null,null,null,null,"        With regEx"]
["Pavel Lasák © 2015",null,null,null,null,"            .Global = True"]
[null,null,null,null,null,"            .MultiLine = True"]
[null,null,null,null,null,"            .IgnoreCase = False"]
[null,null,null,null,null,"            .Pattern = strPattern"]
[null,null,null,null,null,"        End With"]
[]
[null,null,null,null,null,"        If regEx.Test(strInput) Then"]
[null,null,null,null,null,"            ActiveSheet.Cells(i, 3).Value = \"OK\""]
[null,null,null,null,null,"            ' MsgBox (\"OK\")"]
[null,null,null,null,null,"        Else"]
[null,null,null,null,null,"            ActiveSheet.Cells(i, 3).Value = \"FAIL\""]
[null,null,null,null,null,"        End If"]
[null,null,null,null,null,"Next i"]