Bubble to excel spreadsheet

Description

Introducing our latest plugin: Export Data to XLSX

This plugin takes input in the form of JSON objects and convert those data sources into excel sheets and creates a workbook of those Excel sheets.The user can send headers and set sheet and workbook names while exporting large data sets smoothly


Key Features:


Workbook Name: The plugin allows user to set name of the workbook in a dynamic field

Sheet Name: User can set name of sheets by just putting it in the key input of that data source.

Column Header: The column header is set inside the JSON object which can contain multiple keys and their values
Important: To maintain clarity, the image is provided to demonstrate necessary steps for creating a workbook


Element Name: Convert-to-XLSX (action element)

Actions:

1- Trigger an action event by adding the element: Convert-to-XLSX
2- Enter Name of Workbook in the Input: Workbook Name
3- Click on Set Another key / value under the source heading
4- Add sheet name in key input
5- Add data source and format it as text
6- Create a JSON object in the format as text where key will be the header and the value will be the list of desired list of values from that data source 

( check demo data for better understanding )
7- Data source should be enclosed in square brackets 

Input

Output

Was this article helpful?

0 out of 0 liked this article