Populating an invoice with excel data
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
I am trying to take data from excel and input it into specific areas of an invoice. Attached are two documents, one being an invoice and the other an axcel file containing all the information necessary to fill out the invoice. Each column in the excel file will be linked specifically to a location on the invoice.
Any help with this would be amazing!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Check out the Reporting tools to recreate the invoice template or approximate it.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @gdorwart,
Sadly Alteryx can't input Word Documents. There are two possible workarounds
1. Use Python/R to input the data (see: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Getting-alteryx-to-read-in-from-a-word...
2. Transform it to an .txt. and then read it in
In both ways you will need to re-do the structure of the original document using Reporting Tools.
I have created a sample workflow - with a very bad looking output - that does the main part and then very basic reporting logic. You would need to apply a lot more Reporting Tools to make it look like the original document.
