Error reading excel 97-2003 spreadsheet

Questions and answers on how to use XLSReadWriteII 5.
Post Reply
JSadler
Posts: 1
Joined: Tue Feb 19, 2013 3:42 am

Error reading excel 97-2003 spreadsheet

Post by JSadler »

Hi,

I have just installed the latest XLSReadWriteII5 v5.10.00 component and when I try and load a spreadsheet i get the error
"Error on reading record # 366, 00BD Offs: 00003454Invalid Floating point operation". This error occurs when the FExcelFile.Read statement executes.

The same spreadsheet can be loaded using XLSReadWriteII4 and Excel 2007.

The code I am using is
var
FExcelFile: TXLSReadWriteII5;
begin
FExcelFile := TXLSReadWriteII5.Create(nil);
FExcelFile.Filename := 'Y:\Imports\blaa\Test\help\investors377.xls';
FExcelFile.Read;
end;

Can you please investigate to see what is wrong? Whats the best way to send the example excel file causing the error?

Thanks

Jeff
Post Reply