如何使用MVC在HTML表中显示Excel数据 [英] How to display Excel data in HTML table using MVC

问题描述

大家好，
请任何人帮助我编写代码以在MVC框架uisng HTML表中显示Excel数据.

这是我在类库文件(TableBS)中编写的代码.
下面的方法使用对象在控制器类中即时调用.
Iam gettg (SELECT * FROM [Sheet1$]", conn)中的异常除外.

Hi All,
Please can anyone help me to write code to display Excel data in HTML table uisng MVC framework.

This is the code what i have written in class library file(TableBS).
The below method im calling in controller class using the object.
Iam gettg the exception in (SELECT * FROM [Sheet1$]", conn) as excepted.

 public string getTable() 
 { 
	XElement xml = null; 
	try 
	{ 
		string strConnectionString; 
		string filename = @"Demo.xls"; // Ignore Path... Shortened to make more readable (MK)
		
		if (Path.GetExtension(filename).ToLower() == ".xlsx") 
		{ 
			strConnectionString = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=\"Excel 12.0", filename); 
			OleDbConnection conn = new OleDbConnection(strConnectionString); 
			conn.Open(); 
			OleDbCommand dataCommand = new OleDbCommand("SELECT * FROM [Sheet1$]", conn); 
			OleDbDataAdapter da = new OleDbDataAdapter(dataCommand); 
			DataSet ds = new DataSet(); 
			da.Fill(ds); 
			xml = new XElement("Table"); 
			xml.Add(from data in ds.Tables[0].AsEnumerable() select data); 
		} 
		else if (Path.GetExtension(filename).ToLower() == ".xls") 
		{ 
			strConnectionString = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=Excel 8.0", filename); 
			OleDbConnection conn = new OleDbConnection(strConnectionString); 
			conn.Open(); 
			OleDbCommand dataCommand = new OleDbCommand("SELECT * FROM [Sheet1$]", conn); 
			OleDbDataAdapter da = new OleDbDataAdapter(dataCommand); 
			DataSet ds = new DataSet(); da.Fill(ds); 
			xml = new XElement("Table"); 
			xml.Add(from data in ds.Tables[0].AsEnumerable() select data); 
		} 
		return xml.ToString(); 
	} 
	catch (Exception ex) 
	{ 
		Log(ex.Message.ToString(), "MenuBS", "getTable"); return "<Table/>"; 
	} 
	finally 
	{ 
		xml = null; 
	} 
}

谢谢
Madhusudhan

Thanks
Madhusudhan

推荐答案

，conn)除外.

", conn) as excepted.

 public string getTable() 
 { 
	XElement xml = null; 
	try 
	{ 
		string strConnectionString; 
		string filename = @"Demo.xls"; // Ignore Path... Shortened to make more readable (MK)
		
		if (Path.GetExtension(filename).ToLower() == ".xlsx") 
		{ 
			strConnectionString = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=\"Excel 12.0", filename); 
			OleDbConnection conn = new OleDbConnection(strConnectionString); 
			conn.Open(); 
			OleDbCommand dataCommand = new OleDbCommand("SELECT * FROM [Sheet1

"，conn)； OleDbDataAdapter da = 新 OleDbDataAdapter(dataCommand); DataSet ds = 新 DataSet(); da.Fill(ds); xml = 新 XElement(" ); xml.Add(来自数据位于 ds.Tables [ 0 ].AsEnumerable()选择数据)； } 其他 如果(Path.GetExtension(filename).ToLower()== .xls") { strConnectionString = 字符串 .Format(" ，文件名)； OleDbConnection conn = 新 OleDbConnection(strConnectionString); conn.Open(); OleDbCommand dataCommand = 新 OleDbCommand("

", conn); OleDbDataAdapter da = new OleDbDataAdapter(dataCommand); DataSet ds = new DataSet(); da.Fill(ds); xml = new XElement("Table"); xml.Add(from data in ds.Tables[0].AsEnumerable() select data); } else if (Path.GetExtension(filename).ToLower() == ".xls") { strConnectionString = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=Excel 8.0", filename); OleDbConnection conn = new OleDbConnection(strConnectionString); conn.Open(); OleDbCommand dataCommand = new OleDbCommand("SELECT * FROM [Sheet1

"，conn)； OleDbDataAdapter da = 新 OleDbDataAdapter(dataCommand); DataSet ds = 新 DataSet(); da.Fill(ds); xml = 新 XElement(" ); xml.Add(来自数据位于 ds.Tables [ 0 ].AsEnumerable()选择数据)； } 返回 xml.ToString(); } 捕获(例外) { Log(ex.Message.ToString()，" ， getTable")； 返回 " ; } 最终 { xml = 空; } }

", conn); OleDbDataAdapter da = new OleDbDataAdapter(dataCommand); DataSet ds = new DataSet(); da.Fill(ds); xml = new XElement("Table"); xml.Add(from data in ds.Tables[0].AsEnumerable() select data); } return xml.ToString(); } catch (Exception ex) { Log(ex.Message.ToString(), "MenuBS", "getTable"); return "<Table/>"; } finally { xml = null; } }

谢谢
Madhusudhan

Thanks
Madhusudhan

这篇关于如何使用MVC在HTML表中显示Excel数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！