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);
        }
    }
}