Questions and answers on how to use XLSReadWriteII 5.
-
Charly
- Posts: 1
- Joined: Wed Apr 20, 2022 8:01 am
Post
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.
-
larsa
- Site Admin
- Posts: 926
- Joined: Mon Jun 27, 2005 9:30 pm
Post
by larsa »
Hello
Assigning values to cells will not do any formatting. Please take a look at the format cells sample.
Lars Arvidsson, Axolot Data