首先添加引用,目前我机器上的Office版本是2010,根据版本不同选择的组件名称也会不同;
示例:
窗体代码:
using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; namespace Export2Excel { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void Form1_Load(object sender, EventArgs e) { dataGridView1.Rows.Add("张三", 12); dataGridView1.Rows.Add("李四", 9); } private void btnExport_Click(object sender, EventArgs e) { ExcelReport.Export(dataGridView1, "员工统计报表", "D:\\1.xlsx"); } } } |