JSON to doc fill

Excel to doc -Convert Excel to PDF and Word Docs

Excel to doc Samples

EDocGen is the best solution for population of Excel to PDF and Word templates. The sample template has dynamic text, tables, and hyperlinks. In case you're unable to view the below sample word template and Excel file because of your browser's security settings, you can download them from here.

Sample-Template

Sample-Excel



In Excel to doc population, EDocGen asks you to select the sheet from which you want to populate data and the orientation of data. EDocGen supports both vertically and horizontally aligned Excel data.

In the Excel file, notice matching headers with dynamic tag names of the template. For example, "Enter_Name" is present in both Excel and template. Though you can upload any Excel with any header names, having matching headers allows you to skip the mapping screen (2nd step of the population). Thus this saves time if you're planning to populate the same Excel file format again-and-again into your template.

For "linkname" dynamic field, there is no corresponding data in Excel. In such cases, the generated documents display just blank in the place of dynamic field.


Description


The template has text, table and hyperlink dynamic fields

Text : {Enter_Name} and {Enter_Email} are dynamic text fields. EDocGen treats text placed in "{}" as dynamic text field.

Table : The Job table has Role, Company and Address columns. Table starts with {#tablename} and ends with {/tablename}. So you notice {#Job} in the first column and {/Job} in the last column. Column values are text fields. EDocGen loops over the JSON to populate a row into the Job table.

Hyperlink : The dynamic data passed to hyperlink tag would be displayed as a link in blue color. You can use it display a URL or text that links to another URL. EDocGen treats text placed in "{~}" as hyperlink. In the template {~linkname}{~Enter_Name} are dynamic hyperlinks.

Show text based on Conditions (If-Else): If the Enter_Name value is "Steve", we are showing some text. Similarly, you can also test for boolean for hiding/displaying data.


Excel to Doc - PDF and Word templates


You can use both PDF and Word templates with EDocGen. Edit them in your favorite editors to add tags and upload into EDocGen. While you can also modify your templates inside the App as well, it is suited more for minor changes.

XML to Word

With EDocGen, you can populate Excel data into

  1. Word templates to create Word documents
  2. Word templates to create PDF documents
  3. PDF templates to create Word documents
  4. PDF templates to create PDF documents







Trouble Shooting

  • Unable to upload template

    It may be due to wrong dynamic tags. Just make sure you're closing every tag properly and only uses the tags that are supported by EDocGen