# Tables

### Overview

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

### Syntax

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

<details>

<summary><code>extract a table from the worksheet</code></summary>

#### What does it do?

Begins table extraction from the current worksheet.

#### Where does it go?

This phrase should be written on a **new line**.

#### Is it required?

✅ Yes — This phrase is **required**.

#### Does it require data?

✅ Yes — A reference to **the worksheet** must be defined in the automation.

</details>

<details>

<summary><code>the description is "table-description"</code></summary>

#### What does it do?

Describes the table to be extracted.

#### Where does it go?

Indented under `extract a table from the worksheet where`.

#### Is it required?

❌ No — This phrase is **optional**.

#### Does it require data?

✅ Yes — Replace **table-description** with a text description of the table you want to extract.

#### Example

```
the description is "sales data with monthly totals"
```

</details>

<details>

<summary><code>the location is "A1:D10"</code></summary>

#### What does it do?

Specifies the cell range containing the table.

#### Where does it go?

Indented under `extract a table from the worksheet where`.

#### Is it required?

❌ No — This phrase is **optional**.

#### Does it require data?

✅ Yes — Replace **A1:D10** with a cell range in Excel format that specifies the top-left and bottom-right corners of the table.

#### Example

```
the location is "A1:D10"
```

</details>

<details>

<summary><code>the first header is "x"</code></summary>

#### What does it do?

Specifies the leftmost column header to start extraction.

#### Where does it go?

Indented under `extract a table from the worksheet where`.

#### Is it required?

❌ No — This phrase is **optional**.

#### Does it require data?

✅ Yes — Replace **x** with the name of the first column header.

#### Example

```
the first header is "Name"
```

</details>

<details>

<summary><code>the last header is "y"</code></summary>

#### What does it do?

Specifies the rightmost column header to end extraction.

#### Where does it go?

Indented under `extract a table from the worksheet where`.

#### Is it required?

❌ No — This phrase is **optional**.

#### Does it require data?

✅ Yes — Replace **y** with the name of the last column header.

#### Example

```
the last header is "Total"
```

</details>

<details>

<summary><code>the first header location is "A6"</code></summary>

#### What does it do?

Specifies the exact cell location of the first header.

#### Where does it go?

Indented under `extract a table from the worksheet where`.

#### Is it required?

❌ No — This phrase is **optional**.

#### Does it require data?

✅ Yes — Replace **A6** with an Excel cell reference where the first header is located. Must be on the same row as the last header location.

#### Example

```
the first header location is "A6"
```

</details>

<details>

<summary><code>the last header location is "DR6"</code></summary>

#### What does it do?

Specifies the exact cell location of the last header.

#### Where does it go?

Indented under `extract a table from the worksheet where`.

#### Is it required?

❌ No — This phrase is **optional**.

#### Does it require data?

✅ Yes — Replace **DR6** with an Excel cell reference where the last header is located. Must be on the same row as the first header location.

#### Example

```
the last header location is "DR6"
```

</details>

<details>

<summary><code>the row count is 40000</code></summary>

#### What does it do?

Limits the number of data rows to extract (excluding header).

#### Where does it go?

Indented under `extract a table from the worksheet where`.

#### Is it required?

❌ No — This phrase is **optional**.

#### Does it require data?

✅ Yes — Replace **40000** with the number of data rows to extract. If omitted, extracts to the end of the worksheet.

#### Example

```
the row count is 40000
```

</details>

<details>

<summary><code>the openai model is "openai-model"</code></summary>

#### What does it do?

Specifies the OpenAI model to use for AI-powered table extraction.

#### Where does it go?

Indented under `extract a table from the worksheet where`.

#### Is it required?

❌ No — This phrase is **optional**.

#### Does it require data?

✅ Yes — Replace **openai-model** with a valid OpenAI model name.

#### Example

```
the openai model is "gpt-4o"
```

</details>

<details>

<summary><code>the gemini model is "gemini-model"</code></summary>

#### What does it do?

Specifies the Gemini model to use for AI-powered table extraction.

#### Where does it go?

Indented under `extract a table from the worksheet where`.

#### Is it required?

❌ No — This phrase is **optional**.

#### Does it require data?

✅ Yes — Replace **gemini-model** with a valid Gemini model name.

#### Example

```
the gemini model is "gemini-2.0-flash"
```

</details>

### Examples

#### 1. Extract Table by Description

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

#### 2. Extract Table by Cell Range

Extracts a table from a specific cell range.

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

#### 3. Extract Table by Header Range

Extracts a table between specified column headers.

```
extract a table from the worksheet where
    the first header is "Employee ID"
    the last header is "Department"
```

#### 4. Extract Table by Header Locations (Fast)

Extracts a table using exact header cell locations - faster than header name matching.

```
extract a table from the worksheet where
    the first header location is "A6"
    the last header location is "DR6"
```

#### 5. Extract Table by Header Locations with Row Limit

Extracts a table using header locations with a specific number of data rows.

```
extract a table from the worksheet where
    the first header location is "A6"
    the last header location is "DR6"
    the row count is 40000
```

#### 6. Extract Table by Description with Custom Model

Extracts a table using AI-powered description with a specific model.

```
extract a table from the worksheet where
    the description is "Sales data table with monthly revenue and profit columns"
    the openai model is "gpt-4o"
```


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.kognitos.com/legacy/legacy-experience/automation-areas/excel-v2/extract-a-table-from-a-worksheet.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.