This extractor loads Excel sheets from Microsoft OneDrive and stores them as tables in a bucket in your current project.
Click Add Table to configure extraction.
Fill in the name and, optionally, the description. Then click Add Table.
These values will help you easily identify the extraction later.
Use the file picker to list accessible Excel files – workbooks.
Go through the list and select a file. Click Open to confirm the file you want to import.
The file is specified by a Drive ID and by a File ID. They are automatically filled in.
The file name is for your information only and changing it doesn’t affect functionality.
Click Load Worksheets to select a worksheet from the workbook you configured in the previous step.
In the list that appeared, click on the name of the worksheet you want to import.
The worksheet is specified by a Worksheet ID. It is automatically filled in.
The worksheet name is for your information only and changing it doesn’t affect functionality.
The output table name is automatically filled in with the worksheet name.
You can manually change it to suit your needs. If the table doesn’t exist, it will be created.
Click Save when you’re done.
When a table is added to the extractor, it is displayed in the list of tables.
Configured tables are stored as configuration rows.
Each table has a different setting, but all tables share the same authorization to your OneDrive account.
The list shows the row name and the destination table in Storage.
You can click on the row to modify the configuration.
© 2023 Keboola