C# WebUI导入Excel表
在<system.web>中添加<identity impersonate="true"/>using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string sFile = Server.MapPath("20081022.xls");
Excel.Application oExcel = new Excel.Application();
object objMissing = System.Reflection.Missing.Value;
Excel.Workbook mybook = (Excel.Workbook)oExcel.Workbooks.Open(sFile, objMissing, objMissing, objMissing, objMissing, objMissing, objMissing, objMissing, objMissing, objMissing, objMissing, objMissing, objMissing, objMissing, objMissing);
Excel.Sheets excelSheets = mybook.Worksheets;
Excel.Worksheet xlsheet = (Excel.Worksheet)excelSheets.get_Item(1);
int i=1;
while (xlsheet.get_Range(xlsheet.Cells, xlsheet.Cells).Text.ToString()!="")
{
Response.Write(xlsheet.get_Range(xlsheet.Cells, xlsheet.Cells).Text.ToString() + "－－");
Response.Write(xlsheet.get_Range(xlsheet.Cells, xlsheet.Cells).Text.ToString() + "－－");
Response.Write(xlsheet.get_Range(xlsheet.Cells, xlsheet.Cells).Text.ToString() + "－－");
Response.Write(xlsheet.get_Range(xlsheet.Cells, xlsheet.Cells).Text.ToString() + "－－");
Response.Write(xlsheet.get_Range(xlsheet.Cells, xlsheet.Cells).Text.ToString() + "－－");
Response.Write(xlsheet.get_Range(xlsheet.Cells, xlsheet.Cells).Text.ToString() + "－－");
Response.Write(xlsheet.get_Range(xlsheet.Cells, xlsheet.Cells).Text.ToString() + "－－");
Response.Write(xlsheet.get_Range(xlsheet.Cells, xlsheet.Cells).Text.ToString() + "<br/>");
i++;
}
mybook = null;
xlsheet = null;
oExcel.Quit();
}
}
页:
[1]