Hi,
I have the two queries on Aspose.cells. Please provide the information about this:
1) I am importing the DataTable into worksheet and preparing chart with below code:
int cnt = oWorksheet.Cells.ImportDataTable(DtGraphData, true, 20, 0, true);
int chartIndex = oWorksheet.Charts.Add(ChartType.Column, 9, 9, 21, 15);
Chart chart = oWorksheet.Charts[chartIndex];
chart.NSeries.Add(“B22:B23”, true);
chart.NSeries.CategoryData = “A22:A23”;
//ASeries aSeries = chart.NSeries[0];
//aSeries.Name = “=B1”;
chart.IsLegendShown = true;
chart.Title.Text = “Analysis”;
This is works fine for me, but DataTable is importing into sheet in given row/column indexes. I need the DataTable data in Table format with border ‘2’. Could you please provide info how to achieve this?
2) and the other one is, I don’t want to see Cells in worksheet, only table and chart is enough for me. Is there any way to handle this?
Thanks,