private void CreateHeader(ExcelDoc excel)
{
int i = 1;
foreach (DataColumn column in _dt.Columns)
{
excel.setValue(1, i, column.ColumnName);
i++;
}
}
private void CreateBody(ExcelDoc excel)
{
int i = 2;
foreach (DataRow row in _dt.Rows)
{
for (int j = 0; j < row.ItemArray.Count(); j++ )
{
if (row.ItemArray[j].ToString() == string.Empty)
continue;
excel.setValue(i, (j + 1), row.ItemArray[j].ToString());
}
i++;
}
}