怎样用c# asp.net实现以下这个关于excel表的小功能?
来源:百度知道 编辑:UC知道 时间:2024/05/05 11:26:04
要一步步说,比如这样:先添加一个新的窗体default.aspx,然后拖入一个button控件。。如此。我毕竟是个刚入门的菜鸟。最好注释多一点。。谢谢。
加点注释好吗。。。。。。- -
private static string sFile;
protected void Page_Load(object sender, EventArgs e)
{
sFile = Server.MapPath("2.xlsx");
}
protected void Button1_Click(object sender, EventArgs e)
{
Excel.Application oExcel = new Excel.ApplicationClass();
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);
Excel.Range ex = (Excel.Range)xlsheet.get_Range("B4",objMissing);
ex.ColumnWidth = 20;
ex.Value2 = DateTime.Now.ToString();
oExcel.DisplayAlerts = false;