OneDrive Excel Sheets

This writer exports tables from your Storage tables as Excel sheets to Microsoft OneDrive.

Microsoft OneDrive cloud storage integrates Office365 and SharePoint sites, so with this writer you can write to any Excel sheet on your personal or business account.

The contents of the sheet can be overwritten or new lines can be added at the end.

Configuration

Create a new configuration of the OneDrive Excel Sheets writer.
Then click Authorize Account to authorize the configuration.

Click Add Table to configure export.

Screenshot - Empty configuration

Select a Table from your buckets. Then click to Add table.

Screenshot - Add table popup

Use file picker to list accessible Excel files - workbooks.
Alternatively, you can Create a new workbook.

Screenshot - Use file picker

Go through the list and select file. Click Open to confirm the file you want to write to.

Screenshot - Select file

The target file is specified by Drive ID and File ID. They are automatically filled in.
File Name is for your information only and its change doesn’t affect functionality.

Screenshot - Workbook config

Click Load worksheets to select worksheet from the workbook configured in the previous step.
Alternatively, you can Create a new worksheet.

Screenshot - Empty worksheet config

In the list that appeared, click to the name of the worksheet you want to set as target.

Screenshot - Select worksheet

The worksheet is specified by Worksheet ID. It is automatically filled in.
Worksheet Name is for your information only and its change doesn’t affect functionality.

You can check Append checkbox to append new rows after the existing ones,
otherwise the contents of the worksheet will be overwritten.

Screenshot - Select worksheet

Click Save when you’re done.

Screenshot - Select worksheet

Modify Configuration

When a table is added to the writer, it is displayed in the list of tables.

Configured tables are stored as configuration rows.

Screenshot - Save

Each table has a different setting, but all tables share the same authorization to OneDrive account.

The list shows the row name, and the source table in Storage.

You can click to the row to modify the configuration.

Create a new workbook

You can create a new workbook instead of using existing.

Click to Create workbook.

Screenshot - Create workbook button

Specify full file Path and click to Create.

Screenshot - Create workbook popup

File Name, Drive ID, and File ID are automatically filled in.

Create a new worksheet

You can create a new worksheet instead of using existing.

Click to Create worksheet.

Screenshot - Create worksheet button

Specify the worksheet’s Name and click to Create.

Screenshot - Create worksheet popup

Worksheet Name, and Worksheet ID are automatically filled in.