怎样在用asp.net在浏览器中显示excel表中的图表
可以显示表内容,但是显示不了图,程序如下:
<%@ Page language="c#" Debug="true" %>
<%@ Import Namespace="System.Data"%>
<%@ Import Namespace="System.Data.OleDb"%>
<%@ Import Namespace="System.Data.Common"%>
<HTML>
<script language="C#" runat="server">
protected void Page_Load(Object Src, EventArgs E)
{
string strConn= "Provider=Microsoft.Jet.OLEDB.4.0;"+"Data Source=C:\\Book1.xls;"+"Extended Properties=Excel 8.0;";
OleDbConnection myConnection = new OleDbConnection(strConn);
//myConnection.Open();
OleDbDataAdapter myadapter =new OleDbDataAdapter();
myadapter.SelectCommand=new OleDbCommand("SELECT * FROM [sheet1$]",myConnection) ;
DataSet myDataSet =new DataSet();
//myCommand.FillDataSet(myDataSet,"ExcelInfo");
myadapter.Fill(myDataSet,"ExcelInfo");
DataGrid1.DataSource=myDataSet.Tables["ExcelInfo"].DefaultView;
DataGrid1.DataBind();
}
</script>
<body>
<p><asp:label id="lable1" runat="server">excel表内容: </asp:label></p>
<P><asp:datagrid id="DataGrid1" runat="server"></asp:datagrid></P>
</body>
</HTML>