首页

liuying

2024-12-11 3b8b9cba9ebe15ff4ae1a7d8cb483d1f0ffcfa85

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
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);
        }
    }
}