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
|
{
|
/// <summary>
|
/// 将DataGridView的数据导出到Excel中
|
/// </summary>
|
/// <typeparam name="T"></typeparam>
|
/// <param name="dgv"></param>
|
/// <param name="dataSourceList"></param>
|
/// <param name="exportFileName"></param>
|
public static void ExcelExport<T>(DataGridView dgv, List<T> 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);
|
}
|
}
|
}
|
