Expoet in excel data

TeeChart for ActiveX, COM and ASP
Post Reply
Amol
Advanced
Posts: 176
Joined: Mon May 29, 2006 12:00 am

Expoet in excel data

Post by Amol » Tue Apr 23, 2013 7:48 am

Hi,

I am working on export data feature in ActiveX-Tchart -7.0 version where I need to export data in Excel format. I have done it successfully but when data is exported the X-column exported shows time in days format as shown below, while I need to export it in Date format i.e. DD/MM/YYYY
Time Data
27942 0
27973 0
28004 0
28034 0
28065 0
28095 0
28126 0

When I am exporting data in Text file format, T-Chart automatically converts X column data in Date format as shown below.
Time Data
7/1/1976 0
8/1/1976 0
9/1/1976 0
10/1/1976 0
11/1/1976 0

Please suggest if there is any option while exporting data to Excel, that user can change the time format of any column.


Regards,
Amol

Yeray
Site Admin
Site Admin
Posts: 9614
Joined: Tue Dec 05, 2006 12:00 am
Location: Girona, Catalonia
Contact:

Re: Expoet in excel data

Post by Yeray » Tue Apr 23, 2013 1:46 pm

Hi Amol,

Sounds like this and this, isn't it?
Best Regards,
ImageYeray Alonso
Development & Support
Steema Software
Av. Montilivi 33, 17003 Girona, Catalonia (SP)
Image Image Image Image Image Image Please read our Bug Fixing Policy

Post Reply