I have got some beautiful Excel templates containing tables (not normal ranges). It's quite easy to write to a named range within Excel but I haven't figured out how to write to a Table. Does anyone know how to do so?
Hi @michielschram, depending on the complexity and number of tables you have, this can be done in FME. I have only tested with one table in my sheet, but FME is able to append additional records. I've used the "Import from Dataset" option when adding my Writer to import the data model from the sheet.
If you have a sample of the tables you're working with, I'd be more than happy to investigate further for you. I imagine your tables will be more complex than my test.
FYI, we hosted a webinar this week " Tips for Automating Excel Data Processing Tasks with FME ". It doesn't answer your question specifically but there are some great nuggets of information and you can download the workspaces used in the demo.
FYI, we hosted a webinar this week " Tips for Automating Excel Data Processing Tasks with FME ". It doesn't answer your question specifically but there are some great nuggets of information and you can download the workspaces used in the demo.
Is there any more detail on how writing to an excel table can be accomplished?
I’ve been attempting to do so but it seems that FME creates a range in place of the table object and writes to it, not the table itself. It also seems to cause the file to become corrupted when doing so. Hope someone else can shed some light on this.
Thx.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.