Slicers in Excel: The Ultimate Guide to Help You Design and Develop Excel Slicers Lesson - 9 Your One-Stop Solution to Learn Mail-Merge in Excel and Its Implementation Lesson - 7Ī Comprehensive Guide on Excel Flash Fill Lesson - 8 Your One-Stop Solution That Will Help You Learn How to Convert PDF to Excel Lesson - 4Ī One-Stop Solution for Acing the Excel MIS Report Lesson - 5Īll You Need to Know About Barcode in Excel Lesson - 6 The Best Guide on How to Send an Email in Excel Lesson - 3 Your One-Stop Solution For Excel UserForms Lesson - 2 Your One-Stop Solution to Know About Excel Worksheets Lesson - 1 OutputFileName = "D:\\pdftest\\DataTableExample_Filled.pdf" // Call the method to import the data from DataTable object into Pdf form fields.ĪutoFiller. InputFileName = "d:\\pdftest\\DataTableExample.pdf" // The resultant pdf, that will contain the form fields filled with information from DataTableĪutoFiller. Close () // Create an object of AutoFiller classĪutoFiller autoFiller = new AutoFiller () // The input pdf file that contains form fieldsĪutoFiller. MaxColumn + 1, true ) // Closing the file stream to free all resourcesįstream. Worksheets // Exporting the contents of 7 rows and 2 columns starting from 1st cell to DataTableĭataTable dataTable = worksheet. Open ( fstream ) // Accessing the first worksheet in the Excel file Open ) // Opening the Excel file through the file stream Workbook workbook = new Workbook () // Creating a file stream containing the Excel file to be openedįileStream fstream = new FileStream ( "d:\\pdftestĮwBook1.xls", FileMode. 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.
0 kommentar(er)
