.net教程:vb/vb.net/c#导出到excel的方法
[size=3]先在vb的工程中引用“microsoft excel 11.0 object ”11.0是版本号,不重要的,excel2000是9.0'申明变量
dim xlapp as excel.application
dim xlbook as excel.workbook
dim xlsheet as excel.worksheet
set xlapp = createobject("excel.application")
'使用模板
set xlbook = xlapp.workbooks.open(app.path & "\普通.xls")
on error goto 0
set xlsheet = xlbook.worksheets(1)
xlapp.visible = false
xlsheet.activate
'处理数据,填充excel表
xlsheet.cells(3, 4) = textquery.text '产品名称
……
'//////////////
xlapp.visible = true '显示表格
set xlapp = nothing '交还控制给excel
set xlboook = nothing
set xlsheet = nothing
到此,导出到excel完成,在.net中,只需改动少许即可运行,只是c#的语法有些区别
[/size]
页:
[1]