How to use jump argument in template markers using XlsIO?

This article explains how to use jump argument in template markers using XlsIO.

What is jump argument?

The argument jump specified in template marker binds the data to the cell at the specified reference. Cell reference addresses can be relative or absolute.

When using relative address, the data will be imported for every row. But, when using absolute address, the data will be imported only for that row. We can use combination of relative and absolute addressing for both row and column.

For example, when we want to import each data after certain number of rows or columns in the worksheet, we can use jump argument.

Syntax

Steps to use jump argument

1. Create a workbook template with markers in it. Here, Employee is the marker variable referred to a class object, followed by its properties separated by dot (.).

The below screenshot shows how the markers are applied in workbook template.

2. Create template marker processor.

3. Add a variable name that is equal to the class object specified in step 1.

4. Apply markers.

Download Complete Sample

The following C#/VB.NET complete code snippet shows how to use template marker with jump argument in XlsIO.

The below screenshot shows the output document generated using template markers with jump argument.