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?
Page 1 / 1
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.