保存网页数据到WORD

最新推荐文章于 2023-11-01 09:41:27 发布

gengwei80

最新推荐文章于 2023-11-01 09:41:27 发布

阅读量1.2k

点赞数

分类专栏： .NET Asp 文章标签： vbscript table 产品 button border build

本文链接：https://blog.csdn.net/gengwei80/article/details/222940

版权

.NET 同时被 2 个专栏收录

18 篇文章 0 订阅

订阅专栏

Asp

8 篇文章 0 订阅

订阅专栏

这篇博客展示了如何利用VBS（Visual Basic Script）脚本从网页上的表格提取数据，并将其保存到Word文档中。通过创建Word对象，设置表格样式，然后逐行逐列读取网页表格内容，最终将数据插入到Word表格中，生成的文档包含了网页上的产品信息，如产品名称、描述、单价和等级。

摘要由CSDN通过智能技术生成

<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>
</Table>
<input type=button οnclick="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
.Italic = True
    .ParagraphFormat.Alignment = 1
    .Font.Name = "Arial"
    .Font.Size = 10
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.Paragraphs.Add.Range.InsertAfter(" ")
objWordDoc.Application.ActiveDocument.Paragraphs.Add.Range.InsertAfter(" ")
objWordDoc.Application.ActiveDocument.Paragraphs.Add.Range.InsertAfter("Regards,")
objWordDoc.Application.ActiveDocument.Paragraphs.Add.Range.InsertAfter(" ")
objWordDoc.Application.ActiveDocument.Paragraphs.Add.Range.InsertAfter("Daryl B. Morticum")
objWordDoc.Application.ActiveDocument.Paragraphs.Add.Range.InsertAfter("Sales Associate")
' objWordDoc.Application.ActiveDocument.Envelope.Insert Address
objWordDoc.Application.ActiveDocument.Paragraphs.Add.Range.InsertAfter("由gengw设计")

objWordDoc.Application.ActiveDocument.SaveAs "test.doc", 0,False,"",True,"",False,False,False, False,False
'objWordDoc.Application.printout()

End Sub
</script>