<%
set xlapp = server.createobject("excel.application")
xlapp.visible = false
' 使服务端不出现excel窗口.
set myworkbook = xlapp.workbooks.add
' 建立一个worksheet.
set myworksheet = myworkbook.worksheets(1)
myworksheet.range("a1").value = '精彩春风通讯录'
myworksheet.range("a1").font.size = 12
myworksheet.range("a1").font.bold = true
myworksheet.range("a2").value = '姓名'
myworksheet.range("b2").value = '地址'
myworksheet.range("c2").value = '电话'
myworksheet.range("d2").value = '手机'
' 以上7行建立表头.
myworksheet.range("a2:d2").font.bold = true
strfilename = session.sessionid & ".xls"
' 确保文件名唯一.
strapppath = request.servervariables("path_translated")
strapppath = left(strapppath, instrrev(strapppath, "\"))
strfullpath = strapppath & strfilename
myworkbook.saveas(strfullpath)
' 保存文件.
myworkbook.close
' 关闭excel.
xlapp.quit
set myworksheet = nothing
set myworkbook = nothing
set myxlapp = nothing
response.redirect strfilename
[1]
如对本文有疑问, 点击进行留言回复!!
vscode使用editorconfig插件以及.editorconfig配置文件说明详解
VSCODE添加open with code实现右键打开文件夹
网友评论