Create, read, and edit Excel files in Xamarin

22 Dec 202224 minutes to read

Syncfusion Excel library for Xamarin platform can be used to create, read, edit Excel files. This also convert Excel files to PDF.

Create a simple Excel report

The below steps illustrates creating an simple Invoice formatted Excel document in Xamarin application.

  1. Create a new C# Xamarin.Forms application project.

Create ASP.NET Core web application in Visual Studio

  1. Select a project template and required platforms to deploy the application. In this application the portable assemblies to be shared across multiple platforms, the .NET Standard code sharing strategy has been selected. For more details about code sharing refer here.


If .NET Standard is not available in the code sharing strategy, the Portable Class Library (PCL) can be selected.

Select Web application pattern

  1. Install the Syncfusion.Xamarin.XlsIO NuGet package as reference to your .NET Standard applications from

Add XlsIO reference to the project

  1. Add new Forms XAML page in portable project If there is no XAML page is defined in the App class. Otherwise proceed to the next step.

    i) To add the new XAML page, right click on the project and select Add > New Item and add a Forms XAML Page from the list. Name it as MainXamlPage.

    ii) In App class of portable project (App.cs), replace the existing constructor of App class with the code snippet given below which invokes the MainXamlPage.

    <div class="tabs">
    <ul class="nav nav-tabs" role="tablist">
    <li role="presentation" class=""><a data-target="#u9oljinmbh2l02iy3yy0mjm88xwvmrfe-csharp" aria-controls="home" role="tab" data-toggle="tab" data-original-lang="csharp">C#</a></li>
    <li role="presentation" class=""><a data-target="#5vmrlyc3qw5fkmmqsuuu7xnz1a6tksz1-vbnet" aria-controls="home" role="tab" data-toggle="tab" data-original-lang="vb">VB.NET</a></li>
    <div class="tab-content">
    <div role="tabpanel" class="tab-pane" id="u9oljinmbh2l02iy3yy0mjm88xwvmrfe-csharp" data-original-lang = "csharp" ><div class="highlight"><pre><code class="language-csharp" data-lang="csharp"><span></span><span class="k">public</span> <span class="nf">App</span><span class="p">()</span>
    <span class="p">{</span>
      <span class="c1">// The root page of your application</span>
      <span class="n">MainPage</span> <span class="p">=</span> <span class="k">new</span> <span class="n">MainXamlPage</span><span class="p">();</span>
    <span class="p">}</span></code></pre></div>
    <div role="tabpanel" class="tab-pane" id="5vmrlyc3qw5fkmmqsuuu7xnz1a6tksz1-vbnet" data-original-lang = "vb" ><div class="highlight"><pre><code class="language-vbnet" data-lang="vbnet"><span></span><span class="k">Public</span> <span class="k">Sub</span> <span class="nf">New</span><span class="p">()</span>
      <span class="c">&#39;The root page of your application</span>
      <span class="n">MainPage</span> <span class="o">=</span> <span class="k">New</span> <span class="n">MainXamlPage</span><span class="p">()</span>
    <span class="k">End</span> <span class="k">Sub</span></code></pre></div>
  2. In the MainXamlPage.xaml add new button as shown below.

    <ContentPage xmlns=""
                 x:Class="GettingStarted. MainXamlPage">
    <StackLayout VerticalOptions="Center">
    <Button Text="Generate Document" Clicked="OnButtonClicked" HorizontalOptions="Center"/>
    </StackLayout> </ContentPage>
  3. Include the following namespace in the MainXamlPage.xaml.cs file.

    using Syncfusion.XlsIO;
    using System.Reflection;
    using Color = Syncfusion.Drawing.Color;
    Imports Syncfusion.XlsIO
    Imports System.Reflection
    Imports Color = Syncfusion.Drawing.Color
  4. Include the below code snippet in the click event of the button in MainXamlPage.xaml.cs, to create an Excel file and save it in a stream.

    void OnButtonClicked(object sender, EventArgs args)
      //Create an instance of ExcelEngine.
      using (ExcelEngine excelEngine = new ExcelEngine())
      	IApplication application = excelEngine.Excel;
      	application.DefaultVersion = ExcelVersion.Xlsx;
      	//Create a workbook with a worksheet
      	IWorkbook workbook = excelEngine.Excel.Workbooks.Create(1);
      	//Access first worksheet from the workbook instance.
      	IWorksheet worksheet = workbook.Worksheets[0];
      	Assembly executingAssembly = typeof(MainPage).GetTypeInfo().Assembly;
      	Stream inputStream = executingAssembly.GetManifestResourceStream("GettingStarted.AdventureCycles-Logo.png");
      	//Add a picture
      	IPictureShape shape = worksheet.Pictures.AddPicture(1, 1, inputStream, 20, 20);
      	//Disable gridlines in the worksheet
      	worksheet.IsGridLinesVisible = false;
      	//Enter values to the cells from A3 to A5
      	worksheet.Range["A3"].Text = "46036 Michigan Ave";
      	worksheet.Range["A4"].Text = "Canton, USA";
      	worksheet.Range["A5"].Text = "Phone: +1 231-231-2310";
      	//Make the text bold
      	worksheet.Range["A3:A5"].CellStyle.Font.Bold = true;
      	//Merge cells
      	//Enter text to the cell D1 and apply formatting.
      	worksheet.Range["D1"].Text = "INVOICE";
      	worksheet.Range["D1"].CellStyle.Font.Bold = true;
      	worksheet.Range["D1"].CellStyle.Font.RGBColor = Color.FromArgb(42, 118, 189);
      	worksheet.Range["D1"].CellStyle.Font.Size = 35;
      	//Apply alignment in the cell D1
      	worksheet.Range["D1"].CellStyle.HorizontalAlignment = ExcelHAlign.HAlignRight;
      	worksheet.Range["D1"].CellStyle.VerticalAlignment = ExcelVAlign.VAlignTop;
      	//Enter values to the cells from D5 to E8
      	worksheet.Range["D5"].Text = "INVOICE#";
      	worksheet.Range["E5"].Text = "DATE";
      	worksheet.Range["D6"].Number = 1028;
      	worksheet.Range["E6"].Value = "12/31/2018";
      	worksheet.Range["D7"].Text = "CUSTOMER ID";
      	worksheet.Range["E7"].Text = "TERMS";
      	worksheet.Range["D8"].Number = 564;
      	worksheet.Range["E8"].Text = "Due Upon Receipt";
      	//Apply RGB backcolor to the cells from D5 to E8
      	worksheet.Range["D5:E5"].CellStyle.Color = Color.FromArgb(42, 118, 189);
      	worksheet.Range["D7:E7"].CellStyle.Color = Color.FromArgb(42, 118, 189);
      	//Apply known colors to the text in cells D5 to E8
      	worksheet.Range["D5:E5"].CellStyle.Font.Color = ExcelKnownColors.White;
      	worksheet.Range["D7:E7"].CellStyle.Font.Color = ExcelKnownColors.White;
      	//Make the text as bold from D5 to E8
      	worksheet.Range["D5:E8"].CellStyle.Font.Bold = true;
      	//Apply alignment to the cells from D5 to E8
      	worksheet.Range["D5:E8"].CellStyle.HorizontalAlignment = ExcelHAlign.HAlignCenter;
      	worksheet.Range["D5:E5"].CellStyle.VerticalAlignment = ExcelVAlign.VAlignCenter;
      	worksheet.Range["D7:E7"].CellStyle.VerticalAlignment = ExcelVAlign.VAlignCenter;
      	worksheet.Range["D6:E6"].CellStyle.VerticalAlignment = ExcelVAlign.VAlignTop;
      	//Enter value and applying formatting in the cell A7
      	worksheet.Range["A7"].Text = "  BILL TO";
      	worksheet.Range["A7"].CellStyle.Color = Color.FromArgb(42, 118, 189);
      	worksheet.Range["A7"].CellStyle.Font.Bold = true;
      	worksheet.Range["A7"].CellStyle.Font.Color = ExcelKnownColors.White;
      	//Apply alignment
      	worksheet.Range["A7"].CellStyle.HorizontalAlignment = ExcelHAlign.HAlignLeft;
      	worksheet.Range["A7"].CellStyle.VerticalAlignment = ExcelVAlign.VAlignCenter;
      	//Enter values in the cells A8 to A12
      	worksheet.Range["A8"].Text = "Steyn";
      	worksheet.Range["A9"].Text = "Great Lakes Food Market";
      	worksheet.Range["A10"].Text = "20 Whitehall Rd";
      	worksheet.Range["A11"].Text = "North Muskegon,USA";
      	worksheet.Range["A12"].Text = "+1 231-654-0000";
      	//Create a Hyperlink for e-mail in the cell A13
      	IHyperLink hyperlink = worksheet.HyperLinks.Add(worksheet.Range["A13"]);
      	hyperlink.Type = ExcelHyperLinkType.Url;
      	hyperlink.Address = "";
      	hyperlink.ScreenTip = "Send Mail";
      	//Enter details of products and prices
      	worksheet.Range["A15"].Text = "  DESCRIPTION";
      	worksheet.Range["C15"].Text = "QTY";
      	worksheet.Range["D15"].Text = "UNIT PRICE";
      	worksheet.Range["E15"].Text = "AMOUNT";
      	worksheet.Range["A16"].Text = "Cabrales Cheese";
      	worksheet.Range["A17"].Text = "Chocos";
      	worksheet.Range["A18"].Text = "Pasta";
      	worksheet.Range["A19"].Text = "Cereals";
      	worksheet.Range["A20"].Text = "Ice Cream";
      	worksheet.Range["C16"].Number = 3;
      	worksheet.Range["C17"].Number = 2;
      	worksheet.Range["C18"].Number = 1;
      	worksheet.Range["C19"].Number = 4;
      	worksheet.Range["C20"].Number = 3;
      	worksheet.Range["D16"].Number = 21;
      	worksheet.Range["D17"].Number = 54;
      	worksheet.Range["D18"].Number = 10;
      	worksheet.Range["D19"].Number = 20;
      	worksheet.Range["D20"].Number = 30;
      	worksheet.Range["D23"].Text = "Total";
      	//Apply number format
      	worksheet.Range["D16:E22"].NumberFormat = "$.00";
      	worksheet.Range["E23"].NumberFormat = "$.00";
      	//Merge column A and B from row 15 to 22
      	//Apply incremental formula for column Amount by multiplying Qty and UnitPrice
      	application.EnableIncrementalFormula = true;
      	worksheet.Range["E16:E20"].Formula = "=C16*D16";
      	//Formula for Sum the total
      	worksheet.Range["E23"].Formula = "=SUM(E16:E22)";
      	//Apply borders
      	worksheet.Range["A16:E22"].CellStyle.Borders[ExcelBordersIndex.EdgeTop].LineStyle = ExcelLineStyle.Thin;
      	worksheet.Range["A16:E22"].CellStyle.Borders[ExcelBordersIndex.EdgeBottom].LineStyle = ExcelLineStyle.Thin;
      	worksheet.Range["A16:E22"].CellStyle.Borders[ExcelBordersIndex.EdgeTop].Color = ExcelKnownColors.Grey_25_percent;
      	worksheet.Range["A16:E22"].CellStyle.Borders[ExcelBordersIndex.EdgeBottom].Color = ExcelKnownColors.Grey_25_percent;
      	worksheet.Range["A23:E23"].CellStyle.Borders[ExcelBordersIndex.EdgeTop].LineStyle = ExcelLineStyle.Thin;
      	worksheet.Range["A23:E23"].CellStyle.Borders[ExcelBordersIndex.EdgeBottom].LineStyle = ExcelLineStyle.Thin;
      	worksheet.Range["A23:E23"].CellStyle.Borders[ExcelBordersIndex.EdgeTop].Color = ExcelKnownColors.Black;
      	worksheet.Range["A23:E23"].CellStyle.Borders[ExcelBordersIndex.EdgeBottom].Color = ExcelKnownColors.Black;
      	//Apply font setting for cells with product details
      	worksheet.Range["A3:E23"].CellStyle.Font.FontName = "Arial";
      	worksheet.Range["A3:E23"].CellStyle.Font.Size = 10;
      	worksheet.Range["A15:E15"].CellStyle.Font.Color = ExcelKnownColors.White;
      	worksheet.Range["A15:E15"].CellStyle.Font.Bold = true;
      	worksheet.Range["D23:E23"].CellStyle.Font.Bold = true;
      	//Apply cell color
      	worksheet.Range["A15:E15"].CellStyle.Color = Color.FromArgb(42, 118, 189);
      	//Apply alignment to cells with product details
      	worksheet.Range["A15"].CellStyle.HorizontalAlignment = ExcelHAlign.HAlignLeft;
      	worksheet.Range["C15:C22"].CellStyle.HorizontalAlignment = ExcelHAlign.HAlignCenter;
      	worksheet.Range["D15:E15"].CellStyle.HorizontalAlignment = ExcelHAlign.HAlignCenter;
      	//Apply row height and column width to look good
      	worksheet.Range["A1"].ColumnWidth = 36;
      	worksheet.Range["B1"].ColumnWidth = 11;
      	worksheet.Range["C1"].ColumnWidth = 8;
      	worksheet.Range["D1:E1"].ColumnWidth = 18;
      	worksheet.Range["A1"].RowHeight = 47;
      	worksheet.Range["A2"].RowHeight = 15;
      	worksheet.Range["A3:A4"].RowHeight = 15;
      	worksheet.Range["A5"].RowHeight = 18;
      	worksheet.Range["A6"].RowHeight = 29;
      	worksheet.Range["A7"].RowHeight = 18;
      	worksheet.Range["A8"].RowHeight = 15;
      	worksheet.Range["A9:A14"].RowHeight = 15;
      	worksheet.Range["A15:A23"].RowHeight = 18;
      	//Save the workbook to stream in xlsx format. 
      	MemoryStream stream = new MemoryStream();
      	//Save the stream as a file in the device and invoke it for viewing
      	Xamarin.Forms.DependencyService.Get<ISave>().SaveAndView("GettingStared.xlsx", "application/msexcel", stream);
    Private Sub OnButtonClicked(ByVal sender As Object, ByVal args As EventArgs)
    'Create an instance of ExcelEngine
    Using excelEngine As ExcelEngine = New ExcelEngine()
      Dim application As IApplication = excelEngine.Excel
      application.DefaultVersion = ExcelVersion.Xlsx
      'Create a workbook
      Dim workbook As IWorkbook = application.Workbooks.Create(1)
      Dim worksheet As IWorksheet = workbook.Worksheets(0)
      'Adding a picture
      Dim executingAssembly As Assembly = GetType(MainPage).GetTypeInfo().Assembly
      Dim inputStream As Stream = executingAssembly.GetManifestResourceStream("GettingStarted.AdventureCycles-Logo.png")
      Dim shape As IPictureShape = worksheet.Pictures.AddPicture(1, 1, inputStream, 20, 20)
      'Disable gridlines in the worksheet
      worksheet.IsGridLinesVisible = False
      'Enter values to the cells from A3 to A5
      worksheet.Range("A3").Text = "46036 Michigan Ave"
      worksheet.Range("A4").Text = "Canton, USA"
      worksheet.Range("A5").Text = "Phone: +1 231-231-2310"
      'Make the text bold
      worksheet.Range("A3:A5").CellStyle.Font.Bold = True
      'Merge cells
      'Enter text to the cell D1 and apply formatting.
      worksheet.Range("D1").Text = "INVOICE"
      worksheet.Range("D1").CellStyle.Font.Bold = True
      worksheet.Range("D1").CellStyle.Font.RGBColor = Color.FromArgb(42, 118, 189)
      worksheet.Range("D1").CellStyle.Font.Size = 35
      'Apply alignment in the cell D1
      worksheet.Range("D1").CellStyle.HorizontalAlignment = ExcelHAlign.HAlignRight
      worksheet.Range("D1").CellStyle.VerticalAlignment = ExcelVAlign.VAlignTop
      'Enter values to the cells from D5 to E8
      worksheet.Range("D5").Text = "INVOICE#"
      worksheet.Range("E5").Text = "DATE"
      worksheet.Range("D6").Number = 1028
      worksheet.Range("E6").Value = "12/31/2018"
      worksheet.Range("D7").Text = "CUSTOMER ID"
      worksheet.Range("E7").Text = "TERMS"
      worksheet.Range("D8").Number = 564
      worksheet.Range("E8").Text = "Due Upon Receipt"
      'Apply RGB back color to the cells from D5 to E8
      worksheet.Range("D5:E5").CellStyle.Color = Color.FromArgb(42, 118, 189)
      worksheet.Range("D7:E7").CellStyle.Color = Color.FromArgb(42, 118, 189)
      'Apply known colors to the text in cells D5 to E8
      worksheet.Range("D5:E5").CellStyle.Font.Color = ExcelKnownColors.White
      worksheet.Range("D7:E7").CellStyle.Font.Color = ExcelKnownColors.White
      'Make the text as bold from D5 to E8
      worksheet.Range("D5:E8").CellStyle.Font.Bold = True
      'Apply alignment to the cells from D5 to E8
      worksheet.Range("D5:E8").CellStyle.HorizontalAlignment = ExcelHAlign.HAlignCenter
      worksheet.Range("D5:E5").CellStyle.VerticalAlignment = ExcelVAlign.VAlignCenter
      worksheet.Range("D7:E7").CellStyle.VerticalAlignment = ExcelVAlign.VAlignCenter
      worksheet.Range("D6:E6").CellStyle.VerticalAlignment = ExcelVAlign.VAlignTop
      'Enter value and applying formatting in the cell A7
      worksheet.Range("A7").Text = "  BILL TO"
      worksheet.Range("A7").CellStyle.Color = Color.FromArgb(42, 118, 189)
      worksheet.Range("A7").CellStyle.Font.Bold = True
      worksheet.Range("A7").CellStyle.Font.Color = ExcelKnownColors.White
      'Apply alignment
      worksheet.Range("A7").CellStyle.HorizontalAlignment = ExcelHAlign.HAlignLeft
      worksheet.Range("A7").CellStyle.VerticalAlignment = ExcelVAlign.VAlignCenter
      'Enter values in the cells A8 to A12
      worksheet.Range("A8").Text = "Steyn"
      worksheet.Range("A9").Text = "Great Lakes Food Market"
      worksheet.Range("A10").Text = "20 Whitehall Rd"
      worksheet.Range("A11").Text = "North Muskegon,USA"
      worksheet.Range("A12").Text = "+1 231-654-0000"
      'Create a Hyperlink for e-mail in the cell A13
      Dim hyperlink As IHyperLink = worksheet.HyperLinks.Add(worksheet.Range("A13"))
      hyperlink.Type = ExcelHyperLinkType.Url
      hyperlink.Address = ""
      hyperlink.ScreenTip = "Send Mail"
      'Merge column A and B from row 15 to 22
      'Enter details of products and prices
      worksheet.Range("A15").Text = "  DESCRIPTION"
      worksheet.Range("C15").Text = "QTY"
      worksheet.Range("D15").Text = "UNIT PRICE"
      worksheet.Range("E15").Text = "AMOUNT"
      worksheet.Range("A16").Text = "Cabrales Cheese"
      worksheet.Range("A17").Text = "Chocos"
      worksheet.Range("A18").Text = "Pasta"
      worksheet.Range("A19").Text = "Cereals"
      worksheet.Range("A20").Text = "Ice Cream"
      worksheet.Range("C16").Number = 3
      worksheet.Range("C17").Number = 2
      worksheet.Range("C18").Number = 1
      worksheet.Range("C19").Number = 4
      worksheet.Range("C20").Number = 3
      worksheet.Range("D16").Number = 21
      worksheet.Range("D17").Number = 54
      worksheet.Range("D18").Number = 10
      worksheet.Range("D19").Number = 20
      worksheet.Range("D20").Number = 30
      worksheet.Range("D23").Text = "Total"
      'Apply number format
      worksheet.Range("D16:E22").NumberFormat = "$.00"
      worksheet.Range("E23").NumberFormat = "$.00"
      'Apply incremental formula for column Amount by multiplying Qty and UnitPrice
      application.EnableIncrementalFormula = True
      worksheet.Range("E16:E20").Formula = "=C16*D16"
      'Formula for Sum the total
      worksheet.Range("E23").Formula = "=SUM(E16:E22)"
      'Apply borders
      worksheet.Range("A16:E22").CellStyle.Borders(ExcelBordersIndex.EdgeTop).LineStyle = ExcelLineStyle.Thin
      worksheet.Range("A16:E22").CellStyle.Borders(ExcelBordersIndex.EdgeBottom).LineStyle = ExcelLineStyle.Thin
      worksheet.Range("A16:E22").CellStyle.Borders(ExcelBordersIndex.EdgeTop).Color = ExcelKnownColors.Grey_25_percent
      worksheet.Range("A16:E22").CellStyle.Borders(ExcelBordersIndex.EdgeBottom).Color = ExcelKnownColors.Grey_25_percent
      worksheet.Range("A23:E23").CellStyle.Borders(ExcelBordersIndex.EdgeTop).LineStyle = ExcelLineStyle.Thin
      worksheet.Range("A23:E23").CellStyle.Borders(ExcelBordersIndex.EdgeBottom).LineStyle = ExcelLineStyle.Thin
      worksheet.Range("A23:E23").CellStyle.Borders(ExcelBordersIndex.EdgeTop).Color = ExcelKnownColors.Black
      worksheet.Range("A23:E23").CellStyle.Borders(ExcelBordersIndex.EdgeBottom).Color = ExcelKnownColors.Black
      'Apply font setting for cells with product details
      worksheet.Range("A3:E23").CellStyle.Font.FontName = "Arial"
      worksheet.Range("A3:E23").CellStyle.Font.Size = 10
      worksheet.Range("A15:E15").CellStyle.Font.Color = ExcelKnownColors.White
      worksheet.Range("A15:E15").CellStyle.Font.Bold = True
      worksheet.Range("D23:E23").CellStyle.Font.Bold = True
      'Apply cell color
      worksheet.Range("A15:E15").CellStyle.Color = Color.FromArgb(42, 118, 189)
      'Apply alignment to cells with product details
      worksheet.Range("A15").CellStyle.HorizontalAlignment = ExcelHAlign.HAlignLeft
      worksheet.Range("C15:C22").CellStyle.HorizontalAlignment = ExcelHAlign.HAlignCenter
      worksheet.Range("D15:E15").CellStyle.HorizontalAlignment = ExcelHAlign.HAlignCenter
      'Apply row height and column width to look good
      worksheet.Range("A1").ColumnWidth = 36
      worksheet.Range("B1").ColumnWidth = 11
      worksheet.Range("C1").ColumnWidth = 8
      worksheet.Range("D1:E1").ColumnWidth = 18
      worksheet.Range("A1").RowHeight = 47
      worksheet.Range("A2").RowHeight = 15
      worksheet.Range("A3:A4").RowHeight = 15
      worksheet.Range("A5").RowHeight = 18
      worksheet.Range("A6").RowHeight = 29
      worksheet.Range("A7").RowHeight = 18
      worksheet.Range("A8").RowHeight = 15
      worksheet.Range("A9:A14").RowHeight = 15
      worksheet.Range("A15:A23").RowHeight = 18
      'Saving the Excel to the MemoryStream 			
      Dim stream As MemoryStream = New MemoryStream()
      'Save the stream as a file in the device and invoke it for viewing
      Xamarin.Forms.DependencyService.[Get](Of ISave)().SaveAndView("GettingStared.xlsx", "application/msexcel", stream)
    End Using
  5. Download the helper files from this link and add them into the mentioned project. These helper files allow you to save the stream as a physical file and open the file for viewing.

Project File Name Summary
Portable project ISave.cs Represent the base interface for save operation
iOS Project
  • SaveIOS.cs
  • PreviewControllerDS.cs
  • Save implementation for iOS device
  • Helper class for viewing the Excel file in iOS device
Android project SaveAndroid.cs Save implementation for Android device
WinPhone project SaveWinPhone.cs Save implementation for Windows Phone device
UWP project SaveWindows.cs Save implementation for UWP device.
Windows(8.1) project SaveWindows81.cs Save implementation for WinRT device.
  1. Compile and execute the application. Now this application creates a simple Excel document.

A complete working example of how to create an Excel file in Xamarin in C# is present on this GitHub page.

By executing the program, you will get the Excel file as below.
Output File

Read and Edit Excel file

The below code illustrates how to read and edit an Excel file in Xamarin.


Please include the Excel document in the Xamarin project and set the Build Action property of the document as Embedded Resource.

void btnCreate_Click(object sender, System.EventArgs e)
  ExcelEngine excelEngine = new ExcelEngine();
  IApplication application = excelEngine.Excel;
  application.DefaultVersion = ExcelVersion.Xlsx;

  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";

  //Access a cell value from Excel
  var value = worksheet.Range["A1"].Value;

  MemoryStream stream = new MemoryStream();

  //Save the stream into XLSX file
  Xamarin.Forms.DependencyService.Get<ISave>().SaveAndView("sample.xlsx","application/msexcel", stream);
using System.IO;
using System.Threading.Tasks;

private interface ISave
  //Method to save document as a file and view the saved document
  void SaveAndView(string filename, string contentType, MemoryStream stream);

A complete working example of how to read and edit an Excel file in Xamarin in C# is present on this GitHub page.


SaveAndView is helper method to save the stream as a physical file and open the file in default viewer. The operation varies between Windows Phone, Android and iOS platforms as described in the code samples below.

Windows Phone

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Windows.Storage;
using System.IO;
using Xamarin.Forms;

[assembly: Dependency(typeof(SaveWindowsPhone))]

class SaveWindowsPhone: ISave
  //Method to save document as a file in Windows Phone and view the saved document.
  public async Task SaveAndView(string filename, string contentType, MemoryStream stream)
    //Save the stream to a file. 
    StorageFolder local = Windows.Storage.ApplicationData.Current.LocalFolder;
    StorageFile outFile = await local.CreateFileAsync(filename, CreationCollisionOption.ReplaceExisting);
    using (Stream outStream = await outFile.OpenStreamForWriteAsync())
	  outStream.Write(stream.ToArray(), 0, (int)stream.Length);

    //Launch the saved file for viewing in default viewer.
    await Windows.System.Launcher.LaunchFileAsync(outFile);


using System;
using System.IO;
using Android.Content;
using Java.IO;
using Xamarin.Forms;
using System.Threading.Tasks;
using Android;
using Android.Content.PM;
using AndroidX.Core.Content;
using AndroidX.Core.App;

[assembly: Dependency(typeof(SaveAndroid))]

class SaveAndroid: ISave
  //Method to save document as a file in Android and view the saved document
  public async Task SaveAndView(string fileName, String contentType, MemoryStream stream)
    string root = null;

    if (ContextCompat.CheckSelfPermission(Forms.Context, Manifest.Permission.WriteExternalStorage) != Permission.Granted)
      ActivityCompat.RequestPermissions((Android.App.Activity)Forms.Context, new String[] { Manifest.Permission.WriteExternalStorage }, 1);

    //Get the root path in android device.
    if (Android.OS.Environment.IsExternalStorageEmulated)
      root = Android.OS.Environment.ExternalStorageDirectory.ToString();
      root = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments);

    //Create directory and file 
    Java.IO.File myDir = new Java.IO.File(root + "/Syncfusion");

    Java.IO.File file = new Java.IO.File(myDir, fileName);

    //Write the stream into the file
    FileOutputStream outs = new FileOutputStream(file);

    //Invoke the created file for viewing
    if (file.Exists())
      string extension = Android.Webkit.MimeTypeMap.GetFileExtensionFromUrl(Android.Net.Uri.FromFile(file).ToString());
      string mimeType = Android.Webkit.MimeTypeMap.Singleton.GetMimeTypeFromExtension(extension);
      Intent intent = new Intent(Intent.ActionView);
      intent.SetFlags(ActivityFlags.ClearTop | ActivityFlags.NewTask);
      Android.Net.Uri path = FileProvider.GetUriForFile(Forms.Context, Android.App.Application.Context.PackageName + ".provider", file);
      intent.SetDataAndType(path, mimeType);
      Forms.Context.StartActivity(Intent.CreateChooser(intent, "Choose App"));


Introduced a new runtime permission model for the Android SDK version 23 and above. So, include the following code for enabling the Android file provider to save and view the generated PDF document.

Create a new XML file with the name of provider_path.xml under the Resources folder of Android project and add the following code in it. Eg: Resources/xml/provider_path.xml

<?xml version="1.0" encoding="UTF-8" ?>
<paths xmlns:android="">
   <external-path name="external_files" path="."/>

Add the following code to the AndroidManifest.xml file located under Properties/AndroidManifest.xml.

<?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="" android:versionCode="1" android:versionName="1.0" package="com.companyname.CreateXlsIOSample">
   <uses-sdk android:minSdkVersion="19" android:targetSdkVersion="27" />
   <application android:label="CreateXlsIOSample.Android">
      <provider android:name="androidx.core.content.FileProvider"
         <meta-data android:name=""
            android:resource="@xml/provider_paths" />


using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.IO;
using Xamarin.Forms;
using GettingStarted.iOS;
using UIKit;
using QuickLook;

[assembly: Dependency(typeof(SaveIOS))]

class SaveIOS: ISave
  //Method to save document as a file in iOS and view the saved document.
  public async Task SaveAndView(string filename, string contentType, MemoryStream stream)
    //Get the root path of iOS device.
    string path = Environment.GetFolderPath(Environment.SpecialFolder.Personal);
    string filePath = Path.Combine(path, filename);

    //Create a file and write the stream into it.
    FileStream fileStream = File.Open(filePath, FileMode.Create);
    stream.Position = 0;


    //Launch the saved file for viewing in default viewer.
    UIViewController currentController = UIApplication.SharedApplication.KeyWindow.RootViewController;
    while (currentController.PresentedViewController != null)
      currentController = currentController.PresentedViewController;
    UIView currentView = currentController.View;

    QLPreviewController preview = new QLPreviewController();
    QLPreviewItem item = new QLPreviewItemBundle(filename, filePath);
    preview.DataSource = new PreviewControllerDS(item);

    currentController.PresentViewController(preview, true, null);


Launching a file in default viewer is different in iOS when compared to Windows Phone and Android. This requires the helper class PreviewControllerDS, as described in the code samples below.

using System;
using QuickLook;

public class PreviewControllerDS : QLPreviewControllerDataSource
  private QLPreviewItem _item;

  public PreviewControllerDS(QLPreviewItem item)
    _item = item;

  public override nint PreviewItemCount (QLPreviewController controller)
    return (nint)1;

  public override IQLPreviewItem GetPreviewItem (QLPreviewController controller, nint index)
    return _item;

using System;
using QuickLook;
using Foundation;
using System.IO;

public class QLPreviewItemFileSystem : QLPreviewItem
  string _fileName, _filePath;

  public QLPreviewItemFileSystem(string fileName, string filePath)
    _fileName = fileName;
    _filePath = filePath;

  public override string ItemTitle
      return _fileName;
  public override NSUrl ItemUrl
      return NSUrl.FromFilename(_filePath);

public class QLPreviewItemBundle : QLPreviewItem
  string _fileName, _filePath;
  public QLPreviewItemBundle(string fileName, string filePath)
    _fileName = fileName;
    _filePath = filePath;

  public override string ItemTitle
      return _fileName;
  public override NSUrl ItemUrl
      var documents = NSBundle.MainBundle.BundlePath;
      var lib = Path.Combine(documents, _filePath);
      var url = NSUrl.FromFilename(lib);
      return url;


Starting with v16.2.0.x, if you reference Syncfusion assemblies from trial setup or from the NuGet feed, you also have to add “Syncfusion.Licensing” assembly reference and include a license key in your projects. Please refer to this link to know about registering Syncfusion license key in your applications to use our components. You can also explore our Xamarin Excel library demo that shows how to create and modify Excel files from C# with just five lines of code.