＋设为首页 ＋添加到收藏夹
我想在ASP。NET中用到EXCEL进程，但不知道自怎么生成。请大家帮忙。
http://dotnet.aspx.cc/ShowDetail.aspx?id=8A4CBF47-B888-4832-3389-ED3A3A3C8AAB
孟子E章的.
Imports Office
以COM方式处理Excel
Dim oExcel As New Excel.Application
Dim oBooks As Excel.Workbooks, oBook As Excel.Workbook
Dim oSheets As Excel.Sheets, oSheet As Excel.Worksheet
Dim oCells As Excel.Range
Dim sFile As String, sTemplate As String
定义一个datatable
Dim dt As DataTable = CType(Application.Item("MyDataTable"), DataTable)
sFile = Server.MapPath(Request.ApplicationPath) & "\MyExcel.xls"
定义模版文件
sTemplate = Server.MapPath(Request.ApplicationPath) & "\MyTemplate.xls"
oExcel.Visible = False
oExcel.DisplayAlerts = False
定义一个新的工作簿
oBooks = oExcel.Workbooks
oBooks.Open(Server.MapPath(Request.ApplicationPath) & "\MyTemplate.xls") oBook = oBooks.Item(1)
oSheets = oBook.Worksheets
oSheet = CType(oSheets.Item(1), Excel.Worksheet)
命名该sheet
oSheet.Name = "First Sheet"
oCells = oSheet.Cells
...
http://www.chinaaspx.com/comm/dotnetbbs/Showtopic.aspx?Forum_ID=5&Id=162895&PPage=51
