Microsoft Word connector methods

The Microsoft Word connector methods enable you to perform various day-to-day tasks with Microsoft Word documents and automate them. For example, add a page footer.

Open

Opens a Microsoft Word file saved on the local disk.

Note: You must execute this method before executing any other method on the Microsoft Word connector.

For details on the issues related to the Open method, see KB article KB1123558 and KB article KB1123548.

AddFooter

Adds a footer to the Microsoft Word document in the specified font size.

To use this method, provide the text to be added to the Text parameter and the font size in which the footer text needs to be displayed to the FontSize parameter. Default value of the FontSize parameter is 12.

Note: You must execute the Open method before executing this method.

To provide inputs, see Configure port properties

AddHeader

Adds a header to a Microsoft Word document in specified font size.

To use this method, provide the text to be added to the Text parameter and the font size in which the header text needs to be displayed to the FontSize parameter. Default value of the FontSize parameter is 12.

Note: You must execute the Open method before executing this method.

CellCopy

Copies the content of a table cell identified using the row index and column index of the table in a Microsoft Word document.

To use this method, provide the row index to the RowIndex parameter and column index to the ColumnIndex parameter. The default value for RowIndex and ColumnIndex is -1 each.

Note: You must execute the SetTable method before executing this method.

CellPaste

Pastes the copied table cell content into a table cell identified using the row index and column index of the table in a Microsoft Word document.

To use this method, provide the row index to the RowIndex parameter and column index to the ColumnIndex parameter. The default value for RowIndex and ColumnIndex is -1 each.

Note: You must execute the SetTable and CellCopy methods before executing this method.

Close

Closes the last opened Microsoft Word document. While closing the document, it is optional to save changes.

If modification done to the word document needs to be saved then set the saveChanges boolean parameter to True, else set it to False. By default the saveChanges boolean parameter is set to True.

Note: You must execute the Open method before executing this method.

DeleteColumn

Deletes a column from a table based on a specified index value of the column in a Microsoft Word document.

To use this method, provide the index of the column that needs to be deleted to the ColumnIndex parameter. Default value is -1.

Note: You must execute the SetTable method before executing this method.

DeletePage

Deletes a page based on a specified index value from a Microsoft Word document.

To use this method, provide the index value of the page that needs to be deleted to the PageIndex parameter.

Note: You must execute the Open method before executing this method.

DeleteRow

Deletes a row based on the specified index value from a table in a Microsoft Word document.

To use this method, provide the index of the row that needs to be deleted to the RowIndex parameter. Default value is -1.

Note: You must execute the SetTable method before executing this method.

DeleteTable

Deletes a table from a Microsoft Word document.

If the document has multiple tables, the method deletes the first table in the document.

Note: You must execute the SetTable method before executing this method.

ExportToPDF

Exports a Microsoft Word document to a PDF document at a specified path.

To use this method, provide the path where the PDF file needs to be extracted to the Filepath parameter.

Note: You must execute the Open method before executing this method.

Find

Finds the text you specify in a Microsoft Word document and returns a Boolean response.

To use this method, provide the text that you want to find in the document to the Text parameter.

GetCellValueByIndex

Returns the value of a cell in a table in a Microsoft Word document.

To use this method, provide the index of the cell to retrieve the cell value to the CellIndex parameter.

Note: You must execute the SetTable method before executing this method.

GetFooterText

Returns the footer text in a Microsoft Word document.

Note: You must execute the Open method before executing this method.

GetHeaderText

Returns the header text in a Microsoft Word document.

Note: You must execute the Open method before executing this method.

GetPageCount

Returns the total number of pages in a Microsoft Word document.

GetRowIndexByValue

Returns the row index value of a row based on the specified value of a cell in the row.

To use this method, provide the document table to the Table parameter to retrieve the index of the row based on the value provided to the Value parameter.

Note: You must execute the GetTable and SetTable methods before executing this method.

GetTable

Returns the data in a table of a Microsoft Word document as a table object and data table. If the document contains multiple tables, you can specify the table index to identify the table for the method. You can also specify the table type, if needed.

To use this method, provide the index of the expected table to the TableIndex parameter. Set the FirstRowIsHeader parameter to True if the first row needs to be treated as header, else it is set to False.

Depending on the table structure, you can optionally configure the table type for the method. To configure the table, do the following steps.

1. Click the method settings icon (

1. Select the table type.
2. Click OK.

GetTableCellValues

Returns the values in one or more table cells.

To use this method, provide the indices of the table cells whose value is required, in the configuration window.

To specify the number of cells, you must configure the index values of the cells. To configure, do the following.

1. Click the method settings icon (

1. Click (

1. Enter the index values for the cells.
2. Repeat the steps to add more index values.
3. Click OK.

GetTableCount

Returns the number of tables in a Microsoft Word document. You can optionally specify the type of table for the method to identify.

Select the table type from the config window. If you expect to receive total number of tables in a word document, then the table type is set to 'Default'. If a count of nested tables within a cell in a table is expected then set the table type to 'Nested'. Provide the index of table which has nested tables to the TableIndex parameter and table cell index from which count of nested tables is expected to CellIndex parameter.

To configure the type of table, do the following steps.

1. Click the method settings icon (

1. Select the table type.
2. Click OK.

GetTableRowData

Returns the values in one or more cells of a row in a Microsoft Word document. You can specify the index values of the cells of the row.

Note: You must execute the SetTable method before executing this method.

You can configure the index values of the cells in a row. To configure, do the following steps.

1. Click the method settings icon (

1. Click the add index value icon (

1. Enter the index value of the cell.
2. Repeat the steps to add more index values.
3. Click OK.

GetText

Returns all the text content in a Microsoft Word document.

InsertNewColumn

Inserts a new column in the first table in the document based on the specified index value.

To use this method, provide the index number at which a new column needs to be inserted to the ColumnIndex parameter. Default value is -1, which means that a column is inserted before the first column.

InsertNewRow

Inserts a new row based on the index value.

To use this method, provide the index number at which a new row needs to be inserted to the RowIndex parameter. Default value is -1, which means a row is inserted before the first row.

InsertPicture

Inserts an image into Microsoft Word document from the file path provided at a particular bookmark.

To use this method, provide the file path of the image that needs to be inserted to the ImageFilePath parameter. Provide the identification place at which the image needs to be inserted in the Word document to the Bookmark parameter.

InsertTable

Inserts a table into a Microsoft Word document. You can optionally customize the document by configuring it before inserting.

To use this method, the point at which the table needs to be added is provided to the Bookmark parameter and the table that needs to be added should be passed to the Data parameter.

Note: Before executing this method, you must execute the GetTable and SetTable methods.

To customize the table before inserting, do the following steps.

1. Click the method settings icon(

1. Select Include Headers.
2. Select border style and autofit behavior.
3. Select Include Empty Rows.
4. To ignore specific columns, click the add index value icon (

1. Enter the index value of the column.
2. Click OK.

InsertText

Inserts text in the beginning of the Microsoft Word document.

To use this method, provide a value that needs to be inserted to the text parameter.

IsOpen

Checks whether a Microsoft Word document is open.

MergeByCellIndices

Merges the range of cells specified in the form of index value range.

To use this method, provide the starting cell index value to the StartCellIndex parameter and ending cell index value to the EndCellIndex parameter.

MergeByRowCol

Merges a range of cells of a table in a Microsoft Word document.

To use this method, provide the starting row index to the StartRowIndex parameter, ending row index to the EndRowIndex parameter, and starting column index to the StartColIndex parameter and ending column index to the EndColIndex parameter.

ReplaceBookmark

Replaces a bookmark in a Microsoft Word document with the specified text.

To use this method, provide the identification bookmark to Bookmark parameter with the text to be replaced given to the ReplaceText parameter.

ReplaceBookmarks

Finds and replaces multiple bookmarks in a Microsoft Word document with the specified text.

To use this method, provide value to the added field(s) which is the text with which the bookmark needs to be replaced.

Provide more details of the bookmark text to replace as follows:

1. Double-click the component.
2. In the PROVIDE LABELS/BOOKMARKS dialog box, click the click to add label icon (

Repeat this step to add more bookmarks.

1. Click OK.

ReplaceFooterText

Finds and replaces the footer text in a Microsoft Word document with the specified text.

Provide the original footer text value that is present in the word document to the FindText parameter and the text with which original footer text has to be replaced to the ReplaceText parameter.

ReplaceHeaderText

Finds and replaces the header text in a Microsoft Word document with the specified text.

Provide the original header text value that is present in the word document to the FindText parameter and the text with which original header text has to be replaced to the ReplaceText parameter.

ReplaceStaticText

Finds and replaces the text in a Microsoft Word document with the specified text. Replaces bookmarks, headings, or any text based on the configuration.

To use this method, provide a value to the added field which is the text with which the label / bookmark needs to be replaced.

You must configure the method before executing. To configure, do the steps.

1. Click the method settings icon (

1. Click the add text icon (

1. Enter the heading, bookmark, or text that you want to replace.
2. Repeat the steps to enter more text.
3. Click OK.

ReplaceText

Finds and replaces the text in a Microsoft Word document with the specified text.

Provide the original text value that is present in the word document to the FindText parameter and the text with which original text has to be replaced to the ReplaceText parameter.

Resize

Resizes the window of a Microsoft Word document according to the left, top, width and height parameters.

To use this method, specify the Left and Top margins and the Width and Height parameters for the content.

Save

Saves the opened Microsoft Word document.

SaveAs

Saves a copy of the opened Microsoft Word document with another name at a location provided in the Filepath parameter.

To use this method, provide the new location to which the Microsoft Word document needs to be saved in the Filepath parameter. If the file needs to be password protected, pass the value to the Password parameter.

SetTable

Sets a table in a Microsoft Word document.

To use this method, it is necessary to pass the table object to the Table parameter.

SetTableCellValues

Sets the content of a table cell in a Microsoft Word document.

To use this method, provide the indices of the table cells whose value needs to be set in the configuration window.

Provide one or more cell indexes and value types as follows:

1. Double-click the component.
2. In the PROVIDE CELL INDEXES dialog box, click the click to add cell index icon (

Repeat this step to add more cell indexes and value types.

1. Click OK.

SetTableRowData

Sets the content in a row of a table in a Microsoft Word document.

To use this method, index of the table row at which the data needs to be set is passed to the RowIndex parameter.

Note: You must execute the SetTable method before executing this method.

• Input

  RowIndex

  Provide the column index as follows:

  1. Double-click the component.
  2. In the PROVIDE COLUMN INDEXES dialog box, click the click to add cell index icon (

3.  Click **OK**.

Parent Topic:Microsoft Word