Winform-C#DataGridView数据导出到Excel
一、窗体设计:
二、源码:
using System;
using System.Data;
using System.Windows.Forms;
using Microsoft.Office.Interop.Excel;
namespace ExportExcel
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
#region 自定义dt数据
System.Data.DataTable dt = new System.Data.DataTable();
dt.Columns.Add("ID", typeof(int));
dt.Columns.Add("姓名", typeof(string));
dt.Columns.Add("年龄", typeof(