using NPOI.HSSF.UserModel;using NPOI.SS.UserModel;using System;using System.Data;using System.IO;using System.Windows.Forms;namespace Excel导出示例{ public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void btnIn_Click(object sender, EventArgs e) { OpenFileDialog ofd = new OpenFileDialog(); ofd.Filter = "xls|*.xls|xlsx|*.xlsx"; ofd.ShowDialog(); string file = ofd.FileName; Import(file); } private void btnOut_Click(object sender, EventArgs e) { SaveFileDialog sfd = new SaveFileDialog(); sfd.ShowDialog(); string file = sfd.FileName; Outport(this.dataGridView1.DataSource as DataTable, file); } #region 导入 private void Import(string filePath) { try { FileStream file = new FileStream(filePath, FileMode.Open, FileAccess.Read); HSSFWorkbook hssfworkbook = new HSSFWorkbook(file); ISheet sheet = hssfworkbook.GetSheetAt(0); DataTable dt = new DataTable(); for (int j = 0; j < (sheet.GetRow(0).LastCellNum); j++) { dt.Columns.Add(sheet.GetRow(0).Cells[j].ToString()); } System.Collections.IEnumerator rows = sheet.GetRowEnumerator(); rows.MoveNext();//跳过第一行 while (rows.MoveNext()) { HSSFRow row = (HSSFRow)rows.Current; DataRow dr = dt.NewRow(); for (int i = 0; i < row.LastCellNum; i++) { NPOI.SS.UserModel.ICell cell = row.GetCell(i); if (cell == null) { dr[i] = null; } else { dr[i] = cell.ToString(); } } dt.Rows.Add(dr); } this.dataGridView1.DataSource = dt; this.dataGridView1.Refresh(); } catch (Exception e) { MessageBox.Show(e.Message); } } / / Excel文件导成Datatable / / Excel文件目录地址 / Datatable表名 / Excel sheet index / 参考文章：
1.http://www.cnblogs.com/colder/p/3611906.html.
2.http://www.cnblogs.com/zhuawang/archive/2012/12/12/2815367.html.