2 Replies Latest reply: Apr 2, 2015 12:06 PM by Emmanuel Robles RSS

    How do I read multiple tabs and exclude certain tabs when reading from excel in sharepoint?

    Emmanuel Robles

      Hello All,

       

      I am currently trying to pull in data from Excel spreadsheets in a document library in SharePoint. The issue is that I can read the files but there are three tabs that are standard in every workbook that I will not need to read. Every worksheet will contain the same column name. Another thing is that not all the workbooks will contain the same number of tabs and will not have uniform names. How can I write the script to call all the workbooks and pull in the necessary information yet exclude the three tabs? Thank you in advance for any help you can offer.

       

      - Emmanuel