using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Windows.Forms;using NPOI.SS.UserModel;    //NPOIusing NPOI.HSSF.Util;      //NPOIusing NPOI.HSSF.UserModel;   //NPOIusing NPOI.XSSF.UserModel;   //NPOIusing System.IO;namespace ESMT{  public class ExportExcel  {    /// <summary>    ///     /// </summary>    /// <param name="grdview">數(shù)據(jù)表</param>    /// <param name="sheetName">工作簿名字</param>    /// <param name="FilePath">文件路徑</param>    /// <param name="columnTitle">列頭</param>    public void ExportToExcel(DataGridView grdview, string sheetName, string FilePath, string[] columnTitle)    {      //不允許dataGridView顯示添加行，負(fù)責(zé)導(dǎo)出時(shí)會(huì)報(bào)最后一行未實(shí)例化錯(cuò)誤      grdview.AllowUserToAddRows = false;      HSSFWorkbook workbook = new HSSFWorkbook();      ISheet sheet = workbook.CreateSheet(sheetName);//創(chuàng)建工作簿      //設(shè)置表頭      IRow headerRow = sheet.CreateRow(0);//創(chuàng)建第一行      headerRow.HeightInPoints = 40;      headerRow.CreateCell(0).SetCellValue("出庫(kù)表單");//單元格賦值      ICellStyle headStyle = workbook.CreateCellStyle();      headStyle.Alignment = NPOI.SS.UserModel.HorizontalAlignment.Center;//格式居中      IFont font = workbook.CreateFont();      font.Boldweight = 500;      font.FontHeightInPoints = 20;      headStyle.SetFont(font);      headerRow.GetCell(0).CellStyle = headStyle;      sheet.AddMergedRegion(new NPOI.SS.Util.CellRangeAddress(0, 0, 0, grdview.ColumnCount - 2));//單元格合并 最后個(gè)參數(shù)是合并個(gè)數(shù)      IRow headerRow2 = sheet.CreateRow(1);//創(chuàng)建第二行列頭      ICellStyle headStyle2 = workbook.CreateCellStyle();      headStyle2.Alignment = NPOI.SS.UserModel.HorizontalAlignment.Center;      IFont font2 = workbook.CreateFont();      font2.FontHeightInPoints = 10;      font2.Boldweight = 700;      headStyle2.SetFont(font2);      for (int l = 0; l < grdview.ColumnCount - 1; l++) //列頭填值      {        headerRow2.CreateCell(l).SetCellValue(columnTitle[l]);        headerRow2.GetCell(l).CellStyle = headStyle2;      }      //設(shè)置列寬      for (int l = 0; l < grdview.Columns.Count; l++)      {        sheet.DefaultColumnWidth = 15;      }      //填寫(xiě)內(nèi)容      for (int i = 0; i < grdview.Rows.Count; i++)      {        IRow row = sheet.CreateRow(i + 2);        for (int j = 1; j < grdview.Columns.Count; j++)        {          row.CreateCell(j - 1, CellType.String).SetCellValue(grdview.Rows[i].Cells[j].Value.ToString());//j-1表示哪個(gè)單元格        }      }      using (FileStream stream = File.OpenWrite(FilePath))//創(chuàng)建Excel并寫(xiě)入數(shù)據(jù)      {        workbook.Write(stream);        stream.Close();      }      GC.Collect();    }  }}

string[] columnTitle = { "序號(hào)", "倉(cāng)位", "Facility", "供應(yīng)商料號(hào)", "料號(hào)", "料卷ID", "料卷數(shù)量", "儲(chǔ)位號(hào)", "Date Code/Lot", "生產(chǎn)日期", "供應(yīng)商編碼", "入倉(cāng)時(shí)間" };      string localFilePath = "";// fileNameExt, newFileName, FilePath;       SaveFileDialog sfd = new SaveFileDialog();//保存文件窗口      //設(shè)置文件類(lèi)型       sfd.Filter = "Excel(97-2003)|*.xls";//保存類(lèi)型為EXCEL      //保存對(duì)話框是否記憶上次打開(kāi)的目錄       sfd.RestoreDirectory = true;      //點(diǎn)了保存按鈕進(jìn)入       if (sfd.ShowDialog() == DialogResult.OK)      {        localFilePath = sfd.FileName.ToString(); //獲得文件路徑         ex.ExportToExcel(grdData, "出庫(kù)表單", localFilePath, columnTitle);      }