【asp】asp.net 读取并显示excel数据的实现代码-net--读取-显示-excel数据

欢迎您访问我爱IT技术网，今天小编为你分享的编程技术是：【asp.net 读取并显示excel数据的实现代码】，下面是详细的讲解！

asp.net 读取并显示excel数据的实现代码

protected void btnUpload_Click(object sender, EventArgs e)
{
if ((txtFilePath.HasFile))
{
OleDbConnection conn=new OleDbConnection();
OleDbCommand cmd=new OleDbCommand();
OleDbDataAdapter da=new OleDbDataAdapter();
DataSet ds=new DataSet();
string query=null;
string connString="";
string strFileName=DateTime.Now.ToString("ddMMyyyy_HHmmss");
string strFileType=System.IO.Path.GetExtension(txtFilePath.FileName).ToString().ToLower();
//Check file type
if (strFileType==".xls" || strFileType==".xlsx")
{
txtFilePath.SaveAs(Server.MapPath("~/UploadedExcel/" + strFileName + strFileType));
}
else
{
lblMessage.Text="Only excel files allowed";
lblMessage.ForeColor=System.Drawing.Color.Red;
lblMessage.Visible=true;
return;
}
string strNewPath=Server.MapPath("~/UploadedExcel/" + strFileName + strFileType);
//Connection String to Excel Workbook
if (strFileType.Trim()==".xls")
{
connString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strNewPath + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=2\"";
}
else if (strFileType.Trim()==".xlsx")
{
connString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + strNewPath + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=2\"";
}
query="SELECT * FROM [Sheet1$]";
//query="SELECT [Country],[Capital] FROM [Sheet1$] WHERE [Currency]='Rupee'"
//query="SELECT [Country],[Capital] FROM [Sheet1$]"
//Create the connection object
conn=new OleDbConnection(connString);
//Open connection
if (conn.State==ConnectionState.Closed) conn.Open();
//Create the command object
cmd=new OleDbCommand(query, conn);
da=new OleDbDataAdapter(cmd);
ds=new DataSet();
da.Fill(ds);
grvExcelData.DataSource=ds.Tables[0];
grvExcelData.DataBind();
lblMessage.Text="Data retrieved successfully! Total Records:" + ds.Tables[0].Rows.Count;
lblMessage.ForeColor=System.Drawing.Color.Green;
lblMessage.Visible=true;
da.Dispose();
conn.Close();
conn.Dispose();
}
else
{
lblMessage.Text="Please select an excel file first";
lblMessage.ForeColor=System.Drawing.Color.Red;
lblMessage.Visible=true;
}
}

关于asp.net 读取并显示excel数据的实现代码的用户互动如下：

　　相关问题：

　　答： >>详细

　　相关问题：

　　答： >>详细

　　相关问题：

　　答： >>详细