We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

How to use copyrange argument in template markers using XlsIO?

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

 

What is copyrange argument?

 

The argument copyrange specified in template marker copies the specified cells after each cell import. Cell reference addresses can be relative or absolute.

 

For example, when a known data is needed to be copied in every row or column for each data imported, the copy range argument will be helpful to do that operation.

 

Syntax

 

%<MarkerVariable>.<Property>;copyrange:R[Index]C[Index]

 

NOTE: The copy range will begin from next row of the R[index].

 

Steps to use copyrange 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 cells “D4” and “E4” contains the known data which needs to be copied for every Employee object.

 

 

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

 

                  

 

  1. Create template marker processor.

 

 

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

 

 

  1. Apply markers.

 

 

Download Complete Sample

 

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

 

 

 

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

 

Article ID: Published Date: Last Revised Date: Platform: Control:
8456 02/20/2018 02/20/2018 Windows Forms XlsIO
Did you find this information helpful?
Add Comment
You must log in to leave a comment

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.