Excel怎么这么难处理呢,头疼!!!
<!--#include file = "dataconn.asp" -->
<html>
<head>
</head>
<body>
<%
set conn=dbConnOpen("hkr")
'on error resume next
'贵重物品购入情况
strsql = "select * from zh_rich_buy_v order by date desc"
set rs = server.CreateObject("adodb.recordset")
rs.Open strsql,conn,1,1
set objExcelApp = CreateObject("Excel.Application")
objExcelApp.DisplayAlerts = false '不显示警告
objExcelApp.Application.Visible = True '显示界面
'objExcelApp.show()
'创建表单
objExcelApp.WorkBooks.add
set objExcelBook = objExcelApp.ActiveWorkBook
set objExcelSheets = objExcelBook.Worksheets
set objExcelSheet = objExcelBook.Sheets(1)
objExcelSheet.name = "贵重物品购买信息"
objExcelSheet.Range("A1:E1").Value = "贵重物品购买信息"
objExcelSheet.Range("A3:A3").Value = "购入日期"
objExcelSheet.Range("B3:B3").Value = "物品名称"
objExcelSheet.Range("C3:C3").Value = "数量"
objExcelSheet.Range("D3:D3").Value = "单位"
objExcelSheet.Range("E3:E3").Value = "签字"
objExcelSheet.Range("F3:F3").Value = "备注"
%>
<TABLE WIDTH="100%" BORDER="1" CELLSPACING="1" CELLPADDING="1" ID="Table1">
<tr>
<th>购入时间</th>
<th>物品名称</th>
<th>数量</th>
<th>单位</th>
<th>签字</th>
<th>备注</th>
</tr>
<%
for i = 1 to rs.RecordCount
%>
<TR>
<TD>
<%
response.Write tospace(rs("date"))
objExcelSheet.Cells(i+3,1).value = rs("date")
%>
</TD>
<TD>
<%
response.Write tospace(rs("name"))
objExcelSheet.Cells(i+3,2).value = rs("name")
%>
</TD>
<TD>
<%
response.Write tospace(rs("num"))
objExcelSheet.Cells(i+3,3).value = rs("num")
%>
</TD>
<TD>
<%
response.Write tospace(rs("unit"))
objExcelSheet.Cells(i+3,4).value = rs("unit")
%>
<TD>
<%
response.Write tospace(rs("sign"))
objExcelSheet.Cells(i+3,5).value = rs("sign")
%>
</TD>
<TD>
<%
response.Write tospace(rs("memo"))
objExcelSheet.Cells(i+3,6).value = rs("memo")
%>
</TD>
</TD>
</TR>
<%
rs.MoveNext
next
%>
</TABLE>
<%
'保存文档
'objExcelBook.SaveAs server.MapPath(".") & "/new.xls"
'结束进程
objExcelApp.Quit
set objExcelApp = Nothing
%>
</body>
</html>
上面是我写的代码,就是在客户端不启动excel程序,头疼,各位帮忙啊