"Slow reading Excel files"

Sintai

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. 

IngoRM

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