Export Data to Excel

[Centrii]

Hello,

I have a proplem regading TeeChart Export Data to Excel.
Is it possible to export into a real Excel Format?
Right now I get an Export in HTML-Style, like this:

<table border="1">
<tr><td>Index</td><td>Date</td><td>Close</td><td>High</td><td>Low</td><td>Open</td><td>X</td><td>Y</td></tr>
<tr><td>0</td><td>39927.3624740856</td><td>277.887363547407</td><td>279.109581609773</td><td>277.580790470159</td><td>278</td><td>39927.3624740856</td><td>192</td></tr>
</table>

My Source:

Code: Select all

                Steema.TeeChart.Export.ExcelFormat excel = MyC_Alarme.Export.Data.Excel;
                excel.IncludeHeader = true;
                excel.IncludeIndex = true;
                excel.IncludeLabels = true;
                excel.TextLineSeparator = ";";
                excel.Save(Server.MapPath(Filename)); 

The Version is TeeChart for .Net v3 (V 3.5.3371.26406)

I hope someone can help me out with this issue.


Is it possible to use the TeeChart Export Dialog in ASP.Net?

greets Centrii

[Narcís]

Hi Centrii,

I have a proplem regading TeeChart Export Data to Excel.
Is it possible to export into a real Excel Format?

Yes, it works fine for me here doing as in the All Features\Welcome !\Exporting\Chart Data\Excel example at the features demo, available at TeeChart's program group, for example:

Code: Select all

			tChart1.Export.Data.Excel.Series = null; // export all series
			tChart1.Export.Data.Excel.IncludeLabels = true;
			tChart1.Export.Data.Excel.IncludeIndex = true;
			tChart1.Export.Data.Excel.IncludeHeader = true;
			tChart1.Export.Data.Excel.Save(@"c:\temp\myexcel.xls");

Is it possible to use the TeeChart Export Dialog in ASP.Net?

I'm afraid not. TeeChart dialogs are not supported in ASP.NET applications.

[Centrii]

Hi Narcís,

thank you for your answer, but anyway, if I export a Chart with the Feature Demo All Features\Welcome !\Exporting\Chart Data\Excel example, I can open it with Excel, but it is in HTML-Style like I described it before.
If I open the exported .xls -File of the Example with an Editor, the .xls - File looks like

<table border="1">
<tr><td>Index</td><td>Text</td><td>Bar</td><td>Text</td><td>Bar</td></tr>
<tr><td>0</td><td>1st</td><td>3</td><td>1st</td><td>2</td></tr>
<tr><td>1</td><td>2nd</td><td>0</td><td>2nd</td><td>-2</td></tr>
<tr><td>2</td><td>3rd</td><td>-3</td><td>3rd</td><td>3</td></tr>
</table>

Maybe that´s normal, but in my opinion it still looks like HTML.
I´m glad that the result of the Feature Demo is the same like mine.

In this case I will take comma seperated Text.

Thanks, Centrii

[Narcís]

Hi Centrii,

Sorry, I didn't check interanl format. Yes, you are right. I've added your request to the wish-list to be enhanced for future releases.