{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Employee Task ID","SUBSTITUTE With ADDRESS &COLUMN","CHAR With COLUMN","LEFT With ADDRESS, COLUMN & LEN","VBA Editor"],"read":"whole","date_system":"1900"}

{"sheet":"Employee Task ID","index":0,"n_rows":15,"n_cols":9,"rows_kept":15}
["Employee Name","Task 1 ID","Task 2 ID","Task 3 ID","Task 4 ID","Task 5 ID","Task 6 ID","Task 7 ID","Task 8 ID"]
["Ava Miller",1201,null,null,4523]
["William Clark",1202,7821]
["Sophia Lewis",1203,{"$nulls":4},9021]
["James Hall",1204,5522]
["Isabella Young",1205,{"$nulls":5},9999]
["Ethan Walker",1206,{"$nulls":4},3011]
["Mia Robinson",1207,4400]
["Daniel Wright",1208,null,null,6544]
["Harper Scott",1209]
["Lucas Harris",1210,9100]
["Amelia Baker",1211,{"$nulls":4},7201]
["Mason Adams",1212]
[]
["Last Column With Data"]

{"sheet":"SUBSTITUTE With ADDRESS &COLUMN","index":1,"n_rows":16,"n_cols":9,"rows_kept":16}
["Employee Name","Task 1 ID","Task 2 ID","Task 3 ID","Task 4 ID","Task 5 ID","Task 6 ID","Task 7 ID","Task 8 ID"]
["Ava Miller",1201,null,null,4523]
["William Clark",1202,7821]
["Sophia Lewis",1203,{"$nulls":4},9021]
["James Hall",1204,5522]
["Isabella Young",1205,{"$nulls":5},9999]
["Ethan Walker",1206,{"$nulls":4},3011]
["Mia Robinson",1207,4400]
["Daniel Wright",1208,null,null,6544]
["Harper Scott",1209]
["Lucas Harris",1210,9100]
["Amelia Baker",1211,{"$nulls":4},7201]
["Mason Adams",1212]
[]
["Last Column With Data",{"$f":"SUBSTITUTE(ADDRESS(1,MAX(IF(B2:I13<>\"\",COLUMN(B2:I13))),4),\"1\",\"\")","v":"H"}]
[null," "]

{"sheet":"CHAR With COLUMN","index":2,"n_rows":15,"n_cols":9,"rows_kept":15}
["Employee Name","Task 1 ID","Task 2 ID","Task 3 ID","Task 4 ID","Task 5 ID","Task 6 ID","Task 7 ID","Task 8 ID"]
["Ava Miller",1201,null,null,4523]
["William Clark",1202,7821]
["Sophia Lewis",1203,{"$nulls":4},9021]
["James Hall",1204,5522]
["Isabella Young",1205,{"$nulls":5},9999]
["Ethan Walker",1206,{"$nulls":4},3011]
["Mia Robinson",1207,4400]
["Daniel Wright",1208,null,null,6544]
["Harper Scott",1209]
["Lucas Harris",1210,9100]
["Amelia Baker",1211,{"$nulls":4},7201]
["Mason Adams",1212]
[]
["Last Column With Data",{"$f":"CHAR(64+MAX(IF(B2:I13<>\"\",COLUMN(B2:I13))))","v":"H"}]

{"sheet":"LEFT With ADDRESS, COLUMN & LEN","index":3,"n_rows":15,"n_cols":9,"rows_kept":15}
["Employee Name","Task 1 ID","Task 2 ID","Task 3 ID","Task 4 ID","Task 5 ID","Task 6 ID","Task 7 ID","Task 8 ID"]
["Ava Miller",1201,null,null,4523]
["William Clark",1202,7821]
["Sophia Lewis",1203,{"$nulls":4},9021]
["James Hall",1204,5522]
["Isabella Young",1205,{"$nulls":5},9999]
["Ethan Walker",1206,{"$nulls":4},3011]
["Mia Robinson",1207,4400]
["Daniel Wright",1208,null,null,6544]
["Harper Scott",1209]
["Lucas Harris",1210,9100]
["Amelia Baker",1211,{"$nulls":4},7201]
["Mason Adams",1212]
[]
["Last Column With Data",{"$f":"LEFT(ADDRESS(1,MAX(IF(B2:I13<>\"\",COLUMN(B2:I13))),4),LEN(ADDRESS(1,MAX(IF(B2:I13<>\"\",COLUMN(B2:I13))),4))-1)","v":"H"}]

{"sheet":"VBA Editor","index":4,"n_rows":15,"n_cols":9,"rows_kept":15}
["Employee Name","Task 1 ID","Task 2 ID","Task 3 ID","Task 4 ID","Task 5 ID","Task 6 ID","Task 7 ID","Task 8 ID"]
["Ava Miller",1201,null,null,4523]
["William Clark",1202,7821]
["Sophia Lewis",1203,{"$nulls":4},9021]
["James Hall",1204,5522]
["Isabella Young",1205,{"$nulls":5},9999]
["Ethan Walker",1206,{"$nulls":4},3011]
["Mia Robinson",1207,4400]
["Daniel Wright",1208,null,null,6544]
["Harper Scott",1209]
["Lucas Harris",1210,9100]
["Amelia Baker",1211,{"$nulls":4},7201]
["Mason Adams",1212]
[]
["Last Column With Data","H"]