sub Printst_onclick()
createexcel
xlsworkbook.printout
xlsworkbook.close(false)
set xlscheet=nothing
set xlsworkbook=nothing
xlsapp.quit
set xlsapp=nothing
end sub
sub Excelst_onclick
createexcel
xlsworkbook.saveas "f:\testSt.xls"
set xlscheet=nothing
set xlsworkbook=nothing
xlsapp.quit
set xlsapp=nothing
end sub
</script>
<script language=vbscript>
Dim xlsApp
Dim xlsWorkBook
Dim xlssheet
sub CreateExcel() '把數據寫入Excel
dim ST
dim Sprcount
Dim PSdate
Set xlsApp = CreateObject("Excel.Application")
set xlsWorkbook=xlsApp.Workbooks.Add
Set xlssheet = xlsWorkBook.Sheets(1)
<%
dim PRsd
dim Prcount
Dim T
dim Stime
Dim I
Dim R
Dim K
Dim row
dim item
stime=now
username=user
set PRsd=Server.CreateObject("ADODB.Recordset")
PRsd.open Sqlstr,Conn,3,3 '用你自己的數據記錄集
Prcount = PRsd.RecordCount
T=PRsd.fields.count-1
row = 3
For R = 1 To Prcount
For I = 0 To T
%>
xlssheet.Cells(<%=row%>,<%=I + 1%>).NumberFormat = "@" '都按字符串形式寫入EXCEL
xlssheet.Cells(<%=row%>,<%=I + 1%>).Value = "<%= PRsd.Fields(I).Value%>"
<%
Next
Row = Row + 1
PRsd.MoveNext
Next
%>
xlssheet.Columns("A:A").ColumnWidth = 11 '設置Excel列寬
xlssheet.Columns("B:B").ColumnWidth = 10
xlssheet.Columns("C:C").ColumnWidth = 8
xlssheet.Columns("D:D").ColumnWidth = 13
With xlssheet.PageSetup '打印設置
.PrintTitleRows = "$1:$2"
.PrintTitleColumns = ""
.LeftFooter = "報表生成日期:" & "<%=stime%>"
.CenterFooter = " &P of &N "
.RightFooter = "Print By " & "<%=username%>"
End With
xlssheet.Cells(1, 1).Value = "STATION DETAIL TRANSACTION QUERY" '標題欄
xlssheet.Cells(2, 1).Value = "日 期"
xlssheet.Cells(2, 2).Value = "途程卡"
xlssheet.Cells(2, 3).Value = "數 量"
xlssheet.Cells(2, 4).Value = "模 號"
end sub