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?
Solved
Can FME write to an Excel table?
+6- Contributor
Best answer by fmelizard
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.
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+21- Safer
- Best Answer
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.
- Participant
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.
+6- Contributor
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.
+5- Contributor
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.
+6- Contributor
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.
Hi