Hi all.
Im trying to process an excel Sheet in rows. Im trying to retrieve the
string contents of all the cells.
How do i replace empty cell contents with an empty string values.
Whenever i iterate, trailing empty cells are trimmed off, and empty rows return an empty array.
here is a simplified snippet from my code
I get rows with varying lengths and rowList is empty where the sheet has an empty row. i.e [] instead of [, , , , , ,..... , , ,]
Thanks in advance