Exporting Date with Excel

[Guilz]

Hi,

Questions about exporting date with Teechart Pro 7.0:
If I export my Teechart chart data with

Code: Select all

.Export.asXLS

My date are not showing correct format

export_excel.jpg (74.09 KiB) Viewed 11354 times

Now, If I export data with following code

Code: Select all

.Export.asText

My date are in correct format but when Excel is launching I've the following alert message:

export_text.jpg (27.46 KiB) Viewed 11311 times

export_excel_data.jpg (56.88 KiB) Viewed 11341 times

So, what is the best way to export to excel data whith date ?
Is Teechart Pro 8.0 displaying date correctly when exporting to excel ?

Thanks a lot for your help

Guilz

[Narcís]

Hi Guilz,

The same problem and solution were described here.

[Guilz]

Hi Guilz,

The same problem and solution were described here.

Thanks Narcis - I had already read this topic before posting...
I don't think we can speak about solution if we must reopen Excel file after each export and set each datetime column as datetime field instead of general field type

Guilz

[Yeray]

Hi Guilz,

I'm not getting any error with the following code in TeeChart AX v8 and Office 2003. Could you please try if it works fine for you?

Code: Select all

Private Sub Form_Load()
  TChart1.Aspect.View3D = False

  TChart1.AddSeries scLine

  TChart1.Series(0).XValues.DateTime = True
  
  Dim month, year, i As Integer
  i = 0
  For year = 2003 To 2009
    For month = 1 To 12
      TChart1.Series(0).AddXY DateValue("1/" & Str$(month) & "/" & Str$(year)), Sin(i / 10), "", clTeeColor
      i = i + 1
    Next month
  Next year

  TChart1.Export.asText.SaveToFile "C:\tmp\test.xls"
End Sub

[Guilz]

Yeray,

I confirm - This Excel Messagebox appear only with Office 2007.
We don"t have this issue with previous version of Excel.

Regards,

Guilz

[Yeray]

Hi Guilz,

Yes, I've verified that this error appears in office 2007.
So, as you've seen there are two possibilities:

- asXLS: works without any error at all. But, as Narcís explained, as delphi saves the numbers as doubles, you'll see doubles instead of dates in the first column. And then you can set this column to Date format in Excel.

- asText: gives a format error in Office 2007 but it still opens the file and displays all the columns as you had them in TeeChart as it saves the strings.

[Guilz]

Hi Yeray,

Right - both are not fantastic
I will try to use the second one and before opening the Excel file use excel.Application object and save it as true xls with DisplayMessage = false...Not cool to patch the asText method because asXLS method does not work...

Good idea to do something in Teechart v9 no ?

Regards,

Guilz

[Yeray]

Hi Guilz,

Yes, I've added this to the wish list to be revised in future releases (TV52014461).

[Guilz]

Thanks a lot Yeray

Guilz