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.