02-11-2018 11:47 PM
Hi ,
I have requirement to read a single sheet at a time and load the data in to a table from the same excel file which contains more than 40+ of sheets. Is it possible to do this through Snaplogic. Can some one suggest.
Thank You,
Mallikarjun
02-12-2018 07:22 AM
If you have little bit of flexibility in implementation, you can split that single excel file with multiple sheets into multiple excel files using few lines of code in Python (Note: Assuming schema is same in each sheet) and then you can just use multi file reader to read the excel files.
02-27-2019 11:26 AM
I ran into this same problem, and found a solution for my scenario. For this, you’ll need to know the names of the sheets that will be in the workbook, or the maximum number of sheets in the workbook. In my example, I knew the names of all the sheets I would need to read.
This process requires a child pipeline since the excel parser can only use sheet names from parameters and not values passed from an upstream document.
My process was:
03-14-2023 02:48 AM
can we get a sample pipeline of this example?
12-24-2020 06:02 PM
A FileReader snap that reads Excel from a URL. A Binary Router which splits the Output as shown below might work