{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Create","Named Range","List","Sheet7","UDF","Target","Delete"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":"Create","index":0,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Creating Data Validation Drop Down List"]
[]
[null,"Fruit Names"]
[null,"Orange"]

{"sheet":"Named Range","index":1,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Generating Data Validation Drop Down List"]
[]
[null,"Fruit Names"]
[null,"Grapes"]
[null,"Orange"]
[null,"Guava"]
[null,"Mango"]
[null,"Apple"]

{"sheet":"List","index":2,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Producing Data Validation Drop Down List"]
[]
[null,"Fruit Names"]
[null,"Grapes"]
[null,"Orange"]
[null,"Guava"]
[null,"Mango"]
[null,"Apple"]

{"sheet":"Sheet7","index":3,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Multiple Data Validation Drop Down List"]
[]
[null,"Dropdown List Starts from Below"]

{"sheet":"UDF","index":4,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Data Validation Drop Down List via UDF"]
[]
[null,"Fruit Names"]
[null,"Grapes"]
[null,"Orange"]
[null,"Guava"]
[null,"Mango"]
[null,"Apple"]

{"sheet":"Target","index":5,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Drop Down List from Different Sheet"]
[]
[null,"Dropdown List is Below"]

{"sheet":"Delete","index":6,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Deleting Data Validation Drop Down List"]
[]
[null,"Fruit Names"]
[null,"Orange"]