The XLSX reader supports reading multiple worksheets and named ranges from the same file. Because of this, multiple files are not supported, so you will need to create a separate reader for each Microsoft Excel spreadsheet.
The tables must be defined in the workspace before they can be read. In Microsoft Excel, tables can be either worksheets or named ranges. FME always signifies named ranges using the notation <sheetName>/<namedRangeName>.
The reader parameters dialog allows you to flag columns as one of [x_coordinate|y_coordinate|z_coordinate]. If both an x_coordinate and a y_coordinate attribute exist, features will be returned with Point geometries (when the values of those attributes are numbers). Z coordinates will be added to the points when they exist.
Different feature types are read by default depending on whether you open the reader parameters dialog:
If the reader is set to dynamic reading mode, then all sheets and all named ranges will be read into FME. This will result in duplicated data (since any information in a named range is also on the sheet that contains it), but it means that no feature types will be hidden by default.
Microsoft Excel Workbench Reader Parameters