Export data in test or xls format
Posted: Fri Aug 14, 2009 2:28 pm
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.
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.