Search found 2 matches

by Brian Cheyne
Thu Feb 17, 2022 1:14 pm
Forum: XLSReadWritwII 6
Topic: Reading XLS created with Google Sheets
Replies: 3
Views: 939

Re: Reading XLS created with Google Sheets

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.
by Brian Cheyne
Wed Feb 16, 2022 9:28 am
Forum: XLSReadWritwII 6
Topic: Reading XLS created with Google Sheets
Replies: 3
Views: 939

Reading XLS created with Google Sheets

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