Hl.Code/ExcelHelper.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Web;
using System.IO;
using org.in2bits.MyXls;

namespace Hl.Code
{
    public class ExcelHelper
    {
        /// <summary>
        /// 导出Excel[简单]
        /// </summary>
        /// <param name="dtSource">数据源</param>
        /// <param name="fileName">文件名</param>
        public static void ImportExcel(DataTable dtSource, string fileName)
        {
            XlsDocument xls = new XlsDocument();
            Worksheet sheet = xls.Workbook.Worksheets.Add("Sheet1"); xls.Workbook.Worksheets.Add("Sheet2"); xls.Workbook.Worksheets.Add("Sheet3");
            //填写表头
            foreach (DataColumn col in dtSource.Columns)
            {
                sheet.Cells.Add(1, col.Ordinal + 1, col.ColumnName);
            }
            //填充内容
            for (int i = 0; i < dtSource.Rows.Count; i++)
            {
                for (int j = 0; j < dtSource.Columns.Count; j++)
                {
                    sheet.Cells.Add(i + 2, j + 1, dtSource.Rows[i][j].ToString());
                }
            }
            //导出文件
            xls.FileName = fileName;
            xls.Send();
        }
    }
}