生成excel 进程(急,100分) 我想在ASP。NET中用到EXCEL进程,但不知道自怎么生成。请大家帮忙。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 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 树的删除? 寻找合作网站美工,程序员` 请教在asp.net中调用Jmail收发邮件,怎样才能把邮件附件保存到客户端上,谢谢 200分冰天雪地转体360度跪求.net工作流解决方案,分不够再加!!! 关于查询问题 如何获取Gridview的值. VB.NET里面什么函数能够取得大于实数的最近一个整数,问题很简单有20分相送,我刚开始学.net 页面频繁刷新会导致网站异常 各位大虾帮忙!关于provider没有registered~! 多谢szwebnet(动力) 提供的代码!请进来接分,另外还有个小问题! 问个简单的问题,连接数据库区别 图片上传后,显示不能马上刷新的问题
孟子E章的.
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