Axolot Data

I trying your Demo projects in Delphi 2007 and Delphi 2009. When I try with Excel 97-2003 all work good with Russian charset (Delphi 2007 and 2009). When I trying with Excel 2007 Russian symbols don't read. In Delphi 2007 I have empty string instead of Cell with Russian symbols. In Delphi 2009 I have string with '?' instead of Cell with Russian symbols. When I save file with XLSReadWrite, Excel 2007 cann't open it.

What the problem? May be in Vista or may be you cann't work correct with utf-8 in xlsx format?

Hello

There seems to be a problem with the UTF-8 decoding in Excel 2007 files. I will fix this asap.

hi, i'm encountering the same problem reading xls2007 with Slovak charset...

Hello

This is fixed in update 4.00.26

Hi, i've tested the .26 version, but i'm still getting same results - empty strings read from cells containing special slovak characters.
I'm using XLS.Sheets[0].AsFmtString[7,0] syntax to access the cells.

Hello

Can you please send me a sample of this file?

I testing versin .30. Now Russian Charset work correct. BUT I have other problem. After work with xlsx file, I save it and try open with MS Office 2007. MS Office 2007 say that :
"There is not readble data. Try to restore data?" (translate from Russian). Then MS say: "Delete component: path /xl/styles.xml with error XML (styles) impossible char xml. row 1, columns 5152.
Restore records: Information about cells from path /xl/worksheets/sheet1.xml".

Then MS Office open file, but there aren't borders and background colors.

Hello

Please send me the file.

I send to components@axolot.com

procedure TForm1.btn1Click(Sender: TObject);
begin
xls1.Version := xvExcel2007;
xls1.Sheet[0].AsInteger[1,1] := 90;
xls1.Filename := 'c:\aa.xlsx';
xls1.Write;
end;

'c:\aa.xlsx'; could not open by Excel 2007 , why?