|
1. First of all, change the programming language of the Xpertdoc template by clicking the Properties button and changing the Language Property.
|
|
|
|
2. Click on the Data Sources button to prompt the form.
|
|
|
|
3. Click on the Add a new connection button.
|
|
|
|
4. Choose the appropriate type of connection.
|
|
|
|
5. Browse for the Excel file you want to be included in the template, then press the Test Connection Button to be sure that everything is working fine.
|
|
|
|
6. Click on the Add a new command Button.
|
|
|
|
7. In the Xpertdoc Command form, you can choose the desired sheet and columns you want in your template.
|
|
|
|
8. Next, click on the Generate Query button and you should get a query with the table and columns you chose.
|
|
|
|
9. Click twice on OK and then close the Data Sources Form. Create a table with 2 rows and 4 colums. Put your cursor in the top right cell and click on the Insert Statement Button.
|
|
|
|
10. Right click on the command line in the tree view on the left and choose Insert Start Loop.
|
|
|
|
11. Add titles to the first row of the table and put your cursor on the second row. Click on the Insert Expression Button.
|
|
|
|
12. Right click on the column you want to add in the tree view and choose Insert Column(Inside Loop). Repeat this step for each columns.
|
|
|
|
13. Put your cursor in the last cell. Click the Insert Statement Button and right-click on the command line in the tree view. Choose Insert End Loop.
|
|
|
14. Your table should look like the one below. You can change the style of the table if you want.
|
|
|
15. Click on the Preview Button to see the result.
|
|
|
16. The resulting table with the datas coming from the Excel should look like this one.
|