Jak automatizovat Word z Visual Basic .NET vytvo�it nov� dokument

Uk�zkov� k�d

• Vlo�it odstavce s textem a form�tov�n�.
• Proch�zet a upravovat r�zn� rozsahy v r�mci dokumentu.
• Vlo�en� tabulek form�tov�n� tabulek a napln�n� tabulek daty.
• P�id�n� grafu.

1. Spus�te aplikaci Visual Studio .NET. V nab�dce soubor klepn�te na p��kaz Nov� a klepn�te na p��kaz projekt. Ve skupinov�m r�me�ku Project typyProjekty jazyka klepn�te na p��kaz Aplikace Windows v ��sti �ablony. Jako v�choz� je vytvo�en formul�� Form1.
2. P�idat odkaz Objektov� knihovny Microsoft Word. Postupujte takto:
   1. V nab�dce projekt klepn�te na tla��tko P�idat odkaz.
   2. Na kart� COM naj�t Knihovna objekt� aplikace a klepn�te na tla��tko Vybrat.
      
      Pozn�mka: Microsoft Office 2003 a nov�j�� verze syst�mu Office zahrnuj� prim�rn� sestaven� InterOp (PIA). Microsoft Office XP nezahrnuje PIA, ale mohou b�t sta�eny. Dal�� informace o sestaven�ch PIA sady Office XP naleznete v n�sleduj�c�m �l�nku znalostn� b�ze Microsoft Knowledge Base:
      328912

      (http://support.microsoft.com/kb/328912/ )

      Prim�rn� sestaven� InterOp (PIA) sady Office XP jsou k dispozici ke sta�en�
   3. Klepn�te na tla��tko OK v dialogov�m okn� P�idat odkazy p�ijmout va�e v�b�ry. Pokud se zobraz� v�zva ke generov�n� ob�lky pro vybran� knihovny klepn�te na tla��tko Ano.
3. V nab�dce Zobrazit vyberte panel zobrazen� panelu a potom p�idat tla��tko Form1.
4. Poklepejte na Button1. Zobraz� se okno s k�dem pro formul��.
5. V okn� k�du nahra�te n�sleduj�c� k�d

       Private Sub Button1_Click(ByVal sender As System.Object, _
         ByVal e As System.EventArgs) Handles Button1.Click
   
       End Sub

   s:

       Private Sub Button1_Click(ByVal sender As System.Object, _
         ByVal e As System.EventArgs) Handles Button1.Click
   
           Dim oWord As Word.Application
           Dim oDoc As Word.Document
           Dim oTable As Word.Table
           Dim oPara1 As Word.Paragraph, oPara2 As Word.Paragraph
           Dim oPara3 As Word.Paragraph, oPara4 As Word.Paragraph
           Dim oRng As Word.Range
           Dim oShape As Word.InlineShape
           Dim oChart As Object
           Dim Pos As Double
   
           'Start Word and open the document template.
           oWord = CreateObject("Word.Application")
           oWord.Visible = True
           oDoc = oWord.Documents.Add
   
           'Insert a paragraph at the beginning of the document.
           oPara1 = oDoc.Content.Paragraphs.Add
           oPara1.Range.Text = "Heading 1"
           oPara1.Range.Font.Bold = True
           oPara1.Format.SpaceAfter = 24    '24 pt spacing after paragraph.
           oPara1.Range.InsertParagraphAfter()
   
           'Insert a paragraph at the end of the document.
           '** \endofdoc is a predefined bookmark.
           oPara2 = oDoc.Content.Paragraphs.Add(oDoc.Bookmarks.Item("\endofdoc").Range)
           oPara2.Range.Text = "Heading 2"
           oPara2.Format.SpaceAfter = 6
           oPara2.Range.InsertParagraphAfter()
   
           'Insert another paragraph.
           oPara3 = oDoc.Content.Paragraphs.Add(oDoc.Bookmarks.Item("\endofdoc").Range)
           oPara3.Range.Text = "This is a sentence of normal text. Now here is a table:"
           oPara3.Range.Font.Bold = False
           oPara3.Format.SpaceAfter = 24
           oPara3.Range.InsertParagraphAfter()
   
           'Insert a 3 x 5 table, fill it with data, and make the first row
           'bold and italic.
           Dim r As Integer, c As Integer
           oTable = oDoc.Tables.Add(oDoc.Bookmarks.Item("\endofdoc").Range, 3, 5)
           oTable.Range.ParagraphFormat.SpaceAfter = 6
           For r = 1 To 3
               For c = 1 To 5
                   oTable.Cell(r, c).Range.Text = "r" & r & "c" & c
               Next
           Next
           oTable.Rows.Item(1).Range.Font.Bold = True
           oTable.Rows.Item(1).Range.Font.Italic = True
   
           'Add some text after the table.
           'oTable.Range.InsertParagraphAfter()
           oPara4 = oDoc.Content.Paragraphs.Add(oDoc.Bookmarks.Item("\endofdoc").Range)
           oPara4.Range.InsertParagraphBefore()
           oPara4.Range.Text = "And here's another table:"
           oPara4.Format.SpaceAfter = 24
           oPara4.Range.InsertParagraphAfter()
   
           'Insert a 5 x 2 table, fill it with data, and change the column widths.
           oTable = oDoc.Tables.Add(oDoc.Bookmarks.Item("\endofdoc").Range, 5, 2)
           oTable.Range.ParagraphFormat.SpaceAfter = 6
           For r = 1 To 5
               For c = 1 To 2
                   oTable.Cell(r, c).Range.Text = "r" & r & "c" & c
               Next
           Next
           oTable.Columns.Item(1).Width = oWord.InchesToPoints(2)   'Change width of columns 1 & 2
           oTable.Columns.Item(2).Width = oWord.InchesToPoints(3)
   
           'Keep inserting text. When you get to 7 inches from top of the
           'document, insert a hard page break.
           Pos = oWord.InchesToPoints(7)
           oDoc.Bookmarks.Item("\endofdoc").Range.InsertParagraphAfter()
           Do
               oRng = oDoc.Bookmarks.Item("\endofdoc").Range
               oRng.ParagraphFormat.SpaceAfter = 6
               oRng.InsertAfter("A line of text")
               oRng.InsertParagraphAfter()
           Loop While Pos >= oRng.Information(Word.WdInformation.wdVerticalPositionRelativeToPage)
           oRng.Collapse(Word.WdCollapseDirection.wdCollapseEnd)
           oRng.InsertBreak(Word.WdBreakType.wdPageBreak)
           oRng.Collapse(Word.WdCollapseDirection.wdCollapseEnd)
           oRng.InsertAfter("We're now on page 2. Here's my chart:")
           oRng.InsertParagraphAfter()
   
           'Insert a chart and change the chart.
           oShape = oDoc.Bookmarks.Item("\endofdoc").Range.InlineShapes.AddOLEObject( _
               ClassType:="MSGraph.Chart.8", FileName _
               :="", LinkToFile:=False, DisplayAsIcon:=False)
           oChart = oShape.OLEFormat.Object
           oChart.charttype = 4 'xlLine = 4
           oChart.Application.Update()
           oChart.Application.Quit()
           'If desired, you can proceed from here using the Microsoft Graph 
           'Object model on the oChart object to make additional changes to the
           'chart.
           oShape.Width = oWord.InchesToPoints(6.25)
           oShape.Height = oWord.InchesToPoints(3.57)
   
           'Add text after the chart.
           oRng = oDoc.Bookmarks.Item("\endofdoc").Range
           oRng.InsertParagraphAfter()
           oRng.InsertAfter("THE END.")
   
           'All done. Close this form.
           Me.Close()
   
       End Sub

6. P�idejte n�sleduj�c� k�d horn� Form1.vb:

   Imports Word = Microsoft.Office.Interop.Word

7. Stisknut�m kl�vesy F5 sestavit a spustit program.

Pou��t �ablonu

• M��ete m�t v�t�� kontrolu nad form�tov�n� a um�st�n� objekt� v cel�m dokumenty.
• M��ete vytvo�it dokumenty s m�n� k�d.

oWord.Documents.Add "<Path to your template>\MyTemplate.dot"

oDoc.Bookmarks.Item("MyBookmark").Range.Text = "Some Text Here"

oDoc.Bookmarks.Item("MyBookmark").Range.Style = "MyStyle"

oWord.Selection.Style = "MyStyle"

Zp�t nahoru | Dejte n�m zp�tnou vazbu