Forum Discussion

bill_sturdivant's avatar
bill_sturdivant
New Contributor III
8 years ago

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?

6 Replies

  • nganapathiraju's avatar
    nganapathiraju
    Former Employee
    8 years ago

    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

    • sparvathaneni's avatar
      sparvathaneni
      New Contributor
      8 years ago

      Raju - How do i read data from excel files ? Do i need to purchase Excel reader or any other snap can be utilized ?

      • dmiller's avatar
        dmiller
        Former Employee
        8 years ago

        You would use a File Reader followed by an Excel Parser.

  • nganapathiraju's avatar
    nganapathiraju
    Former Employee
    8 years ago

    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

  • bill_sturdivant's avatar
    bill_sturdivant
    New Contributor III
    8 years ago

    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”.