Create Table from Excel

Create Table From File is an Advanced Table command. This command creates a table from an excel file.

This command allows you to create a table with the contents of an excel file.

The command comes with a browse button, which allows you to choose an excel file from your computer that you can use to create a table.

Excel File: The .xls file being used in the creation of a UBot table.

Table: the name of the table being created.

Example

create table from excel(&my table,"C:\\Users\\Downloads\\SampleData\\SampleData.xls")

Click the browse button to find a file you can use to create a table. Running the command will pull the data from the .xls file into a UBot table. In this example, &my table is the name of the table.

1. Prepare or find a comma delimited file for your table.

2. Click the browse button to find your file on your computer.

3. Check the debugger to make sure your table is properly populated.