Hi,
a):
i)If insertRow is true when importing a DataTable, we will
insert rows at the row after firstRow and copy
the style of the first row to the inserted rows, then copy the first row to firstRow
+ insertedNumber and clear the first row.
For your issue, please insert row before importing DataTable
.
ii)If you update the cell and the cell is in the header row
of ListObject(Table) in MS Excel, MS will change the name of the ListColumn.
We do not auto-change the name of the ListColumn, so if you
want to replace the first row with the field name, please update the name of
ListColumn
With the method ListObject.UpdateColumnNames
Please
check the following code:
internal void Test()
{
Workbook
workbook = new Workbook();
workbook.Open(@"F:\FileTemp\template1.xlsx");
//workbook.IsTemp2007
= true;
Cells
cells = workbook.Worksheets[0].Cells;
//cells["A1"].PutValue("sdfsdfsdf");
DataTable
dataTable = new DataTable();
dataTable.Columns.Add();
dataTable.Rows.Add("sdf");
dataTable.Rows.Add("sdf");
dataTable.Rows.Add("sdf");
dataTable.Rows.Add("sdf");
dataTable.Rows.Add("sdf");
////
dataTable.Load(sqlDataReader);
cells.InsertRows(1,
dataTable.Rows.Count);
bool
exportFieldName = true;
if
(exportFieldName)
{
cells.ImportDataTable(dataTable, true, 0, 0, false);
workbook.Worksheets[0].ListObjects[0].UpdateColumnNames();
}
else
{
cells.ImportDataTable(dataTable, false, 1, 0, false);
}
//
workbook.Worksheets[0].ListObjects[0].ListColumns[2].Name =
"sdfsdfsDF";
workbook.Save(@"F:\FileTemp\dest.xlsx");
}
b):
We have fixed the issue of Conditional formatting.
Thank you.