Visokio website     Downloads     Video tutorials     KnowledgeBase  
Batch Append: Importing Workbook Tabs from Varying Files in Folder - Visokio Forums
Batch Append: Importing Workbook Tabs from Varying Files in Folder
  •        benjamin March 24, 2015 4:55AM
    Hi

    I would like to batch append Excel files in a folder. Each Excel file has multiple tabs. I only want to import and append certain tabs...e.g. tabs named "abc" from each workbook file in the folder

    How do I do this ?

    Currently in the batch append source block I can only batch append based on names of Excel files rather then the name of the tab? Or can I specify the name of the file and the name of the tab as a extension somehow to overcome this?

    Thanks, Ben
  • 1 Comment
  •        benjamin March 24, 2015 5:01AM
    No worries have found the solution. There is a worksheet section in the batch append source block

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership

Tagged