oledb方式读取Excel表

最新推荐文章于 2020-05-12 21:49:25 发布

yangkunlisi

最新推荐文章于 2020-05-12 21:49:25 发布

阅读量398

点赞数

分类专栏：个人职场感想文章标签： excel dataset string properties path object

本文链接：https://blog.csdn.net/yangkunlisi/article/details/6307207

版权

个人职场感想专栏收录该内容

2 篇文章 0 订阅

订阅专栏

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

namespace ExcelData
{
    public partial class _Default : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            ExcelToDS();
        }

        private void ExcelToDS()
        {
            string strSheetName = "address";
            string path = @"F:/PC/Documents/TianjinInstitute/天津自动站信息表address1new.XLS";

string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + ";Extended Properties='Excel 8.0;HDR=Yes;IMEX=1;'";

            //Sql语句
            string strExcel = "select * from [" + strSheetName + "$B1:F233] ";
            //string strExcel = "select * from [" + strSheetName + "$] ";

DataSet ds = new DataSet();

//连接数据源
OleDbConnection conn = new OleDbConnection(strConn);

conn.Open();

            //适配到数据源
            OleDbDataAdapter adapter = new OleDbDataAdapter(strExcel, conn);
            adapter.Fill(ds, "data");

conn.Close();

            GridView1.DataSource = ds.Tables["data"];
            GridView1.DataBind();
        }
    }
}