Has anyone had success with using the updated 2025.2 Excel writer to write data to a table in Excel? I see that this idea was implemented with 2025.2: Excel Writer: Explicit Table Support | Community
However, the instructions for the writer don’t go into a lot of detail on how to have the writer create a new table on a sheet and load it with the incoming data.
I personally tried to follow some of the older demo’s that walk throughs for writing to a named range. Those walkthroughs require you to create a template xlsx file with the named range already created. So for my 2025.2 test, I create a new template.xlsx file, then created a table named tData on Sheet1. The table is blank.
After that I created some dummy data in FME and tried to write it to a new excel file using the template. The output excel file does load the dummy data onto the sheet, but it doesn’t go into the table. And actually my table disappeared from the sheet.
It would be great if there were some tutorials out there for the following workflows:
1) How to have FME write data into a specific table on a specific sheet, in a new excel file. It would be great if this can all be done solely by defining the sheet and table names in the writer parameters. But if a template xlsx file is still needed, then that’s fine.
2)How to insert/update/delete rows in an existing table in an existing excel sheet
3) How to differentiate between named range and tables when writing. I’m personally more interested in tables, and never really used named ranges.