Forum Discussion

munish's avatar
munish
New Contributor
6 years ago

Excel to json pipeline

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.

1 Reply

  • dimitri_hristov's avatar
    dimitri_hristov
    Contributor
    6 years ago
    Copy LinkReport

    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