Forum Discussion

MallikarjunNuli's avatar
MallikarjunNuli
New Contributor
8 years ago

How to read Multiple Sheets from an excel dynamically using Snaplogic

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...
aditya_gupta41's avatar
aditya_gupta41
Contributor
3 years ago
Copy LinkReport

Its done. Escape character in CSV formatter is suppose to be blank.

Thanks Aleksandar for your quick help.

  • mikeandrews's avatar
    mikeandrews
    New Contributor III
    9 years ago
    Copy Link

    Sorry my point was that File Reader doesn’t accept a $variable parameter, so I am at a dead end as I can’t write a value to the pipeline _parameter either which it does accept.