{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Data Validation Regex","Examples"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":3,"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":"Data Validation Regex","index":0,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[11,1,11,2],[3,1,3,2],[5,1,5,2],[8,2,8,3]]}
[]
[]
[]
[null,"Excel Data Validation with Regular Expressions"]
[]
[null,"The workbook shows how to do Data Validation in Excel using regular expressions."]
[null,"Author","Ablebits.com"]
[null,"Last update","2021-10-04"]
[null,"Tutorial URL","Excel Data Validation with Regex"]
[]
[null,"Examples:"]
["• ","Validate SKUs, emails and passwords"]
[]
[]
[null,null,null,null,null,null," "]

{"sheet":"Examples","index":1,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["SKU Pattern","Email Pattern","Password Pattern"]
["^[A-Z]{3}-\\d{3}$","^[\\w\\.\\-]+@[A-Za-z0-9]+[A-Za-z0-9\\.\\-]*[A-Za-z0-9]+\\.[A-Za-z]{2,24}$","^(?=.*[a-z])(?=.*[A-Z])(?=.*\\d)[a-zA-Z\\d]{6,}$"]
[]
["> The values in the table below are validated according to the regex patterns in A2, B2 and C2."]
[]
["SKU","Email","Password"]
["AAA-001","jane@gmail.com","12aA345"]
["BBB-002","ronnie.a@university.edu","1aABCD"]
["ABB-003","tom-boone@outlook.com","1234aBc"]
["CCA-005","Sally.B@big-company.com","1abcdE"]