This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 

Excel to json pipeline

munish
New Contributor

โ€Ž04-21-2020 03:37 PM

I am trying to convert from Excel to json. The excel file do have multiple sheets. And I want to create same number of json files equals to sheet in excel. And the Json files name should be respective excel file sheet.

0 Kudos
1 REPLY 1

dimitri_hristov
Contributor

โ€Ž04-27-2020 09:40 AM

Hi @munish,

Do you know the number of sheets in the Excel file, and their respective names, in advance?

If you do know this information in advance, it could be relatively easy to accomplish this by using a child pipeline in which you can implement you logic for reading from the Excel file and writing the data to a JSON file.

Cheers,
Dimitri