ExcelConfig

最新推荐文章于 2024-09-13 07:40:13 发布

hyhyct

最新推荐文章于 2024-09-13 07:40:13 发布

阅读量1.2k

点赞数

分类专栏： excel

本文链接：https://blog.csdn.net/hyhyct/article/details/9475149

版权

ExcelConfig类是一个用于设置和生成Excel的配置文件，它支持从GridView或DataTable获取数据。类提供了设置输出文件名、路径、工作表名称、表头和内容的方法，并能根据数据类型自动填充内容。此外，还提供了是否从模板加载、是否存在宏等属性。

摘要由CSDN通过智能技术生成

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Collections.Generic;
using System.Drawing;

/// <summary>
/// 用于设置打印输出的Excel配置文件
/// </summary>
public class ExcelConfig
{
    private object _data = null;
    private bool _isGridView = true;
    private bool _isDataTable = false;

    private bool _isfromtemplate = false;
    private string _exportexcelfilename = "";
    private string _exportexcelfilepath = "";
    private string _templatefilename = "";
    private string _templatefilepath = "";
    private string _sheetname = null;
    private string[] _headertext = null;
    private string[,] _contenttext = null;
    private string _headertitle = "";
    private bool _hasmacro = false;
    private string _macro = "";

    public ExcelConfig()
    {
        this._data = null;
        this._isGridView = false;
        this._isDataTable = false;
        initConfig();
    }
    public ExcelConfig(DataTable dt)
    {
        this._data = dt;
        this._isGridView = false;
        this._isDataTable = true;
        initConfig();
    }
public ExcelConfig(GridView gv)
{
        this._data = gv;
        this._isGridView = true;
        this._isDataTable = false;
        initConfig();
}

    private void initConfig()
    {

        this._exportexcelfilename = DateTime.Now.ToString("yyyymmddhhmmss") + ".xls";//默认保存的文件名根据系统时间自动生成
        this._exportexcelfilepath = "~/xls/"; //默认文件输出的路径
        this._templatefilepath = "~/A