The DataTable class offers the capability to use the first row of the sheet as ColumnName. Input Pdf form was single page and resultant is five pages, because the number of data rows in excel sheet is 5.

Once the method is called a new Pdf form file is generated, which contains five pages with form filled based over the data from Excel sheet. We need to create an object of AutoFiller class and bind the Pdf form present in the above pictures and use the ImportDataTable method to fill the form fields using the data present in DataTable object. We would be extracting the data from the following excel sheet into DataTable object. In the Form specified above has one page, with three fields named as “ID”, “Name” and “Gender” consequently. In the following scenario we are going to using a PDF form, which contains three form fields named ID, Name and Gender. Make sure that, the Column name of DataTable is same as field name over PDF form. Then we need would be importing this data into Pdf form using ImportDataTable method of AutoFiller class. We would be using ExportDataTable method of Cells class of Aspose.Cells to export the data from Excel sheet in to DataTable object. You can import data from XML file, DFD, XFDF, use API and even can use the data from Excel worksheet. NET offers various ways to fill the Pdf forms. Also, feel free to contact us. namespace in Aspose.PDF for. It is also possible to extract data from PDF form to Excel using our API. You can also convert your PDF form to HTML, Once the download is complete, you've successfully converted your PDF form data to Excel. Once the conversion has completed, click the arrow next to the Download as Excel button and select Excel (single sheet) orĮxcel (multiple sheets). Step 2įind the PDF in your file finder and click Open. Go to and click the Convert a PDF button to begin converting your PDF form to Excel.

How to convert multiple PDFs to Excel using our API.

If you would like to convert multiple PDF forms at once, see our tutorial on

I will be converting a sample PDF form to Excel, which has been filled in and commented on using a PDF reader. Need to extract data from PDF form fields? Do it with PDFTables! We've recently made some changes which means that now you can export form data from PDF to Excel.Īny comments added to the PDF in your PDF reader will also be extracted.

Import pdf form into excel