Hello, I am using XLSReadWriteII version 6.01.02. I'm trying to read an XLSX file sent to us from an outside vendor. When I call the Read function, I get a "List index out of bounds (0)" error. I notice when I open the file in Excel, it only shows a single "Sheet1". If I add a "Sheet2" in Excel, and save the file, I can open it with the XLSReadWriteII Read function without getting the "out of bounds" error. Is there some sort of workaround that I can use to read the file without having to manipulate it in Excel? I can email a sample file if necessary.
Thank you!