I have multiple Excel files, each containing multiple sheets of the same format. Each Excel actually only needs sheets 2, 3, 4, and 5. Is there a way to read in the required sheets from each Excel file or csv file in the synaspe pipeline and output each to file data? The image is an idea of what I would like to do.
The way I am aware of is to specify the sheets, so I would like to know how to do this in one pipeline. enter image description here