🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

Extract data from multiple Excel Files in DataPrep Studio 2022

User: "Britt Kinsler"
Altair Community Member
Updated by Britt Kinsler

Hi, I'm a newbie here.  I've created a workspace to extract data from an Excel file in Report Designer, but unable to figure out how to apply that same model extract to other spreadsheets with the same format.  I'm able to add other reports for PDF and text, but this isn't available for Excel files.

I'd really appreciate some suggestions how to work with this as I don't have an automator license.  I suppose I could append them all together using VBA in Excel, but hoping there's an easier way in DP studio.

Find more posts tagged with

Sort by:
1 - 1 of 11
    User: "Lasse"
    Altair Community Member
    Updated by Lasse

    Hi, here is also one who would like to hear the answer to this question. I haven't found a way to extract data from several excel files.

    -Lasse