Conris.Utility/ExcelHelper.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.OleDb;
using System.IO;
using System.Web.UI.WebControls;
using System.Web.UI;

namespace Conris.Utility
{
    public class ExcelHelper
    {
        //导入数据
        public static DataSet ReaderExcel(string path, string table)
        {
            if (path != "")
            {
                if (path.Substring(path.LastIndexOf('.') + 1) == "xls")
                {
                    DataSet ds = new DataSet();
                    string ConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;" + "data source=" + path + ";Extended Properties='Excel 8.0;HDR=YES;IMEX=2';";
                    OleDbConnection conn = new OleDbConnection(ConnStr);
                    conn.Open();
                    string sql = "select * from [" + table + "$]";
                    OleDbDataAdapter da = new OleDbDataAdapter(sql, ConnStr);
                    da.Fill(ds);
                    return ds;
                }
                else
                {
                    return null;
                }
            }
            else
            {
                return null;
            }
        }

        //数据导出之前，将linkbutton,dropdownlist替换成literal
        public static void DisableControls(Control gv)
        {
            LinkButton lb = new LinkButton();
            Literal l = new Literal();
            string name = String.Empty;
            for (int i = 0; i < gv.Controls.Count; i++)
            {
                if (gv.Controls[i].GetType() == typeof(LinkButton))
                {
                    l.Text = (gv.Controls[i] as LinkButton).Text;
                    gv.Controls.Remove(gv.Controls[i]);
                    gv.Controls.AddAt(i, l);
                }
                else if (gv.Controls[i].GetType() == typeof(DropDownList))
                {
                    l.Text = (gv.Controls[i] as DropDownList).SelectedItem.Text;
                    gv.Controls.Remove(gv.Controls[i]);
                    gv.Controls.AddAt(i, l);