Page 1 of 1

Cell format Excel export

Posted: Thu Apr 21, 2022 12:12 pm
by Charly
Hello,

I try to export cells format as an integer or a float (numeric) to Excel but only dateTime seems work well.
Here is how I do :

Code: Select all

XLSReadWriteII51[NoFeuille].AsInteger[ICol,IRow]:=
XLSReadWriteII51[NoFeuille].AsFloat[ICol,IRow]:=
XLSReadWriteII51[NoFeuille].AsDateTime[ICol,IRow]:=
The cells format are still in "Standards" and I would like to convert it to a number.

Thanks for your help.

Re: Cell format Excel export

Posted: Fri Apr 22, 2022 3:49 pm
by larsa
Hello

Assigning values to cells will not do any formatting. Please take a look at the format cells sample.