Extract Text from a Worksheet

Extracts all text from an Excel worksheet

Overview

This procedure extracts text from an Excel worksheet, providing a spatial representation of the data.

Extracting text from large Excel worksheets may be slow and is not recommended.

Prerequisite Data

These required data elements must be present in the automation before using the procedure.

Data Name	Data Type
the worksheet	Excel Worksheet

Syntax

Below is a line-by-line overview of the automation syntax. Expand each line to learn more.

extract text from the worksheet

What does it do? References an Excel worksheet to extract text from.

Where does it go? This phrase should be written on a new line.

Does it require input data? ⛔ No — This phrase does not require input data.

Is it required? ✅ Yes — This phrase is required in the syntax.

Examples

1. Extract Text from an Excel Worksheet

extract text from the worksheet