Populate each data in tax form (excel format with textbox inside)
- 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
Hi,
I am trying to automate the creation of tax form (excel format) by using BLOB.
Is it possible that data can be auto-populated inside textboxes of excel using BLOB?
Thanks,
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@PassION_es
Are these textboxes reflecting excel cells?
Blob is working on the concept of writing data into specific cell or range, so it need to be defined.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @OTrieger
please look at this form: https://bir-cdn.bir.gov.ph/local/pdf/2307%20Jan%202018%20ENCS%20v3.xlsx
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Alteryx will not be able to write data to the text boxes.
Maybe with Python tool, but not sure about it.
Some of this form can be filled with Alteryx but only the parts that are an actual excel cells, such as Part III – Details of Monthly Income Payments and Taxes Withheld
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
By the way, do you know if this form is also in a PDF format, as if there is a PDF version for this form then with Python tool you will be able to fill in the data.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, i found a pdf on this.
please take a look: https://bir-cdn.bir.gov.ph/local/pdf/2307%20Jan%202018%20ENCS%20v3.pdf
thanks
