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?
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.
1 person upvoted this
+17- Contributor
- 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.
1 person upvoted this
- 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.
1 person upvoted this
craigvernon wrote:
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.
1 person upvoted this
+4- 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.
+5- Contributor
fmelizard wrote:
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
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.