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; //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?