โ07-25-2017 08:06 AM
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?
โ07-25-2017 08:48 AM
That should be quite easy.
Put a File Reader and Excel Parser.
You can mention the sheet name as below. Let us know if it works are not.
Thanks & Regards,
Naveen
โ07-25-2017 09:03 AM
I tried reading the sheet name โconvert_1โ using โconvertโ in the parser and I get the error โSheet with the provided name does not existโ.
โ07-25-2017 09:04 AM
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
โ12-12-2017 11:43 AM
Raju - How do i read data from excel files ? Do i need to purchase Excel reader or any other snap can be utilized ?