LogoLogo
About
  • Home
  • Guides
  • BDK
  • REST API
  • Release Notes
  • Getting Started
    • Excel Overview
  • Workbooks
    • Create an Excel File
  • Worksheets
    • Add a Worksheet
    • Get a Worksheet
    • Get Worksheets
    • Get an Item from an Excel Worksheet
    • Extract Text from a Worksheet
    • Remove a Worksheet
    • Save a Worksheet
  • Tables
    • Insert a Table
    • Extract a Table from a Worksheet
    • Get a Singular Table from an Excel Worksheet
    • Delete a Table
  • Rows
    • Get a Row
    • Get a Row's Cell
    • Insert a Row
  • Columns
    • Insert a Column
  • Cells
    • Get a Cell Value
    • Get a Cell's Column Label
    • Get a Cell's Formula
    • Get a Cell's Row Number
    • Set a Cell's Value
  • Changelogs
    • Get Changelog
    • Apply Changelog
Powered by GitBook
On this page
  • Overview
  • Prerequisite Data
  • Syntax
  • Examples

Was this helpful?

Export as PDF
  1. Tables

Extract a Table from a Worksheet

Locates and extracts a table from an Excel worksheet.

Overview

This procedure locates and extracts a table from an Excel worksheet.

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 a table from the worksheet where

What does it do? References an Excel worksheet from which a table is to be extracted 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.

the description is

What does it do? Describes the table to be extracted. Refer to Example 1 for details.

Where does it go? This phrase should be indented beneath extract a table from the worksheet where.

Does it require input data? ✅ Yes — A Text value should be specified.

Is it required? 🌟 No — This phrase is optional in the syntax.

the location is

What does it do? Specifies a range of cells where the table is located. Refer to Example 2 for details.

Where does it go? This phrase should be indented beneath extract a table from the worksheet where.

Does it require input data? ✅ Yes — A Text value should be specified.

Is it required? 🌟 No — This phrase is optional in the syntax.

the first header is

What does it do? Specifies the name of the header marking the start of the table. Refer to Example 3 for details.

Where does it go? This phrase should be indented beneath extract a table from the worksheet where.

Does it require input data? ✅ Yes — A Text value should be specified.

Is it required? 🌟 No — This phrase is optional in the syntax.

the last header is

What does it do? Specifies the name of the header marking the end of the table. Refer to Example 3 for details.

Where does it go? This phrase should be indented beneath extract a table from the worksheet where.

Does it require input data? ✅ Yes — A Text value should be specified.

Is it required? 🌟 No — This phrase is optional in the syntax.

Examples

1. Extract a Table by Specifying a Description

extract a table from the worksheet where
    the description is "This is a table which calculates housing cost information"

2. Extract a Table by Specifying the Location

extract a table from the worksheet where
    the location is "A1:B10"

3. Extract a Table by Specifying Headers

extract a table from the worksheet where
    the first header is "Name"
    the last header is "Age"

Last updated 4 days ago

Was this helpful?