report desplaying elements with different format

[I_Pant]

Hello everyone.
I want to create an excel report to display the contents of an array. The problem is that I want the first column to be displayed in time format (e.g 00:00, 00:02,00:04, etc) and the other columns as DBL.
Any ideas please?
Thanx very much in advance guys...

[Norbert_B]

The format of array elements is always the same; so you cannot change it until the data is in Excel.
Since you want to change the way the values are displayed, you have to change properties of the cells. This can be done by ActiveX via the Excel-API.

hope this helps,
Norbert B.

Message Edited by Norbert B on 10-15-2007 08:49 AM

[I_Pant]

Hi Norbert,

I thought of that and I tried to format cells in the excel worksheet but no luck so far...

thanks anyway for your time

[Norbert_B]

This link maybe helps you further on how to set properties. Changing format of values is quite the same as backgroundcolor from the perspective of "how to do"....

Norbert