Export data in test or xls format

[Dge]

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.

[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';