用asp往excel写数据的问题~~
代码如下:
FilePath = Server.Mappath(".") & "\report\部品一览表.xls"
set objExcelApp = Server.CreateObject("Excel.Application")
objExcelApp.WorkBooks.Open( FilePath )
set objExcelBook = objExcelApp.ActiveWorkBook
set objExcelSheet = objExcelBook.Sheets(1)
objExcelApp.Visible = true
'******将表头信息写入报表中
objExcelSheet.Range("D4") = m_JobSub
objExcelSheet.Range("L4") = m_Title
objExcelSheet.Range("U4") = ItemNo_Count
objExcelSheet.Range("AC4") = ItemNo_Done_Count
objExcelSheet.Range("AG4") = ItemNO_Percent
objExcelSheet.Range("D7") = m_Product_Name
objExcelSheet.Range("L7") = m_Project_Name
objExcelSheet.Range("AC7") = m_Product
'******End
lIntCurrentRow = 14
'***** 表格格式化 *****
m_Count = Rs.recordCount
If m_Count > 10 Then
For i = 0 To int( m_Count/10 ) -1
objExcelSheet.Rows("14:43").Select '****这行出错
objExcelApp.Selection.Copy
objExcelSheet.Rows( i * 30 + 44 & ":" & ( i + 1 ) * 30 + 43 ).Select
objExcelApp.Selection.PasteSpecial -4122,-4142,False,False
objExcelApp.Application.CutCopyMode = False
Next
End If
错误提示:
Microsoft VBScript 编译器错误 错误 '800a03f6'
缺少 'End'
/iisHelp/common/500-100.asp,行242
Microsoft Excel 错误 '800a03ec'
类 Range 的 Select 方法无效