Page 1 of 1

Export data in test or xls format

Posted: Fri Aug 14, 2009 2:28 pm
by 9336471
Hi,

When I try to save data (a lot of series with addXY method), with this code:

with TSeriesDataXLS.Create(PhysicalChart,nil) do
try
includeindex:=false;
IncludeHeader := True;
IncludeLabels := false;
SaveToFile('bidon.xls');
finally
Free;
end;
with TSeriesDataText.Create(PhysicalChart,nil) do
try
textdelimiter:=';';
includeindex:=false;
IncludeHeader := True;
IncludeLabels := false;
SaveToFile('bidon.csv');
finally
Free;
end;

I cannot obtain the name of the 'X' series with TSeriesdataText and 'X' and 'Y' series name with TSeries DataXLS. For example see the head and the first line of my two files:

in TXT mode:
X V0 X V1 X V2
0.11 2.406738281 0.11 0.986157238 0.11 1.868481398

in XLS mode
X Y X Y X Y
0.11 2.406738281 0.11 0.986157238 0.11 1.868481398

I want to obrtain this in my file:

Time V0 Time V1 Time V2
0.11 2.406738281 0.11 0.986157238 0.11 1.868481398

Thank you for any help.

Gérard.

Re: Export data in test or xls format

Posted: Mon Aug 17, 2009 8:22 am
by yeray
Hi Gérard,

If you have a name assigned to the X and/or to the Y value lists, they will be respected for the xls file, while the X name and the series name are used for the txt file. So you could try with that:

Code: Select all

  Chart1[0].XValues.Name := 'Time';
  Chart1[0].YValues.Name := 'V0';