I have a folder that contains all the excel files I need to parse. I need a way to combine all the workbook files and work sheets and parse the data into a new workbook in a table format. Can FME do this?
+17- Contributor
If all the worksheet in the source files have the same attribute columns, you can read all files by selecting them as the source of the reader (or use *.xls) as a source and you will need to merge the sheets by using the option: single merge feature type as shown in image below:
Then write to an Excel writer with one feature type.
1 person upvoted this
Reply
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.