Template markers are a variant of the template-based approach to importing data, the difference being that the end-user places special markers or placeholders in the template spreadsheet that get replaced along with the data during runtime. This performs similarly to the mail merge feature in Word documents. Syncfusion Excel (XlsIO) Library allows you to generate various real-world reports like invoices and payroll from formatted Excel templates using template markers. This process is faster, and the generated document can be saved as an Excel document, PDF, HTML, and more.
With template markers, you can generate complex and reliable reports in a batch process faster than Office automation libraries.
This non-UI component allows you to code once to import data using template markers and reuse the code in all .NET Framework, .NET Core, and Xamarin platforms.
Excel Library (XlsIO) helps create Excel template documents with marker variables. Marker variables can also be added to an Excel template using Microsoft Excel.
Save the imported-data document in multiple file formats like as an Excel document, HTML, CSV, TSV, ODS, and PDF.
Open the Excel template document and replace the marker variables with data from various data sources with a few lines of code. While importing, new rows or columns are added without affecting other data existing in the template document.
Import data from a single or multiple data tables, single dimensional arrays, and collection objects that include images. Also, import hierarchical data from multiple tables.
Excel formulas that are added in a template document to calculate certain values of a row will be copied to the newly imported or inserted rows to display relative calculated values.
Import data and preserve the cell styles and font styles of marker variable cells in the newly inserted rows.
Import images in formats like JPEG, PNG, BMP, TIFF, and GIF. Images can be imported to a desired position and with a specified size or fitted to a cell’s width and height.
Apply conditional formats to a template marker range with data bars, color scales, and icon sets.
Marker variables in a template document followed by arguments control the orientation of data imports. This helps you import data vertically and horizontally.
Greatness—it’s one thing to say you have it, but it means more when others recognize it. Syncfusion is proud to hold the following industry awards.