using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace iWareCommon.Utils
{
public class ExcelHelper
{
///
/// 将DataGridView的数据导出到Excel中
///
///
///
///
///
public static void ExcelExport(DataGridView dgv, List dataSourceList, string exportFileName)
{
string[] columns = new string[dgv.Columns.Count];
string[] columnNames = new string[dgv.Columns.Count];
for (int i = 0; i < dgv.Columns.Count; i++)
{
columns[i] = dgv.Columns[i].DataPropertyName;
columnNames[i] = dgv.Columns[i].HeaderText;
}
DataTable dt = new DataTable();
dt = DataTableHelper.CopyToDataTable(dataSourceList, columns, columnNames);
WZ.Useful.Commons.ExcelHelper.DataSetToExcel(dt, exportFileName);
}
}
}