Allow empty cells.

[BismeetSingh]

I am trying to read data from an excel file, but if a col has empty rows, the data from the next column gets moved to the previous column, thus shifting all cols by 1,how do I fix this?

Eg : 0: 5263 ​​​ 1: "Test" ​​​ 2: "Test 100" ​​​ 3: "09-04-00" ​​​ 4: "Female" ​​​ 5: "09-03-2022" ​​​ 6: "India" ​​​ 7: "Mumbai" ​​​ 8: "Mumbai 8 (Kim Verma)" ​​​ 9: "AB+ve" ​​​ 11: "KEM, Mumbai"

Logging it, you can see index 10 has been skipped here.