Axolot Data

It's working now, thank you for the fix.

Hello, I have an xlsx file, I open it and get the exception 'Unknown ptgs "72"'. XLS := TXLSReadWriteII5.Create(nil); try XLS.CompressStrings := False; XLS.Filename := 'Test.xlsx'; XLS.Read; <<<<<<<<<<<<<<<< Exception: Unknown ptgs "72" finally FreeAndNil(XLS); end; I send you th...

Thank you, it's working now.

Hello Lars, I tried out your solution with version 5.20.48, but unfortunately it doesn't work. As far as I can see, the value of CompressStrings doesn't affect the content of the output file. I unpacked the two xlsx files (one with CompressStrings = True and one with False) and compared the files in...

I will try it, thank you.

Hello Lars, I managed to find out how to reproduce the error. With Swedish regional settings the output of the above program is Kôvàgò Kàlmàn 陰茎 Kôvàgò Kàlmàn If you change your Windows location to Hungary and the System Locale to Hungarian (Hungary) the output is Kôvŕgň Kŕlmŕn 陰茎 Kôvàgò Kàlmàn Plea...

Hello Lars,

I'm using Delphi XE7, so it is not likely that this is the cause of the error. Could you please write down what is the output of the sample previously sent to you?

Hello Lars, I'd like to put a string with some accented characters into a cell. The following line of code XLS[0].AsString[0, 0] := 'Kôvàgò Kàlmàn'; gives a wrong result in the Excel file: Kôvŕgň Kŕlmŕn If I append some Japanese characters to the string, like XLS[0].AsString[0, 1] := '陰茎 Kôvàgò Kàlm...

Thank you

Hello Lars,

Sample files sent.

Hello, I have a simple Excel input file containing data in the A1 and B1 cells. A1 has a date value: November 26th, 2014 and there's a formula in B1: =DATE(YEAR(A1);MONTH(A1)+3;DAY(A1)) Here is my code: procedure TForm1.btn1Click(Sender: TObject); var XLS: TXLSReadWriteII5; begin XLS := TXLSReadWrit...

Hello, I have a simple Excel file containing a drawing. With the following code I load and save the file: procedure TForm1.FormCreate(Sender: TObject); var XLS: TXLSReadWriteII5; begin XLS := TXLSReadWriteII5.Create(Self); try XLS.Filename := 'Input.xlsx'; XLS.Read; XLS.Filename := 'Output.xlsx'; XL...

Hello,

The very same error occurs again in 5.20.25 and 5.20.26 also.
Please fix it.

Hy, Will the XLSReadWritwII 5 support Delphi XE6? If yes, when it will be available? Thanks, Gabor Ps: On the download page (http://www.axolot.com/components/f_downloadreg.htm) the XLSReadWritwII 5 version number is still 5.20.21, but as I can see the latest version 5.20.24. I suggest you to correct...

Thanks in advance.