在ASP.NET中访问Excel 2013文件 [英] Accessing Excel 2013 File in ASP.NET

问题描述

我正在开发一个ASP.NET应用程序。我有一个名为ExcelApp的Excel 2013文件，我也在我的项目中添加。我无法访问该文件。

这是我的DAL类：

  public string ExcelConnection = @Provider = Microsoft.ACE.OLEDB.12.0; Data Source = C：\Nimit\ExcelApplication.xlsx;扩展属性='Excel 12.0 Xml'; HDR = YES; 
 OleDbDataAdapter DbAdap; 
 DataTable dt; 
 
 public DataTable Get_ExcelSheet（）
 {
 OleDbConnection DbCon = new OleDbConnection（ExcelConnection）; 
 
 DbAdap = new OleDbDataAdapter（SELECT * FROM [Sheet1 $]，DbCon）; 
 dt = new DataTable（）; 
 DbAdap.Fill（dt）; 
 return dt; 
} 
  

我的cs文件代码：

  public partial class WebForm1：System.Web.UI.Page 
 {
 DAL obj = new DAL（）; 
 protected void Page_Load（object sender，EventArgs e）
 {
 if（！IsPostBack == true）
 {
 Get_Data（）; 
} 
} 
 
 void Get_Data（）
 {
 GridView1.DataSource = obj.Get_ExcelSheet（）; 
 GridView1.DataBind（）; 
} 
} 
  

我的调试器在执行此行时显示错误： / p>

  DbAdap.Fill（dt）; 
  

例外情况是：

解决方案

我解决了我的问题。这是我的代码：

  public class DAL 
 {
 OleDbDataAdapter DbAdap; 
 DataTable dt; 
 
 public DataTable Get_ExcelSheet（）
 {
 OleDbConnection DbCon = new OleDbConnection（Provider = Microsoft.ACE.OLEDB.12.0; Data Source = C：\\Nimit\\ \\\ExcelApplication.xlsx;扩展属性= \Excel 12.0 Xml; HDR = YES; IMEX = 1; \）; 
 
 DbAdap = new OleDbDataAdapter（SELECT * FROM [Sheet1 $]，DbCon）; 
 dt = new DataTable（）; 
 DbAdap.Fill（dt）; 
 return dt; 
} 
} 
  

我只是在我的OleDbConnection中提供我的连接字符串。这是它。

I am developing an ASP.NET application. I have an Excel 2013 file named ExcelApp and i have also added in my project. I can not access the file.

Here is my DAL class:

public string ExcelConnection = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Nimit\ExcelApplication.xlsx;Extended Properties='Excel 12.0 Xml';HDR=YES"; 
    OleDbDataAdapter DbAdap;
    DataTable dt;

    public DataTable Get_ExcelSheet()
    {
        OleDbConnection DbCon = new OleDbConnection(ExcelConnection);

        DbAdap = new OleDbDataAdapter("SELECT * FROM [Sheet1$]",DbCon);
        dt = new DataTable();
        DbAdap.Fill(dt);
        return dt;
    }

My cs file code:

public partial class WebForm1 : System.Web.UI.Page
{
    DAL obj = new DAL();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack == true)
        {
            Get_Data();
        }
    }

    void Get_Data()
    {
        GridView1.DataSource = obj.Get_ExcelSheet();
        GridView1.DataBind();
    }
}

My debugger shows the error while executing this line:

DbAdap.Fill(dt);

The exception is:

解决方案

I solved my question. Here is my code:

public class DAL
{
    OleDbDataAdapter DbAdap;
    DataTable dt;

    public DataTable Get_ExcelSheet()
    {
        OleDbConnection DbCon = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Nimit\\ExcelApplication.xlsx;Extended Properties=\"Excel 12.0 Xml;HDR=YES;IMEX=1;\"");

        DbAdap = new OleDbDataAdapter("SELECT * FROM [Sheet1$]",DbCon);
        dt = new DataTable();
        DbAdap.Fill(dt);
        return dt;
    }
}

I simply provide my connection string in my OleDbConnection. Thats it.

这篇关于在ASP.NET中访问Excel 2013文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！