Axolot Data

Hi! I am using then new XLSReadWriteII 5.1 but I am having problems saving values as float: The Delphi code below results in a 'Floating point invalid operation' in function TXLSCellMMU.EncodeNumber: var ExcelFile : TXLSReadWriteII5; begin ExcelFile := TXLSReadWriteII5.Create(nil); ExcelFile.Filenam...

Hi.
I still don't get this working. Do you have any suggestions on how to change the above code so that it can
be executed without errors (for xls files)?
Is the code wrong or is it a bug in XLSReadWriteII 5?

Thanks in advance.

Hi.

Okay, thank you!
I will try that...

Hello. How do I change the NumberFormat for only one cell or for a specific row? If I am using e.g. XLS[0].Columns[0].Style.numfmt.value := '0%' it changes then numberformat for the whole sheet. I also tried XLS[0].Cell[0,1].numberFormat := '0%' in order to change the numberformat for Cell[0,1]. Thi...

Hi!
I downloaded the registered components from the appropriate download page and installed the new version but I cant find any delphi packages in the installation folder (just dcus, pas and inc files)
Is there a separate download for the packages?
Thanks in advance.

Hi. I have another question regarding the default author of the xls and the xlsx files. I see that the default author is set in Xc12DefaultData5.pas (const XLS_DEFAULT_DOCPROPS_CORE) and in XLSDefaultDataXLSX5.pas (const DEFAULT_DOCPROPS_CORE). If I change the author in the constant XLS_DEFAULT_DOCP...

My company recently purchased the new version of XLSReadWriteII. There is a small bug regarding the $I compiler directive for the file AxCompilers.inc. In some units e.g. BIFF_Names5.pas the directive is {$I ..\AxCompilers.inc} which is obviously wrong since the file AxCompilers.inc is located in th...

Hello. I am sorry, but there seems to be another problem in XLSReadWriteII 5. Setting the FontColor for multiple cells seems to be very very slow in the new version. I used this delphi code in my XLSReadWriteII4 test project in order to set the fontcolor for the cells: var ExcelFile4: TXLSReadWriteI...

Hello.

Okay, thanks.
I got the most of my code to work.
Nevertheless a help file would be nice.

Hello larsa. Thanks for the quick reply. >Before you can format a cell, there must first be a cell at the position. But there is already a cell. I use ExcelFile[0].InsertStringRowValues(0,0,['hallo', 'test']) in order to add two cells to the sheet (one with 'hallo' (A1) and a second one with 'test' ...

Hi. I got an error box '' some text formatting may have changed in this file because the maximum number of font was exceeded'' when setting the BorderBottomStyle for a xls (Excel97) file. And also ExcelFile.Items[0].Name does not seem to work properly Sample code: var ExcelFile : TXLSReadWriteII5; b...

Hi! I am trying to update to XLSReadWriteII Version 5. But it is hard to get the old code working with the new version. It seems that a lot of methods, types and units have changed but I found only a few changes in the changes.txt and also the examples in the 'Samples' folder are very minimalistic. ...

Is there any news? Maybe a release date?