Extract data from multiple Excel Files in DataPrep Studio 2022

Britt Kinsler
Britt Kinsler Altair Community Member
edited February 2023 in Community Q&A

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.

Tagged:

Answers

  • Lasse
    Lasse Altair Community Member
    edited February 2023

    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

Categories