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. (Last updated on: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Excel template / ITemplateMarkersProcessor

Thread ID:





60615 May 9,2007 09:40 AM UTC May 17,2007 10:22 AM UTC ASP.NET Web Forms (Classic) 5
Tags: XlsIO
Cyril Hochet
Asked On May 9, 2007 09:40 AM UTC

Hi everyone,

I am looking for additional information about ITemplateMarkersProcessor / template markers features.

I would like to obtain a kind of xls "mailmerge" (as it exists for Word / DOCIO).

Is there a list of all tags available for markers ? (I already found insert:copystyles, horizontal, copyrange in the Template Markers example (evaluation center))

Thanks in advance.

Melba Winshia [Syncfusion]
Replied On May 9, 2007 01:13 PM UTC

Hi Cyril, The basic idea is that the template will have markers like %Customers.ContactName inside cells and when we provide the data source (customers DataTable) , the contents of ContactName column will get inserted into the template document. For example, the end user of an application can format a template like he wants and then put the markers inside as specified and then have the data from the DataTable exported with the desired look. There could be several arguments after variable they are delimited by some character (by default it is ; character) Possible arguments: -------------------- 1) horizontal or vertical - specifies direction of the data import for complex variables (arrays, collections, data tables, etc.), vertical is default value. 2) insert - specifies that new row or column (depends on direction argument) for each new cell. 3) insert:copystyles - the same but also copies style from the above row or left column 4) jump: - specifies position of the next cell. This argument also can be appended by ":copystyles" then style of the single cell will be copied. 5) copyrange:: - copies specified cells after each cell import. Aslo can be appended by ":copystyles". There can be more than one copyrange argument for single template marker. Kindly let me know if you have any other questions. Thanks, Melba

Cyril Hochet
Replied On May 14, 2007 08:07 AM UTC

Thanks for the answer.

Is there a way to copy also formula and / or conditionnal formatting ?

(copystyle does not seem to copy conditionnal formatting)


Melba Winshia [Syncfusion]
Replied On May 16, 2007 12:09 PM UTC

Hi Cyril,

Issue 1: (copy also formula)

It is possible to copy formula using template markers. Here is the sample for your reference:


Issue 2: (copy conditional formatting)

Currently it is only possible to copy styles using copystyle. But it is not possible to copy conditional formatting. Sorry for the inconvenience caused.

Kindly let me know if you have any other questions.


Cyril Hochet
Replied On May 16, 2007 12:22 PM UTC

thanks for the answer.


Melba Winshia [Syncfusion]
Replied On May 17, 2007 10:22 AM UTC

Hi Cho,

Thanks for the update.

Kindly let me know if you have any other questions.



This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon 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.Close Icon

Live Chat Icon For mobile
Live Chat Icon