Group: Forum Members
Last Active: 3 Years Ago
Posts: 4,
Visits: 5
|
Thank you for the information. I am using the DataGridView which can be customize. Added code to export to excel from the DataGridView. Will look again at the NDataGridView. Thanks again, Paul
|
Group: Forum Members
Last Active: Last Week
Posts: 3,054,
Visits: 4,009
|
Hello Paul, The Caption of the created column can be changed by changing the name of the respective data series in the chart, for example: series.Labels.Name = "MyColumn";You cannot export a data series to a specific (pre-created) DataTable column, but since you can set the column name this shouldn't be a problem. Regarding export to Excel spreadsheets - currently the chart doesn't provide such functionality.
Best Regards, Nevron Support Team
|
Group: Forum Members
Last Active: 3 Years Ago
Posts: 4,
Visits: 5
|
NChart chart = nChartControl1.Charts[0]; NDataSeriesCollection arrSeries = new NDataSeriesCollection(); NSmoothLineSeries movedata = (NSmoothLineSeries)chart.Series[0]; arrSeries.Add(movedata.Labels, DataSeriesMask.Labels); dataView1.Table = arrSeries.ExportToDataTable(sTableName);
How do you rename the column heading "Labels" to something else?
Can it be done with dataView1.Table.Columns.Add(...) If it can be renamed here or added here, how would you add the data to that specific column?
Third question: Ctrl A,Crtl C then Ctrl V on excel spreadsheet will transfer the data. Can it be exported to an excel spreadsheet with DDE or oleDb?
Thank you, Paul
|