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.
Create a new configuration of the OneDrive Excel Sheets writer.
Then click Authorize Account to authorize the configuration.
Click Add Table to configure export.
Select a Table from your buckets. Then click to Add table.
Use file picker to list accessible Excel files - workbooks.
Alternatively, you can Create a new workbook.
Go through the list and select file. Click Open to confirm the file you want to write to.
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.
Click Load worksheets to select worksheet from the workbook configured in the previous step.
Alternatively, you can Create a new worksheet.
In the list that appeared, click to the name of the worksheet you want to set as target.
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.
Click Save when you’re done.
When a table is added to the writer, 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 OneDrive account.
The list shows the row name, and the source table in Storage.
You can click to the row to modify the configuration.
You can create a new workbook instead of using existing.
Click to Create workbook.
Specify full file Path and click to Create.
File Name, Drive ID, and File ID are automatically filled in.
You can create a new worksheet instead of using existing.
Click to Create worksheet.
Specify the worksheet’s Name and click to Create.
Worksheet Name, and Worksheet ID are automatically filled in.