Axolot Data

I have clients that use Google Sheets and then save the file as and XLSX. When I try to read it I get the following error :

ExceptionMessage="Can not find workbook in OPC"

I use Delphi RAD Studio 11 with XLSReadWrite version 6.01.10

Hello

Try:

Thank you Lars. I can now read the Sheet.

I have an import function that reads all sizes of Excel files and I rely on the functions FirstCol, LastCol and LastRow to find out how much data I have. These all return -1. If I interrogate Cell[0,0] the value is there, but all those functions return -1.

Hello

Use this before reading First/Last: