Excel file populates dynamic fields in document template, irrespective of field sequence. Take the example of below Sample document that has both text and table.


 Personal Details

{Enter_Name}

{Enter_SSN}

{Enter_Telephone}


Role

Company

Address

{#Job} {Role}

{Company}

{Address} {/Job}




One-to-one Merge: EDocGen creates one document for each row/column (EDocGen supports both vertical and horizontal merges). The excel data populates text fields as well as table data.  The format of Excel data would look like this. Notice the nested table format for populating word table.


Enter_Name
 Enter_SSN
 Enter_Telephone
 Job
David
 Number1
 9086543215
 Role:Engineer,Company:Cisco,Address:SanJose;
Anne
 Number2
 6785435635
 Role:VP Sales ,Company:Redstar,Address:London


Notice the colored fields. The excel should have the corresponding dynamic field  tag name in the first row (first column in case of vertical merge) of the excel. Please use the attached excel file for populating sample document.


  • Choose Excel file population option (2nd)  after clicking "Create Document" action button on Sample Document
  • Choose Excel sheet name from drop-down
  • Click Generate