Axolot Data

It does not work.
So now to solve this problem I don't use XLSReadWrite but directly EXCEL_TLB.

Olivier.

Hi,

When I use the method AsFloat for writing a value like 8.8865e-18 the result in Excel is 0.
I need to export the real value, how could I solve this problem.
Delphi used: RAD Studio XE5.

Olivier.

I am still stuck.
Can anyone help me?

Hi Lars, Thank you for your answer. I have understood that the Definition property returns the formula used to set the dimension of the named range but I can't figure out how to use it to get the sheet index, the columns and the rows. Can you help me once more? Here is an example of definition I hav...

Any clues? Anyone?
It is becoming a bit urgent.

Thanks,

Maybe an example will help understanding my problem. In my excel file, I have only named ranges whose size is defined by OFFSET(ref, 0, 0, height, width). In the code, I need to read the values of those named ranges. To do so, I have tried the following code: function TfMain.CheckExcelFile(AExcelFil...

Hello,
I am still trying to make dynamic named ranges work. But whenever I do TXLSName.Area I get a nil.
Has anyone got a solution?

Thanks !

Hi, I would like to know if xlsReadWriteII is able to handle dynamic named ranges. I mean named ranges that are using the OFFSET() function for their definition, for example: OFFSET(ref;0;0;nblines;nbcols) where nblines and nbcols are numerical expressions depending on another (static) named cell. B...

Hi,

My problem is that the PNG picture is always inserted in the first sheet.
Here my code :
chartSheet:= xlsCompound[5];
chartSheet.Drawing.InsertImage(imgFileName,2,1,0,0,1);

Could you help me please ?

I use XLSReadWrite 5.10.20

Best regards.

Hi,

I have tried with the 5.10.20 version but it does not work.
For information, I am creating an xls file, not an xlsx file.

Best regards.

Hi,

I can't insert a WMF file in Excel.
I use as for bitmap the method described in the example :
- xlsCompound[0].Drawing.InsertImage(imgFileName,col,row,0,0,1);

Could you help me please ?

best regards.