Loading and Saving Excel files in Azure App Service on Linux

24 Jun 20264 minutes to read

.NET Excel Library for ASP.NET Core platform can be used to create, read, edit Excel files in Azure App Service on Linux.

Steps to Load and Save an Excel document in Azure App Service on Linux

The below steps illustrates loading and saving a simple Invoice formatted Excel document in Azure App Service Linux.

Step 1: Create a new ASP.NET Core Web Application (Model-View-Controller).

Step 2: Name the project.

Step 3: Select the framework and click Create button.

Step 4: Install the Syncfusion.XlsIO.Net.Core NuGet package as reference to your .NET Standard applications from NuGet.org.

NOTE

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.

Step 5: Include the following namespaces in HomeController.cs.

C#
using Syncfusion.XlsIO;

Step 6: Add a new button in the Index.cshtml as shown below.

CSHTML
@{
    Html.BeginForm("LoadingandSaving", "Home", FormMethod.Get);
    {
        <div>
            <br>
            <input type="submit" value="Loading and Saving Document" style="width:230px;height:27px" />
        </div>
    }
    Html.EndForm();
}

Step 7: Include the below code snippet in HomeController.cs to load and save an Excel file and download it.

C#
//Create an instance of ExcelEngine
using (ExcelEngine excelEngine = new ExcelEngine())
{
    IApplication application = excelEngine.Excel;
    application.DefaultVersion = ExcelVersion.Xlsx;

    //Load an existing Excel document
    FileStream inputStream = new FileStream("Data/InputTemplate.xlsx", FileMode.Open, FileAccess.Read);
    IWorkbook workbook = application.Workbooks.Open(inputStream);

    //Access first worksheet from the workbook.
    IWorksheet worksheet = workbook.Worksheets[0];

    //Set Text in cell A3.
    worksheet.Range["A3"].Text = "Hello World";

    //Save the Excel to MemoryStream 
    MemoryStream outputStream = new MemoryStream();
    workbook.SaveAs(outputStream);

    //Set the position
    outputStream.Position = 0;

    //Download the Excel document in the browser.
    return File(outputStream, "application/msexcel", "Output.xlsx");
}