Excel parser read worksheets where the name has "convert" in it
I have a requirement to read all the worksheets in a excel spreadsheet where the worksheet name has “convert” in it. Has anyone done anything like this?
Forum Discussion
If I further understand it, you would want an ability to pick up any sheet
that has “Convert” in it. Unfortunately, that is not an expression so you
cannot make up something like sheetName.indexOf(‘Convert’) != -1
So a formula is not possible to determine the sheet name.
Thanks & Regards,
Naveen
Raju - How do i read data from excel files ? Do i need to purchase Excel reader or any other snap can be utilized ?
You would use a File Reader followed by an Excel Parser.
Thank you so much !..
I have a source location ,every time there is a file in there my snap needs to pick that up and archive it .Can we achieve it in snaplogic ?
