Thanks for the update and it is working fine with that problem. With this new dll(7.7.2.5) ,I have another problem. I have a template as in attachment ,formatted alternate rows with grey color. Insert a table and save into EXCEL and PDF, Excel output is fine , PDf showing different. It was working fine with version 7.7.0.2. Please see attachments. Below is the code I have used
Aspose.Cells.LoadOptions loadOptions = new Aspose.Cells.LoadOptions(LoadFormat.Xlsx);
Aspose.Cells.Workbook workbook = new Aspose.Cells.Workbook("asposeTest1.xlsx", loadOptions);
Aspose.Cells.Worksheet ws = workbook.Worksheets[0];
int startCellRow = workbook.Worksheets.GetRangeByName("Start").FirstRow;
int startCellCol = workbook.Worksheets.GetRangeByName("Start").FirstColumn;
DataTable dt = new DataTable();
dt.Columns.Add();
dt.Columns.Add();
int total = 0;
DataRow dr1;
dr1 = dt.NewRow();
dr1[0] = "Item1";
dr1[1] = 3;
total = total + 3;
dt.Rows.Add(dr1);
dr1 = dt.NewRow();
dr1[0] = "Item2";
dr1[1] = 4;
total = total + 4;
dt.Rows.Add(dr1);
dr1 = dt.NewRow();
dr1[0] = "Item1";
dr1[1] = 5;
total = total + 5;
dt.Rows.Add(dr1);
int end = startCellRow + dt.Rows.Count;
DataTable dt_total = new DataTable();
dt_total.Columns.Add();
dt_total.Columns.Add();
DataRow dr2;
dr2 = dt_total.NewRow();
dr2[0] = "Total";
dr2[1] = total;
dt_total.Rows.Add(dr2);
ws.Cells.ImportDataTable(dt, false, startCellRow + 1, startCellCol, true, true);
ws.Cells.DeleteRow(startCellRow);
ws.Cells.DeleteRow(end);
ws.Cells.ImportDataTable(dt_total, false, end, startCellCol, false, true);
workbook.Save("ExcelReport_asop.xlsx", SaveFormat.Xlsx);
workbook.Save("Asposetest.pdf", SaveFormat.Pdf);