ASP生产excel文件

大鸟，飞起来

1. Response.AddHeader "Content-Disposition", "attachment;filename=testexcel.xls"
   
2. Response.ContentType = "application/vnd.ms-excel"
   
3. Response.write "<table width=""100%"" border=""1"">"
   
4. Response.write "<tr>"
   
5. Response.write "<th width=""40%""><b>编号</b></th>"
   
6. Response.write "<th width=""30%""><b>用户名</b></th>"
   
7. Response.write "<th width=""30%""><b>密码</b></th>"
   
8. Response.write "</tr>"
   
9. Response.write "<tr>"
   
10. Response.write "<td width=""40%"">1</td>"
    
11. Response.write "<td width=""30%"">徐飞</td>"
    
12. Response.write "<td width=""30%"">123456</td>"
    
13. Response.write "</tr>"
    
14. Response.write "</table>"
    
15. 
    
16. 
    

复制代码