作者:乔山办公网日期:
返回目录:excel表格制作
第二行,有问题,蓝色表保存到桌面上,工作簿名为:数据导出来,第一次导出可以为这个名,第二次导出应该为啥名?第三次呢?
fileName = new String(fileName.getBytes(),"iso-8859-1");
response.setCharacterEncoding("gb2312");
response.reset();
response.setContentType("application/OCTET-STREAM;charset=gb2312");
response.setHeader("pragma", "no-cache");
response.addHeader("Content-Disposition", "attachment;filename=\""
+ fileName + ".xls\"");// 点击百导出度excle按钮时候问页面显示答的默认版名称权
workbook = Workbook.createWorkbook(response.getOutputStream());
Sub 生成道TXT文件回()
Range("K15:T27").select
selection.copy
sheets("New").select
range("A1").select
activesheet.paste
ActiveWorkbook.SaveAs Filename:="1.txt"
ActiveWorkbook.SaveAs FileFormat:=xlText
MsgBox "生成完毕答"
End Sub
用另存知为SaveAs方法:道
ActiveWorkbook.SaveAs Filename:="文件路版径权\名称.txt", _
FileFormat:=xlUnicodeText, CreateBackup:=False