Skip to main content

Task Office - Excel - Search Worksheets​

The Excel - Search worksheets Task searches an Excel file for a text and returns every matching cell. Each match is written on its own line as the cell address followed by the cell content.

Credentials

To control a remote computer you may need to use a Credential. The Credential must match the user name and password of the user that you want to login for. Select a Credential in the combo box or click the Settings icon to open Manage credentials in order to add or edit Credentials.

Select Excel file

Select the full path to the Excel file.

Password

Enter the password for the Excel file, if it is password protected.

Find what

Search text

Enter the text to search for.

Options

Within

  • Workbook — Searches all worksheets in the workbook. This is the default.
  • Worksheet — Searches one worksheet only. Select the worksheet in the list, or click the Get button to populate the list with worksheets from the selected file. The Task fails if no worksheet with this name exists.

Search

  • By Rows — Searches row by row. This is the default.
  • By Columns — Searches column by column.

Look in

  • Values — Searches the cell values. This is the default.
  • Formulas — Searches the cell formulas.
  • Comments — Searches the cell comments.

Match case

When checked, the search is case sensitive.

Match entire cell contents

When checked, a cell only matches if its entire content equals the search text.

Search worksheets > Output tab

Output to standard output / Output to file

Select Output to standard output to write the results to the standard output of the Task. Select Output to file to write them to a file.

File path

The full path of the output file. Only available when Output to file is selected.

Append to file

When checked, the output is added to the end of the file instead of replacing its contents.

Include BOM (if UTF8)

When checked, a byte order mark is written at the start of the file when the encoding is UTF-8.

Credentials

The Credential used to write the output file. Only available when Output to file is selected.

Include field names

When checked, the first line of the output contains the column names Address and Value.

Field separator

The character placed between the cell address and the cell content.

Text qualifier

The character placed around the cell content.

Line break

The character(s) used to separate the matches.