How to export data into an Excel workbook
To generate an Excel file: Step 1. Drag and drop the Excel Workbook Export Block from the Block Library, or right-click on the Main Canvas and select “Add Export Block” and then “Excel Workbook Export”. Step 2. Connect the Excel Workbook Export Block to a block that contains the data that you would like to export. Step 3. Click on the Excel Workbook Export Block to access its settings. Step 4. Press on the “New Workbook” button. Select the “Start with an empty Excel workbook” option and provide the destination folder and name of the file that will be generated. You can also select the Excel version, specify the backup options, include date and time in the file name, or add a custom time stamp here. Click “OK” to confirm. Step 5. By default, Analytics Canvas will write the data to Sheet 1, starting with cell A1. You can change this by pressing the “Pick” button and selecting where you would like to place the data. Step 6. Press the “Run with Outputs” button to write data to the Excel file.
To generate an Excel file: Step 1. Drag and drop the Excel Workbook Export Block from the Block Library, or right-click on the Main Canvas and select “Add Export Block” and then “Excel Workbook Export”. Step 2. Connect the Excel Workbook Export Block to a block that contains the data that you would like to export. Step 3. Click on the Excel Workbook Export Block to access its settings. Step 4. Press on the “New Workbook” button. Select the “Start with an empty Excel workbook” option and provide the destination folder and name of the file that will be generated. You can also select the Excel version, specify the backup options, include date and time in the file name, or add a custom time stamp here. Click “OK” to confirm. Step 5. By default, Analytics Canvas will write the data to Sheet 1, starting with cell A1. You can change this by pressing the “Pick” button and selecting where you would like to place the data. Step 6. Press the “Run with Outputs” button to write data to the Excel file.