WD24: set type of column in Excel

Hi,

Using xlsDocument and xlsCell and so on, I have a routine to export data.
The columns in Excel are always of the general type.
I want to set the type of a Excel column explicitly to short date or long date of numeric.

The help however says about xlsCell.Type "This property is available in read-only." and indeed when trying to change the type of a cell, it throws an error. Same thing for xlsCOlumn.DefaultCell

Are there other ways to set the type of an Excel column?

Arie

Hi Arie,

use object Automation, then you can do everything ; for example

xl is object Automation "Excel.Application" // Create OLE object

...


xl>>ActiveSheet>>columns("I:I")>>select()
xl>>Selection>>NumberFormat = "0.00"

regards, Heinz

Thanks Heinz

that works.

Arie