---
title: "CreateTableFromWorkbooks"
slug: "createtablefromworkbooks"
updated: 2023-11-07T09:13:59Z
published: 2023-11-07T09:13:59Z
canonical: "docs.datajet.app/createtablefromworkbooks"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.datajet.app/llms.txt
> Use this file to discover all available pages before exploring further.

# CreateTableFromWorkbooks

Appends all the workbooks in a folder into the same table. (NOTE: Workbooks must have same format)

| Key | Value(s) | Description |
| --- | --- | --- |
| method | "CreateTableFromWorkbooks" | Appends all the workbooks in a folder into the same table. |
| project | "ProjectName" |  |
| worksheet | "WorksheetName" | Name of worksheet to load. If provided, will load a specific worksheet name. If missing, will load the first sheet. |
| table | "TableName" | Name of the table to create |
| headerRow | 1 | Row that contains the field names for the columns to create |
| startRow | 0 | First row of data to load. If 0, starts in row after header row. |
| endRow | 0 | Last row of data to load. If 0, all data is loaded. |
| ignoreEmptyRows | false | If true, empty rows will not be loaded. |
| worksheetRowName | "" | If provided, stores the name of the worksheet that the record was loaded from. |
| filenameColumn | "" | If provided, stores the workbook name that the record was loaded from. |
| allStringTypes | false | If true, all data will be loaded as string |
| leadingZeroAsStringType | false | If true, data with leading 0s (e.g., 0015242) will be loaded as string |
| miniDiscreteSize | 0 |  |
| path | "PathToFolder" | The Path to the folder containing the workbooks |
| order | "CREATED" |  |
| trimTrailingSpaces | false | If true, trailing spaces will be stripped as part of the load. |

```json
{
  "method": "CreateTableFromWorkbooks",
  "project": "",
  "worksheet": "",
  "table": "",
  "headerRow": 1,
  "startRow": 0,
  "endRow": 0,
  "ignoreEmptyRows": false,
  "worksheetRowName": "",
  "filenameColumn": "",
  "allStringTypes": false,
  "leadingZeroAsStringType": false,
  "minDiscreteSize": 0,
  "path": "",
  "order": "CREATED",
  "trimTrailingSpaces": false
}
```