关于本地xls文件怎样在网页显示的问题,急!
部分代码如下:protected void Button1_Click(object sender, EventArgs e)
{
string path = getFilePath();
Excel.Application app;
Excel.Workbook workBook;
Excel.Worksheet workSheet;
app = new Excel.ApplicationClass();
app.Visible = true;
workBook = app.Workbooks.Open(path, Type.Missing, Type.Missing,Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
workSheet = (Excel.Worksheet)workBook.Sheets.get_Item(1);
}
protected DataSet CreateDataSource()
{
string strCon;
string path = getFilePath();
strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + ";Extended Properties=Excel 8.0;";
OleDbConnection olecon = new OleDbConnection(strCon);
OleDbDataAdapter myda = new OleDbDataAdapter("SELECT * FROM [Report1$]",olecon);
DataSet myds = new DataSet();
myda.Fill(myds);
return myds;
}
GridView1.DataSource = CreateDataSource();
GridView1.DataBind();
我的xls文件在本地硬盘,具体是报表的形式,我现在表格能显示,数据也能显示,但是有些列的字段显示不了,而且在网页里面显示的表格的第一行是F1,F2...Fn这样的形式,我不知道这是从哪里出来的,我表格里面没有,不知道怎么回事?请高手指教
补充:.NET技术 , ASP.NET