Cell format Excel export

Questions and answers on how to use XLSReadWriteII 5.
Post Reply
Charly
Posts: 1
Joined: Wed Apr 20, 2022 8:01 am

Cell format Excel export

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

Re: Cell format Excel export

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
Post Reply