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.
Xamarin Excel Framework provides support for creating, reading, editing, and protecting Excel documents in Xamarin applications without Microsoft Office or interop dependencies. This framework also converts Excel documents to PDF, HTML, ODS, and image formats.
There are no distribution fees, per-server licensing fees, or royalties, which makes Excel Library very cost-effective.
It is optimized for usage in a server environment where speed and low memory usage are critical.
All the elements in a typical Excel document such as text, formatting, images, shapes, and tables are accessible through a comprehensive set of APIs.
Over more than 15 years, Syncfusion’s Excel Library (Essential XlsIO) has become a mature and proven product.
The Syncfusion’s Excel Library comes with extensive documentation, knowledge base, and samples.
Use a single API across all platforms.
Syncfusion Excel Library is a high-performance Xamarin Excel library that allows users to create, read, edit, and protect Excel documents in Xamarin applications without Microsoft Office or interop dependencies.
Import data from various data sources and collection objects. Also, export data to data tables, collection objects, and nested classes.
Excel Library supports 80+ charts to visualize data. Similarly, sparklines are supported to visualize data within a cell.
More than 400 Excel functions are supported to quickly evaluate formula cells. Add-in functions, external formulas, and an array of formulas are supported.
Import data to Excel worksheets like mail merge in a Word document. Customized data importing is also supported.
Use for various cell and text formatting options along with advanced conditional formatting features to modify the appearance of the data.
Perform various kinds of data processing such as data validation, sorting, and filtering.
Pivot tables and pivot charts are widely used due to their ease of use in summarizing data. Syncfusion’s Excel Library allows you to create and edit them with a few lines of code.
Encrypt or decrypt password-protected Excel files. Also, protect the editing of workbooks, worksheets, and cells.
Create and edit various form controls, autoshapes, and comments.
For more information, check out Xamarin Excel Library features.
Convert an Excel workbook or worksheet to PDF format. Use various customization options, like embedding fonts, ignoring empty pages or worksheets, and showing or hiding headers and footers.
Worksheets can be converted to BMP, JPEG, PNG, and other image formats, with content such as data, formatting, charts, tables, and shapes.
Convert spreadsheet data to CSV and TSV formats to generate, lightweight reports.
Dynamically render an Excel workbook or worksheet as an HTML file.
Save Excel files in ODS formats to use in applications like OpenOffice and Google Sheets.
SpreadsheetML is easy to work with and designed to be human readable and editable. Convert Excel files to SpreadsheetML using Syncfusion Excel Library.
Convert an Excel workbook or worksheet to JSON file in schema and non-schema formats.
Easily get started with the Xamarin Excel Library using a few simple lines of C# code example as demonstrated below. Also explore our Xamarin Excel Library Example that shows you how to render and configure the Xamarin Excel.
void btnCreate_Click(object sender, System.EventArgs e)
{
ExcelEngine excelEngine = new ExcelEngine();
IApplication application = excelEngine.Excel;
application.DefaultVersion = ExcelVersion.Excel2013;
string resourcePath = "SampleBrowser.Samples.XlsIO.Template.Sample.xlsx";
//"App" is the class of Portable project.
Assembly assembly = typeof(App).GetTypeInfo().Assembly;
Stream fileStream = assembly.GetManifestResourceStream(resourcePath);
//Opens the workbook
IWorkbook workbook = application.Workbooks.Open(fileStream);
//Access first worksheet from the workbook.
IWorksheet worksheet = workbook.Worksheets[0];
//Set Text in cell A3.
worksheet.Range["A3"].Text ="Hello World";
MemoryStream stream = new MemoryStream();
workbook.SaveAs(stream);
workbook.Close();
excelEngine.Dispose();
//Save the stream into XLSX file
Xamarin.Forms.DependencyService.Get<ISave>().SaveAndView("sample.xlsx","application/msexcel", stream);
}The Syncfusion Xamarin Excel Framework provides the following features:
No, this is a commercial product and requires a paid license. However, a free community license is also available for companies and individuals whose organizations have less than $1 million USD in annual gross revenue and five or fewer developers.
A good place to start would be our comprehensive getting started documentation.
Apart from Xamarin, the Syncfusion Excel framework supports platforms for web (Blazor, Flutter, ASP.NET Core, ASP.NET MVC, and ASP.NET Web Forms), mobile (.NET MAUI, Flutter, and UWP), and desktop (Windows Forms, WPF, WinUI, .NET MAUI, Flutter, and UWP).
You can find our Excel Framework demo here.
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.
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
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.
