1.首先引用到的一个NPOI的dll文件;
2.构造一个datatable类型数据;
3、导出操作:直接上代码:
string path=T_SavePath.Text+"NoExcel导出数据"+DateTime.Now.ToString("yyyyMM")+".xls";
HSSFWorkbook hswk = new HSSFWorkbook();
ISheet sheet1 = hswk.CreateSheet("sheet1");
IRow colum = sheet1.CreateRow(0);
for (int i = 0; i < dt.Columns.Count; i++)
{
colum.CreateCell(i).SetCellValue(dt.Columns[i].ColumnName);
}
for (int i = 0; i < dt.Rows.Count; i++)
{
IRow row=sheet1.CreateRow(i+1);
for (int j = 0; j < dt.Columns.Count; j++)
{
row.CreateCell(j).SetCellValue(dt.Rows[i][j].ToString());
}