1 public static void Export(System.Data.DataTable dt,NPOI.HSSF.UserModel.HSSFWorkbook workbook,
string FilePath)
2 {
3 if(dt.Rows.Count ==
0)
4 {
5 System.Windows.MessageBox.Show(
"尚未读取到任何数据");
6 return;
7 }
8 ISheet sheet = workbook.CreateSheet(
"导出数据");
9 HSSFCellStyle styleHeader =
(HSSFCellStyle)workbook.CreateCellStyle();
10 styleHeader.Alignment =
HorizontalAlignment.Center;
11 IFont font =
workbook.CreateFont();
12 font.FontHeight =
20 *
20;
13 font.Color =
HSSFColor.Red.Index;
14 styleHeader.SetFont(font);
15 HSSFCellStyle style =
(HSSFCellStyle)workbook.CreateCellStyle();
16 style.Alignment =
HorizontalAlignment.Center;
17 using(FileStream fs =
new FileStream(FilePath +
"\\导出数据.xls",FileMode.Create))
18 {
19 IRow rowHeader = sheet.CreateRow(
0);
20 for (
int col =
0; col < dt.Columns.Count; col++
)
21 {
22 ICell cellHeader =
rowHeader.CreateCell(col);
23 cellHeader.SetCellValue(dt.Columns[col].ColumnName);
24 sheet.SetColumnWidth(col,
30 *
256);
25 cellHeader.CellStyle =
styleHeader;
26 }
27 for (
int i =
1; i < dt.Rows.Count; i++
)
28 {
29 IRow row =
sheet.CreateRow(i);
30 for (
int j =
0; j < dt.Columns.Count; j++
)
31 {
32 ICell cell =
row.CreateCell(j);
33 cell.SetCellValue(dt.Rows[i -
1][j].ToString());
34 cell.CellStyle =
style;
35 }
36 }
37 workbook.Write(fs);
38 System.Windows.MessageBox.Show(
"保存成功");
39 }
40 }
转载于:https://www.cnblogs.com/zhaotianff/p/5843365.html
