Export JSON to Excel

Overview

Businesses can effortlessly convert JSON data into well-structured Excel spreadsheets, facilitating seamless analysis and reporting.
JSON data received from partners can be rapidly transformed into Excel files, simplifying the sharing process.
Appian workflows offer automated JSON to Excel conversion, enhancing overall automation efficiency.
Automation workflows can now incorporate JSON to Excel conversion, reducing the need for manual data handling.
Streamlined data entry and migration efforts by seamlessly converting JSON into Excel format.
Generate customized reports by converting specific JSON subsets into Excel sheets with built-in validations.
Archive and back up historical JSON data conveniently as Excel files.

Key Features & Functionality

Specify the sheet number for export.
Define the row number from which the export process should commence.
Choose whether to display headers in the Excel spreadsheet with a header flag.
Provide sheet names and output Excel document names as needed.
Support for both template-based reports with multiple/single sheets.
Fully customizable settings for sheet selection, row configuration, and header preferences.
Option to include validations, color, formulas, and header overrides with templates.
Template-free conversion for a more flexible approach.
Streamline automation processes seamlessly through Appian integration.
Receive detailed error messages for efficient troubleshooting.
Efficiently process large datasets with ease.
Facilitates data analysis and seamless sharing.
Designed for easy integration with automation workflows.

Parents

Kirang over 1 year ago

Hi Team,

I am trying to use this plug in and getting the below error.

Input:

My excel contains:

Kindly guide.
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
saipriyagoud over 1 year ago in reply to Kirang

Hello Kirang,

Thank you for using the JSON to Excel plugin.

You are encountering an error because you are providing the total JSON object directly to the plugin, which is incorrect.

First, you should store the JSON in a string object and then send the string variable as input to the plugin.

Please give this a try, and kindly let us know if you encounter any errors.

Best regards,

T . Saipriya Goud
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
saipriyagoud over 1 year ago in reply to Kirang

Hi Kirang,

Also one question do i need to pass excel template as an input to the service, if yes then I am hoping excel column names should match key values of json string passed. is this correct understanding?

To pass an Excel template as an input to the service, it's actually optional. If you choose to pass an Excel template, the data will be organized according to the template's structure. However, if you don't provide a template, a new Excel file will be created, and the data will be imported into it.

If you decide to pass an Excel template, you must specify the row number from which the data import should start. You also need to indicate whether you want the headers to be taken from the Excel template or from the JSON keys, which can be set as either "true" or "false."

Tried to pass string as pv as mentioned but still service is giving same error.

It seems like you attempted to pass a string as per the instructions but are still encountering an error. If you're working with nested JSON, please ensure you provide a standard JSON structure with key-value pairs for successful processing by the service.

Example :

[
{
"policyId": 2136,
"propertyId": 3323,
"clientId": 24528,
"subsidiaryId": 24529,
"countryId": 185,
"Client_Name": "QA- test data 6 jan -MTA bulk upload",
"Subsidiary_Name": "Sub 1",
"Fund_Name": "COSTR. IMMO. 2007 S.r.l"
},
{
"policyId": 2136,
"propertyId": 3323,
"clientId": 24528,
"subsidiaryId": 24529,
"countryId": 185,
"Client_Name": "QA- test data 6 jan -MTA bulk upload",
"Subsidiary_Name": "Sub 1",
"Fund_Name": "COSTR. IMMO. 2007 S.r.l"
}
]

Thanks & Regards ,
T . Saipriya
- Cancel
- Up 0 Down
- Reply
- More
- Cancel

Comment

saipriyagoud over 1 year ago in reply to Kirang

Hi Kirang,

Also one question do i need to pass excel template as an input to the service, if yes then I am hoping excel column names should match key values of json string passed. is this correct understanding?

To pass an Excel template as an input to the service, it's actually optional. If you choose to pass an Excel template, the data will be organized according to the template's structure. However, if you don't provide a template, a new Excel file will be created, and the data will be imported into it.

If you decide to pass an Excel template, you must specify the row number from which the data import should start. You also need to indicate whether you want the headers to be taken from the Excel template or from the JSON keys, which can be set as either "true" or "false."

Tried to pass string as pv as mentioned but still service is giving same error.

It seems like you attempted to pass a string as per the instructions but are still encountering an error. If you're working with nested JSON, please ensure you provide a standard JSON structure with key-value pairs for successful processing by the service.

Example :

[
{
"policyId": 2136,
"propertyId": 3323,
"clientId": 24528,
"subsidiaryId": 24529,
"countryId": 185,
"Client_Name": "QA- test data 6 jan -MTA bulk upload",
"Subsidiary_Name": "Sub 1",
"Fund_Name": "COSTR. IMMO. 2007 S.r.l"
},
{
"policyId": 2136,
"propertyId": 3323,
"clientId": 24528,
"subsidiaryId": 24529,
"countryId": 185,
"Client_Name": "QA- test data 6 jan -MTA bulk upload",
"Subsidiary_Name": "Sub 1",
"Fund_Name": "COSTR. IMMO. 2007 S.r.l"
}
]

Thanks & Regards ,
T . Saipriya
- Cancel
- Up 0 Down
- Reply
- More
- Cancel

Children

No Data