AnsweredAssumed Answered

Iterate Tables in Model Builder

Question asked by geonetadmin on Mar 15, 2014
Latest reply on Mar 16, 2014 by Wayne_Whitley
Original User: jofuchs

Hi community,

I want to iterate through a folder with several Excel-files. Every Excel-File consits of one sheet. But when I chose the folder directory of all Excel-files as workspace for the iteration, the iterator doesn´t work because only the Excel-File is selected, but not the sheet of the Excel-file and the model stops immediately. What I can do is to join all the single Excel-files into one file with several sheets. Then I can choose this generated Excel-File as workspace and the following processing steps are applied correctly.

Is there another way to process every seperated Excel-file standalone so I can avoid the manuel data preparation?

Thanks in advance!

Jo

Outcomes