Populate each data in tax form (excel format with textbox inside)

[PassION_es]

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,

[OTrieger]

@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.

[PassION_es]

Hi @OTrieger

please look at this form: https://bir-cdn.bir.gov.ph/local/pdf/2307%20Jan%202018%20ENCS%20v3.xlsx

[OTrieger]

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

[OTrieger · Accepted solution]

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. 

[PassION_es]

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