调用Word打印...

发布: 2007-6-30 18:56 | 作者: admin | 来源: | 查看: 13次 | 进入软件测试论坛讨论

运行下列的脚本需要将IE的安全级别设为低，或在中级安全级别下将那个ActiveX控件设为启用，忘记了：

<html>
<head>
<title>Build Document by Script</TITLE>
</HEAD>
<Table id="myData" border=1 align=center>
<Tr align=center>
  <Td>产品名称</Td>
  <Td>产品描述</Td>
  <Td>产品单价</Td>
  <Td>产品等级</Td>
</Tr>
<Tr align=center>
  <Td>产品一</Td>
  <Td>This is a test</Td>
  <Td align=right>300.50</Td>
  <Td>一级</Td>
</Tr>
<Tr align=center>
  <Td>产品二</Td>
  <Td>This is a test</Td>
  <Td align=right>300.50</Td>
  <Td>一级</Td>
</Tr>
<Tr align=center>
  <Td>产品三</Td>
  <Td>This is a test</Td>
  <Td align=right>300.50</Td>
  <Td>一级</Td>
</Tr>
</Tabld>
<input type=button onclick="vbscript:buildDoc @#@#,4" value="build">
<BODY>
</BODY>
</HTML>
<script language="vbscript">
Sub buildDoc(theTemplate,intTableRows)
  Dim Table1
  set Table1 = document.all.myData
  row = Table1.rows.length
  Set objWordDoc = CreateObject("Word.Document")
  ObjWordDoc.Application.Visible=True
  Dim  theArray(4,4)
  @#Redim Preserve theArray(4,row)
  colnum = Table1.rows(1).cells.length
  for i=0 to row-1
    for j=0 to colnum-1
      theArray(j+1,i+1) = Table1.rows(i).cells(j).innerHTML
    next
  next

  intNumrows = 4

  objWordDoc.Application.ActiveDocument.Paragraphs.Add.Range.InsertBefore("测试的表格")
  objWordDoc.Application.ActiveDocument.Paragraphs.Add.Range.InsertBefore("")
  objWordDoc.Application.ActiveDocument.Paragraphs.Add.Range.InsertBefore("")

  Set rngPara = objWordDoc.Application.ActiveDocument.Paragraphs(1).Range
  With rngPara
    .Bold = True
    .ParagraphFormat.Alignment = 1
    .Font.Name = "Arial"
    .Font.Size = 12
  End With

  Set rngCurrent = objWordDoc.Application.ActiveDocument.Paragraphs(3).Range
  Set tabCurrent =  ObjWordDoc.Application.ActiveDocument.Tables.Add(rngCurrent,intNumrows,4)

  for i = 1 to colnum
    objWordDoc.Application.ActiveDocument.Tables(1).Rows(1).Cells(i).Range.InsertAfter theArray(i,1)
    objWordDoc.Application.ActiveDocument.Tables(1).Rows(1).Cells(i).Range.ParagraphFormat.alignment=1
  next
  tabRow = 2

  For j = 2 to intNumrows
    @#ObjWordDoc.Application.ActiveDocument.Tables(1).Rows(tabRow).Borders.Enable=False
    objWordDoc.Application.ActiveDocument.Tables(1).Rows(tabRow).Cells(1).Range.InsertAfter theArray(1,j)
    objWordDoc.Application.ActiveDocument.Tables(1).Rows(tabRow).Cells(1).Range.ParagraphFormat.alignment=1
    objWordDoc.Application.ActiveDocument.Tables(1).Rows(tabRow).Cells(2).Range.InsertAfter theArray(2,j)
    objWordDoc.Application.ActiveDocument.Tables(1).Rows(tabRow).Cells(2).Range.ParagraphFormat.alignment=1
    objWordDoc.Application.ActiveDocument.Tables(1).Rows(tabRow).Cells(3).Range.InsertAfter  FormatCurrency(theArray(3,j))
    objWordDoc.Application.ActiveDocument.Tables(1).Rows(tabRow).Cells(3).Range.ParagraphFormat.alignment=2
    objWordDoc.Application.ActiveDocument.Tables(1).Rows(tabRow).Cells(4).Range.InsertAfter theArray(4,j)
    @#objWordDoc.Application.ActiveDocument.Tables(1).Rows(tabRow).Cells(4).Range.InsertAfter Chr(10)
    objWordDoc.Application.ActiveDocument.Tables(1).Rows(tabRow).Cells(4).Range.ParagraphFormat.alignment=1
    tabRow = tabRow + 1
  Next

@#    objWordDoc.Application.ActiveDocument.Tables(1).Rows(tabRow).Cells(4).Range.ParagraphFormat.alignment=1

  @#objWordDoc.Application.ActiveDocument.Paragraph.Add.Range.InsertAfter(" ")
  @#objWordDoc.Application.ActiveDocument.Paragraph.Add.Range.InsertAfter(" ")
  @#objWordDoc.Application.ActiveDocument.Paragraph.Add.Range.InsertAfter("Regards,")
  @#objWordDoc.Application.ActiveDocument.Paragraph.Add.Range.InsertAfter(" ")
  @#objWordDoc.Application.ActiveDocument.Paragraph.Add.Range.InsertAfter("Daryl B. Morticum")
  @#objWordDoc.Application.ActiveDocument.Paragraph.Add.Range.InsertAfter("Sales Associate")
  @#objWordDoc.Application.ActiveDocument.Envelope.Insert Address
  @# objWordDoc.Application.ActiveDocument.Paragraphs.Add.Range.InsertAfter("由廖家远设计")

  objWordDoc.Application.ActiveDocument.SaveAs "tempSample.doc", 0,False,"",True,"",False,False,False, False,False
  @#objWordDoc.Application.printout()

End Sub
</script>