Skip to main content
Released

Excel Writer: Explicit Table Support

Related products:Integrations
  • Dec 11, 2023 11:10 PM UTC
  • 8 replies
  • 324 views

evieatsafe
Safer
Forum|alt.badge.img+28

User is trying to write out an explicit table https://support.microsoft.com/en-au/office/overview-of-excel-tables-7ab0bb7d-3a9e-4b56-a3c9-6c94334e492c rather than a block of data styled as a table. Currently the data writes out without issue but the table stays as a single row, not expanding to fit the data in the table.


Similar to this community thread, and this idea.


Currently, FME's Excel writing library does not have support for tables and we cannot modify them. Excel has marked out the table’s extents in the sheet and we are simply appending to the existing range. With enough interest we could add a new library to tackle this issue.

8 replies

warrendev
Influencer
Forum|alt.badge.img+28
  • Influencer
  • Jan 5, 2024 4:54 AM UTC

This would be really nice to have! Currently, I'm limited to using an Excel template with macros or a Python library like openpyxl. Having this built-in support for tables would be a great addition!


LizAtSafe
Safer
Forum|alt.badge.img+26
  • Safer
  • Apr 24, 2024 8:30 PM UTC
The following idea has been merged into this idea:

All the votes have been transferred into this idea.

LizAtSafe
Safer
Forum|alt.badge.img+26
  • Safer
  • Jun 15, 2024 3:48 AM UTC
The following idea has been merged into this idea:

All the votes have been transferred into this idea.

dannymatranga
Contributor
Forum|alt.badge.img+7

Adding table support would be very helpful for my workflows.


dannymatranga
Contributor
Forum|alt.badge.img+7

Any update on this idea? ​@evieatsafe 


evieatsafe
Safer
Forum|alt.badge.img+28
  • Author
  • Safer
  • Apr 1, 2025 7:22 PM UTC

​@dannymatranga they’re looking into it! Right now we’re limited to the library that we use for the Excel writer, but word is that this library plans on supporting explicit tables in the future. Unfortunately, we won’t be able to implement this functionality until they have implemented support. Sorry about the inconvenience! 


LizAtSafe
Safer
Forum|alt.badge.img+26
  • Safer
  • Jul 31, 2025 10:00 PM UTC
Open→In Development

LizAtSafe
Safer
Forum|alt.badge.img+26
  • Safer
  • Nov 25, 2025 8:35 PM UTC
In Development→Released