asp.net读取xlsx
来源:互联网 发布:linux 查看权限命令 编辑:程序博客网 时间:2024/06/05 03:57
protected void Button1_Click(object sender, EventArgs e)
{
if (!FileUpload1.HasFile) return;
string filePath = FileUpload1.PostedFile.FileName;
string fileExtension = System.IO.Path.GetExtension(FileUpload1.FileName).ToLower();
if (!fileExtension.Equals(".xlsx"))
{
Response.Write("<script language=\"javascript\">alert('请选择正确的文件');</script>");
return;
}
string fullPath = filePath.Substring(filePath.LastIndexOf("\\") + 1);
this.FileUpload1.PostedFile.SaveAs("\\" + fullPath);
string filename = "\\" +this.FileUpload1.FileName;
DataTable dt= ExcelToSqlServer(filename);
this.Label1.Text = dt.Rows[0][0].ToString();
}
public static DataTable ExcelToSqlServer(string path)
{
DataSet ds = new DataSet();
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Extended Properties=Excel 12.0;Data Source=" + path);
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
OleDbCommand com = conn.CreateCommand();
com.CommandText = "select * from [sheet1$]";
com.CommandType = CommandType.Text;
OleDbDataAdapter adapter = new OleDbDataAdapter(com);
conn.Close();
adapter.Fill(ds);
return ds.Tables[0];
{
if (!FileUpload1.HasFile) return;
string filePath = FileUpload1.PostedFile.FileName;
string fileExtension = System.IO.Path.GetExtension(FileUpload1.FileName).ToLower();
if (!fileExtension.Equals(".xlsx"))
{
Response.Write("<script language=\"javascript\">alert('请选择正确的文件');</script>");
return;
}
string fullPath = filePath.Substring(filePath.LastIndexOf("\\") + 1);
this.FileUpload1.PostedFile.SaveAs("\\" + fullPath);
string filename = "\\" +this.FileUpload1.FileName;
DataTable dt= ExcelToSqlServer(filename);
this.Label1.Text = dt.Rows[0][0].ToString();
}
public static DataTable ExcelToSqlServer(string path)
{
DataSet ds = new DataSet();
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Extended Properties=Excel 12.0;Data Source=" + path);
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
OleDbCommand com = conn.CreateCommand();
com.CommandText = "select * from [sheet1$]";
com.CommandType = CommandType.Text;
OleDbDataAdapter adapter = new OleDbDataAdapter(com);
conn.Close();
adapter.Fill(ds);
return ds.Tables[0];
}
仅作记录。勿喷。
- asp.net读取xlsx
- .Net读取xlsx文件
- .Net读取xlsx文件Excel2007
- .Net读取xlsx文件Excel2007
- .Net读取xlsx文件 excel文件
- ASP.NET Core 导入导出Excel xlsx 文件
- POI读取XLS、XLSX
- 读取xls和xlsx
- poi读取xlsx
- phpExcel读取xlsx文件
- python读取xlsx文件
- openpyxl读取xlsx
- 读取xlsx文件
- ASP.NET读取EXCEL
- ASP.NET读取EXCEL
- ASP.NET 读取Word
- Asp.Net 读取Excel
- asp.net 读取excel
- sopcast在ubuntu上的安装与使用
- 学习cocos2d-x 之路 (1)--了解cocos2d-x
- in-app purchase for Amazon Appstore ( 亚马逊内计费 )
- 在线发短信网站的程序讲解
- CodeIgniter 核心代码阅读-加载类Loader.php
- asp.net读取xlsx
- java 代理模式
- Linux口袋书(第2版)
- SSI开发:applicationContext-common.xml标准配置模板
- 向Richedit插入动态Gif的实现(关于QQ表情功能的制作)
- 【Office超级技巧连载─Excel工作簿技巧】
- HTTP协议详解
- 【假如电脑的散热大户显卡溫度过高怎么办】
- 先产品,再战略,最后是商业模式