Exception when reading a xlsx file

Questions and answers on how to use XLSReadWriteII 5.
Post Reply
d3nton
Posts: 137
Joined: Thu Oct 25, 2012 9:48 am

Exception when reading a xlsx file

Post by d3nton »

Hello!
I receive an error when trying to read a specific excel file. I am using the latest XLSReadWrite version 6.01.16.
The file can be downloaded from the link below:
https://jamsoftwaregmbh.sharepoint.com/:u:/t/Fileshare/EXpH5sR65qhNn_KE5W3EnMoB3xaNnPKXiDClXeFbNejg3Q?e=bI98p0
Code to read the file:

Code: Select all

  var lxls := TXLSReadWriteII5.Create(self);
  lxls.filename := 'D:\test.xlsx';
  lxls.Read;
The callstack:

Code: Select all

Main Thread ($18a0), inner exception level 1:
>> Exception, Can not find file xl/xl/drawings/drawing1.xml in ZIP
0167bb1b SEPATransfer.exe XLSReadWriteZIP5                      230   +3 TXLSZipArchiveIntfXLS.OpenStream
01685811 SEPATransfer.exe XLSReadWriteOPC5                     1036   +1 TOPCContainer.ItemOpenStream
01689e12 SEPATransfer.exe XLSReadWriteOPC5                     1693   +1 TOPC_XLSX.ReadItemData
0168a921 SEPATransfer.exe XLSReadWriteOPC5                     1776   +3 TOPC_XLSX.OpenAndReadDrawing
019c9422 SEPATransfer.exe XLSReadXLSX5                         1582   +1 TXLSReadXLSX.ReadDrawing
019cab0c SEPATransfer.exe XLSReadXLSX5                         1909 +265 TXLSReadXLSX.ReadSheet
019cb4d7 SEPATransfer.exe XLSReadXLSX5                         2069  +16 TXLSReadXLSX.ReadSheets
019c5efb SEPATransfer.exe XLSReadXLSX5                          517  +15 TXLSReadXLSX.LoadFromStream
01a374c5 SEPATransfer.exe XLSReadWriteII5                      1007  +17 TXLSReadWriteII5.LoadFromStream
01a37290 SEPATransfer.exe XLSReadWriteII5                       970  +66 TXLSReadWriteII5.LoadFromFile
01a375f7 SEPATransfer.exe XLSReadWriteII5                      1047   +1 TXLSReadWriteII5.Read
01a3a4c4 SEPATransfer.exe Jam.XLSReadWrite                      586   +2 TJamXLSReadWrite.Read
Could you please fix this issue? Thank you!

Best regards
d3nton
Posts: 137
Joined: Thu Oct 25, 2012 9:48 am

Re: Exception when reading a xlsx file

Post by d3nton »

Is there a solution to this? If further information is needed, I am happy to provide it.
Post Reply