Template marker and mailmerge

Hello,

I'm using the Template Markers features in an Excel file. It's working as the documentation is written but I wanted to know if it was possible to go a bit further and use a mailmerge like functionality in this type of document.

Here is an example :

https://imgur.com/a/Bnk6EhN

On the left is the template, on the right is the result of the processing done in .NET CORE. As you can see in the third line the markers are not replaced because there is some text in the cell.

- Is there a way to work around that and keep some text in a cell ?

- Is it possible to "hide" this marker and only display a label and use a hidden code when processing the template ? 

Thanks,
Tuan

1 Reply

KK Konduru Keerthi Konduru Ravichandra Raju Syncfusion Team December 22, 2020 02:14 PM UTC

Hi Tuan, 

Greetings from Syncfusion. 

Please find the response for your queries below. 

Query 
Response 
Is there a way to work around that and keep some text in a cell ? 
 
 
 
 
 
 

Syncfusion XlsIO do not have support to apply template marker to the cell, if it has both text and marker in it. You can add the text after the template marker is processed.  

The following code snippet explains how to add text to the existing text in the cell. 

Code Snippet: 

worksheet.Range["E5"].Value = worksheet.Range["E5"].Value + "Test"; 
 
Is it possible to "hide" this marker and only display a label and use a hidden code when processing the template ?  
It is not possible to hide the marker and process the template. Marker is necessary to process the template. 

Regards, 
Keerthi. 


Loader.
Up arrow icon