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...
doug_fossler's avatar
doug_fossler
New Contributor
8 years ago
Copy LinkReport

I am not doing this inside a mapper snap, i am attempting to do this in javascript inside a script snap on purpose.

Supratim's avatar
Supratim
Contributor III
8 years ago
Copy LinkReport

@doug.fossler

use mapper only. Why need to have script snap? always trying to ignore script as much as possible.

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

    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.