The Syncfusion® Xamarin Excel (XlsIO) library is a feature-rich and high-performance .NET Excel library that is used to create, read, and edit Excel documents programmatically without Microsoft Office dependencies.
You can fetch the Syncfusion® Xamarin Excel library NuGet by simply running the command Install-Package Syncfusion.Xamarin.XlsIO from the Package Manager Console in Visual Studio.
Try the following code snippet to create a simple Excel document.
using Syncfusion.XlsIo;
using System.IO;
//Initialize ExcelEngine.
using (ExcelEngine excelEngine = new ExcelEngine())
{
//Initialize IApplication.
IApplication application = excelEngine.Excel;
//Set the default version as Xlsx.
application.DefaultVersion = ExcelVersion.Xlsx;
//Create a new workbook with one worksheet.
IWorkbook workbook = application.Workbooks.Create(1);
//Get the worksheet into IWorksheet.
IWorksheet worksheet = workbook.Worksheets[0];
//Set a value to Excel cell.
worksheet.Range["A1"].Value = "Hello World";
//Save the Excel document.
MemoryStream stream = new MemoryStream();
workbook.SaveAs(stream);
stream.Position = 0;
Xamarin.Forms.DependencyService.Get<ISave>().SaveAndView("Output.xlsx", "application/msexcel", stream);
}
This is a commercial product and requires a paid license for possession or use. Syncfusion® licensed software, including this component, is subject to the terms and conditions of Syncfusion® EULA. You can purchase a license here or start a free 30-day trial here.
About Syncfusion®
Founded in 2001 and headquartered in Research Triangle Park, N.C., Syncfusion® has more than 29,000 customers and more than 1 million users, including large financial institutions, Fortune 500 companies, and global IT consultancies.
