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.
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.