Expoet in excel data
Posted: 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
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