初始化DataTable和DataGridView,并调用以下方法
public static void ExportExcel(DataTable dt, DataGridView dgv)
{
if (dt == null || dt.Rows.Count == 0)
{
MessageBox.Show("无数据", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
List<string> listHeader = new List<string>();
List<string> listDPName = new List<string>();
for (int i = 0; i < dgv.Columns.Count; i++)
{
if (dgv.Columns[i].Visible && dt.Columns.Contains(dgv.Columns[i].DataPropertyName)
&& !listDPName.Contains(dgv.Columns[i].DataPropertyName))
{
listHeader.Add(dgv.Columns[i].HeaderText);
listDPName.Add(dgv.Columns[i].DataPropertyName);