Axolot Data

Hi! It seems that the address property of hyperlinks does not return a correct value if I read an xls (Excel 97) file which contains a hyperlink (XLSReadWrite 5.10.12). Please see example: lString returns always 'file:///' . var ExcelFile5 : TXLSReadWriteII5; lString: String; begin //creating file w...

Hello

With V5.10.09 it seems to be vice versa.
On 64bit it works well but now I get a negative value if compiling the code above in 32bit.

Hi! The following code produces negative values in the excel output file when compiling with 64bit: var ExcelFile5 : TXLSReadWriteII5; begin ExcelFile5 := TXLSReadWriteII5.Create(nil); ExcelFile5.Filename := 'D:\output.xlsx'; ExcelFile5.Sheets[0].AsFloat[0,0] := 2937958862; <- is -1357008434 in the ...

I can confirm this. The problem still exists.
Just tested with my code above.

Thank you. Works for XLSX files. Unforatunately the hyperllinks in xls files are still broken (no address is set): var ExcelFile5 : TXLSReadWriteII5; begin ExcelFile5 := TXLSReadWriteII5.Create(nil); ExcelFile5.Version := xvExcel97; ExcelFile5.Filename := 'D:\output.xls'; ExcelFile5.Sheets[0].MakeHy...

Hi! I tried to create hyperlinks with the following code using XLS ReadWrite 5.10.07: var ExcelFile5 : TXLSReadWriteII5; begin ExcelFile5 := TXLSReadWriteII5.Create(nil); ExcelFile5.Filename := 'D:\output.xlsx'; ExcelFile5.Sheets[0].MakeHyperlink(0,0,'C:\Windows', 'C:\Windows' ); ExcelFile5.Write; e...

Hello. I got an access violation when trying to execute the following code on 64bit (xlsReadWrite 5.10.07): var ExcelFile5 : TXLSReadWriteII5; begin ExcelFile5 := TXLSReadWriteII5.Create(nil); ExcelFile5.Filename := 'D:\output.xlsx'; ExcelFile5.Sheets[0].AsFloat[0, 0] := 10000000; ExcelFile5.Write; ...

unfortunately it does not seem to be fixed.
Same error in V 5.10.07.

regards d3nton

I can also reproduce this issue in Delphi. It throws an 'List index out of bound exception' in unit BIUFF_READII5.pas procedure TXLSReadII.RREC_COLINFO; line 1252. Delphi sample code: var ExcelFile5 : TXLSReadWriteII5; begin ExcelFile5 := TXLSReadWriteII5.Create(nil); ExcelFile5.Version := xvExcel97...

Thank you. The EAccessViolation issue seems to be fixed. But now I got a corrupted xls file with the code above. Opening the created xls file in Excel results in the following message: Protected view - 'Office has detected a problem with the file. Editing it may harm your computer. Click more for de...

Thank you!

Hi! Thank you! Works great. Unfortunately I have a similar problem when trying to convert multiple cells into date format. I get the same EAccessViolation. I know, I should not access the cells directly for formatting multiple cells but I don't find a function similar to the cmdformat which converts...

Unfortunately the error seems not to be solved. With the code above (and the same excel file) I am getting a class Exception with message 'Row 0 Unknown Attribute "xmlns"'. An additional suggestion: It would be nice if XLSReadWrite would not raise an usual Exception (for the fErrorEvent or...

Hi! It seems that adding multiple sheets to a xls file does not work properly. Sample code: var ExcelFile : TXLSReadWriteII5; begin ExcelFile := TXLSReadWriteII5.Create(nil); ExcelFile.Filename := 'D:\output.xls'; ExcelFile.Version := Xc12Utils5.xvExcel97; ExcelFile.Add; ExcelFile.Add; ExcelFile.Add...

Hi!

Is there a way to create pivot tables in XLSReadWrite?
If so, it would be nice if you could give me a small example how to do this.
Thanks in advance.