Exporting to Excel and Text files

TeeChart VCL for Borland/CodeGear/Embarcadero RAD Studio, Delphi and C++ Builder.
Post Reply
billyt
Newbie
Newbie
Posts: 6
Joined: Fri Nov 15, 2002 12:00 am

Exporting to Excel and Text files

Post by billyt » Fri Feb 27, 2004 6:25 am

I can't seem to get the Y labels exported into XLS or CSV files as headings

See attached File. The only label that comes out is 'Y', and the word 'Text' for the X labels

If I try the same thing with XML or HTML, I get the 'Y'labels coming out correctly.

This is with a fastline series.

I'm using version 6.01 of Tee Chart with BC6.

Any ideas ?

Bill

Text Y Text Y
d1 d1
01 01
02 40.75 02 505.9167175
03 42.38333511 03 506.5833435
04 43.5166626 04 509.083374
05 43.08333206 05 508.1500244
06 43.00000381 06 506.1000061
07 41.25 07 506.2333679
08 112.9666672 08 235.6999969
09 233.25 09 0.06666667
10 227.7833405 10 0.050000001
11 284.8333435 11 0
12 295.8999939 12 0.050000001
13 306.6166687 13 0.050000001
14 276.5166626 14 0.083333336
15 158.8500061 15 211
16 44.68333435 16 452.6166687
17 43.41666794 17 490.2833252
18 42.04999924 18 535.8500366
19 40.11666489 19 537.166687
20 41.78333664 20 539.583313
21 43.26667404 21 545.2999878
22 44.66666794 22 553.9833374
23 40.48333359 23 548.5499878
d2 40.93333054 d2 542.583374

Marjan
Site Admin
Site Admin
Posts: 745
Joined: Fri Nov 07, 2003 5:00 am
Location: Slovenia
Contact:

Post by Marjan » Fri Mar 05, 2004 4:17 pm

Hi, Bill.

Hm.... There are no Y labels. Each point can only have one point label and this is stored in XLabels array. When you export data, XLabels (point labels) will be saved under the "Text" column. So, if you have series with defined x,y and point labels, you'll end up with three columns : Text, X (optional) and Y.
Looking at your example, you have two different series with y and labels (text) columns ? I think the v6.01 version has a bug in the Excel export format with the end result being all columns are not exported correctly. I tried the same thing with the latest TeeChart versinon (v 7.0, just to be released) and it worked fine (four columns with correct values for both series).
Marjan Slatinek,
http://www.steema.com

billyt
Newbie
Newbie
Posts: 6
Joined: Fri Nov 15, 2002 12:00 am

Post by billyt » Sun Mar 07, 2004 1:24 am

Thanks for checking this and coming back with comments. I am just about to download a beta release of version 7.0, so hopefully I'll be right with this.

Bill

Post Reply