Skip to main content
Open

Excel Writer: Explicit Table Support

Related products:Integrations
rlundstrum
siennaatsafe
redgeographics
danilo_fme
warrendev
+102
  • rlundstrum
    rlundstrum
  • siennaatsafe
    siennaatsafe
  • redgeographics
    redgeographics
  • danilo_fme
    danilo_fme
  • warrendev
    warrendev
  • tcrossman
    tcrossman
  • vxn43
    vxn43
  • j.botterill
    j.botterill
  • oscard
    oscard
  • runneals
    runneals
  • bruceharold
    bruceharold
  • fgiron
    fgiron
  • lars_de_vries
    lars_de_vries
  • chriswilson
    chriswilson
  • mgg_beca
    mgg_beca
  • canerakin
    canerakin
  • johnk
    johnk
  • juanmahere
    juanmahere
  • gbj1717
    gbj1717
  • jpdenboer
    jpdenboer
  • gerhard
  • e.degraaff
    e.degraaff
  • j.frolik
    j.frolik
  • pi_hellz
    pi_hellz
  • peterx
  • surbhi
    surbhi
  • hzhong
    hzhong
  • sam_a
    sam_a
  • brennanfuchs
    brennanfuchs
  • trym
    trym
  • nn_sonomacounty
    nn_sonomacounty
  • pratsch
    pratsch
  • ml56067
    ml56067
  • thomasd
    thomasd
  • cjd111
    cjd111
  • cstewartfortsas
    cstewartfortsas
  • trevorb
    trevorb
  • neilmyoung
    neilmyoung
  • thaverkort
    thaverkort
  • friesewoudloper
    friesewoudloper
  • ascollins1
    ascollins1
  • jarrydhunter
    jarrydhunter
  • nickyaclift
  • cwarren
    cwarren
  • jochgem
    jochgem
  • oshkosh_gis
  • ec2020uk
  • peters
  • hal98x
  • olof
  • justinpaixao
  • ecthelion
    ecthelion
  • mmccart
    mmccart
  • salvaleonrp
    salvaleonrp
  • lau
    lau
  • johnt
    johnt
  • dxirgu
    dxirgu
  • marnickcle
    marnickcle
  • crutledge
    crutledge
  • ngstoke
    ngstoke
  • gavinpark
    gavinpark
  • jobou
  • qmarquette
  • jasonclemis
  • anari
    anari
  • ferdinandbogman
    ferdinandbogman
  • stezi
    stezi
  • tfsrichard
  • tiztrain
    tiztrain
  • jfisch25
    jfisch25
  • spatialcase
    spatialcase
  • paul_m
    paul_m
  • vienna
  • timheteren
  • ileung_cnw
    ileung_cnw
  • vhruska
    vhruska
  • divya
  • tim.albert.vaa
    tim.albert.vaa
  • g_karssenberg
    g_karssenberg
  • hrvoje
    hrvoje
  • janrykr
    janrykr
  • phoeffler
    phoeffler
  • davidrasner5
    davidrasner5
  • stijn2_pruissen
  • johnpaulmcgrath
  • syed.ali
  • battlezone77
  • jeroens
  • safonovaa
  • jaredcarse
    jaredcarse
  • chriszeitner1
  • mandersson1991
  • machiel_van
  • larryw
    larryw
  • kasiaf
    kasiaf
  • gautmaricwl
  • kevinwyckoff
    kevinwyckoff
  • chrispowell
  • strebel
  • ailizaliturri
    ailizaliturri
  • cracker09
  • vanessa_t
  • laurawatsafe
    laurawatsafe
  • mdlong
    mdlong
  • boxcase01
    boxcase01
  • zvs876
    zvs876
  • dylan_rayburn
    dylan_rayburn

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! 


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