{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Master Sheet","Monthly Revenue","Company List","Vlookup","Mail IDs","Rename hyperlink","Sheet1"],"not_rendered":{"charts":0,"images":0,"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":"Master Sheet","index":0,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,1,1]]}
["XYZ Corporation Master Dashboard"]
[]
["Monthly Revenue ",{"$f":"HYPERLINK(\"#'Monthly Revenue'!B2\", \"Jan\")","v":"Jan"}]
[]
[]
[null,null,null,null,null,{"$f":"HYPERLINK(\"#'Monthly Revenue'!B2\", \"Jan Sales\")","v":"Jan Sales"}]

{"sheet":"Monthly Revenue","index":1,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Year (2023)","USD in '000s"]
["Jan",109.97800000000001]
["Feb",32.988999999999997]
["March ",329.96699999999998]
["April ",87.955999999999989]
["May ",164.989]
["June",175.97799999999998]
["July ",131.96699999999998]
["August ",153.97799999999998]
["September ",98.98899999999999]
["October ",219.989]
["November ",164.94499999999999]
["December",201.7]

{"sheet":"Company List","index":2,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Col_index_no.",1,2]
[null,"Company","Website"]
[null,"Google","https://www.google.com/"]
[null,"Apple","https://www.apple.com"]
[null,"Amazon","https://www.amazon.com"]
[null,"Microsoft","https://www.microsoft.com"]
[null,"Facebook","https://www.facebook.com"]

{"sheet":"Vlookup","index":3,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Vlookup","Hyperlink"]
[null,"Google",{"$f":"HYPERLINK(VLOOKUP(B3,'Company List'!B3:C3,2,FALSE),\"Google\")","v":"Google"}]

{"sheet":"Mail IDs","index":4,"n_rows":5,"n_cols":12,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Email ID","Customer Name","Email Subject ","Email Link "]
["JOHN JOE","John Doe","Happy Birthday ",{"$f":"HYPERLINK(\"mailto:\" & A2& \"&Subject=Happy Birthday\", \"link\")","v":"link"}]
["jane.smith@example.com","Jane Smith","Happy Birthday ",{"$f":"HYPERLINK(\"mailto:\" & A3& \"&Subject=Happy Birthday\", \"link\")","v":"link"},null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"mailto:\" & A2& \"&Subject=Happy Birthday\", \"link\")","v":"link"}]
["emily.johnson@example.com","Emily Johnson","Happy Birthday ","link",null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"mailto:\" & A3& \"&Subject=C2\", \"link\")","v":"link"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"mailto:\" & A4& \"&Subject=C2\", \"link\")","v":"link"}]

{"sheet":"Rename hyperlink","index":5,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Microsoft","Website Link"]

{"sheet":"Sheet1","index":6,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Company Website"]
[{"$f":"HYPERLINK(\"www.google.com\",\"Google\")","v":"Google"}]
["Apple"]
["Microsoft"]