"Slow reading Excel files"

Sintai
Sintai New Altair Community Member
edited November 5 in Community Q&A
Hi,

I have this problem, I have an excel file with 20 sheets, 60 attributes, and 60 rows(file have about 1MB). And when I choose this file for import, file reading takes about 7 minutes and it is so long time, if I  need import every sheets. Can I import all of sheets in one import process or Is some way How can i speed up this process?

Thank you. 
Tagged:

Answers

  • IngoRM
    IngoRM New Altair Community Member
    Hi,

    yip, this would be possible by using the "Read Excel" operator in a loop where you use the macro "%a" for the sheet parameter. Also use %a in the data set name for writing otherwise you would override the data in each iteration. This way you could automatically import and store all sheets in one single process.

    Cheers,
    Ingo

Categories