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: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback


Trusted by the world’s leading companies

Syncfusion Trusted Companies

Overview

Template Marker is another 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 invoice 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.


Features

Fast and Reliable

With Template Markers, you can generate complex and reliable reports in a batch process faster than Office automation libraries.

Platform-Independent

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.

Create or Design Template

Syncfusion Essential Excel (XlsIO) library helps create Excel template documents with marker variables. Marker variables can also be added to an Excel template using Microsoft Excel.

Multiple File Formats

Save the data-imported document in multiple file formats like an Excel document, HTML, CSV, TSV, ODS, and PDF.

Import Data into a Template

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.

Data Sources

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.

Copy Formulas

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.

Copy Styles

Import data and preserve the cell styles and font styles of marker variable cells in the newly inserted rows.

Import Images

Import images like JPEG, PNG, BMP, TIFF, and GIF. Also, images can be in imported to a desired position and with specified size, or to a cell width and height.

Apply Conditional Formats

Apply conditional formats to the template marker range with data bars, color scales, and icon sets.

Orientation

Marker variables in a template document followed by arguments control the orientation of data imports. This helps you import data vertically and horizontally.



PRICING

File Formats
Developer Platform
Unlimited Global License

Developer Platform

Essential Studio

$ 2,495

/developer 1st year

Includes 1000+ Controls
Best Value

Unlimited Global License

Cover everyone in your organization for one low annual fee

CONTACT US

File Formats

$ 995

/developer 1st year

DEVELOPER PLATFORM
  • 60+ Controls each for JavaScript, Angular, Blazor, React, and Vue.
  • 75+ ASP.NET Web Forms Controls
  • 65+ ASP.NET MVC Controls
  • 65+ ASP.NET Core Controls
  • File Formats (Word, Excel, PowerPoint and PDF) Tool tip information icon
  • 135+ Xamarin Controls *Includes iOS, Android and UWP
  • 100+ WinForms Controls
  • 90+ WPF Controls
  • 70+ UWP Controls
  • 55+ PHP Controls
  • 55+ JSP Controls
  • Predictive Analytics
SUPPORT
  • Dedicated Account Representative
  • Quarterly product releases
  • Support within 24 hours on all business days
LICENSING
  • Licensing Management Portal
  • Commercial Use
  • Max Developer count
  • 1 per license
  • Coverage Period
  • 1 year
File Formats
Developer Platform
Unlimited Global License

RESOURCES

CASE STUDY

Syncfusion’s file format components helped me create the reports I needed, fast. – J. Pereira, Software Developer.

The libraries have been built from scratch and refined for more than a decade to provide blazing-fast performance, comprehensive API, and compatibility across the latest and older versions of these files.

CONTINUE READING View all Customer Stories

VIDEOS

Syncfusion File Format Libraries - Manipulate Excel, Word, PowerPoint, and PDF files

Read and write Excel, Word, PDF, and PowerPoint files. Also includes integrated visualization capabilities. Advanced features include support for pivot tables, pivot charts, mail-merge, and extensive formatting.

E-BOOK

Succinctly Series: Statistics Using Excel Succinctly

Succinctly Series: Statistics Using Excel Succinctly


- by Charles Zaiontz
CONTINUE READING View all E-books

Awards

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.

Syncfusion Awards
Scroll up icon

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