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?
Userlevel 2
+16
- Contributor
- 2180 replies
-
9 June 2016
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.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.