Skip to main content
Open

Excel Writer: Explicit Table Support

Related products:Integrations

evieatsafe
Safer

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.

6 replies

warrendev
Enthusiast
Forum|alt.badge.img+23
  • Enthusiast
  • January 5, 2024

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+15
  • Safer
  • April 24, 2024
The following idea has been merged into this idea:

All the votes have been transferred into this idea.

LizAtSafe
Safer
Forum|alt.badge.img+15
  • Safer
  • June 15, 2024
The following idea has been merged into this idea:

All the votes have been transferred into this idea.

dannymatranga
Contributor
Forum|alt.badge.img+5

Adding table support would be very helpful for my workflows.


dannymatranga
Contributor
Forum|alt.badge.img+5

Any update on this idea? ​@evieatsafe 


evieatsafe
Safer
  • Author
  • Safer
  • April 1, 2025

@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! 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings