USING IRONXL

How to Export CSV and Excel in Razor

Updated March 26, 2023
Share:

Looking for a way to export data to an Excel file using Razor Pages? This article instructs on how to do so using IronXL for .NET.

1. IronXL

IronXL is a .NET library used for working with Excel files. It is built on top of OpenXML SDK and provides a simple API for reading, writing, and manipulating Excel spreadsheets. IronXL can be used in a variety of .NET applications, including Web Applications, Desktop Applications, and Console Applications. IronXL provides a range of features for working with Excel documents, including the ability to read and write data to individual cells, create charts and graphs, and perform complex calculations. It also supports advanced Excel features such as pivot tables, conditional formatting, and data validation.

Exporting data to Excel and CSV files is a common task in web development, and Razor and IronXL make it easy to accomplish. With IronXL, developers can easily create Excel spreadsheets and save them to a file or stream. Razor can then be used to generate dynamic content that includes links to the Excel document, allowing users to download them directly from the web page. CSV file format can also be generated using IronXL and downloaded similarly using Razor. This makes it simple to create reports and other data-driven content that can be easily shared with others. Overall, the combination of Razor and IronXL .NET Core Razor Pages provides a powerful toolset for web developers looking to create dynamic, data-driven web pages.

2. Prerequisites

Before using Razor in Visual Studio, there are a few prerequisites that users should have in place. Here are some of the important ones:

  1. As an IronXL user, you need to have Visual Studio installed on your computer system. You can download Visual Studio Community for free from the official website of Microsoft.
  2. You also need to have .NET Core SDK installed on your computer. You can download the latest version of .NET Core SDK from the official Microsoft website.
  3. Your Web Development environment must be set before staring to work with Razor View.

3. Creating a New Visual Studio Project

To create a new Visual Studio project, follow these steps:

  1. Open Visual Studio.
  2. Click on "Create a New Project" in the start window, or click on "File" > "New" > "Project" in the menu bar.

    How to Export CSV and Excel in Razor, Figure 1: Visual Studio's start window Visual Studio's start window

  3. Select the type of project you want to create, to use Razor Pages, select ASP.NET Core Web App and click on Next.

    How to Export CSV and Excel in Razor, Figure 2: Create a new .NET Core Web App in Visual Studio Create a new .NET Core Web App in Visual Studio

  4. A new window will appear, write your new project name and location. Then click on Next.

    How to Export CSV and Excel in Razor, Figure 3: Configure the new project Configure the new project

  5. Now in the new window select your target Framework, check the configure for HTTPS option and click on create.
  6. Just like that your new Visual Studio ASP.NET Core Web App Project is created.

4. Install IronXL

The IronXL Library can be downloaded and installed in different ways.

These are:

  • Using Visual Studio NuGet packages
  • Using the Visual Studio Command Line.

4.1 Using Visual Studio

To install the IronXL library, the simplest approach is to use the NuGet Package Manager. Open the manager and search for IronXL in the browse tab. Choose IronXL from the search results and install it.

The below screenshot shows how to open the NuGet Package Manager in Visual Studio.

How to Export CSV and Excel in Razor, Figure 4: Navigate to NuGet Package Manager Navigate to NuGet Package Manager

IronXL in search results:

How to Export CSV and Excel in Razor, Figure 5: Search for IronXL in NuGet Package Manager UI Search for IronXL in NuGet Package Manager UI

4.2 Using the Visual Studio Command-Line

Using a console to perform operations is a popular choice for many. If you prefer to install IronXL through the command line, you can follow these steps:

  • In Visual Studio, go to Tools > NuGet Package Manager > Package Manager Console.
  • Enter the following line in the Package Manager Console tab:
Install-Package IronXL.Excel

Now the package will download/install to the current project and be ready to use.

How to Export CSV and Excel in Razor, Figure 6: Install IronXL in the Package Manager Console Install IronXL in the Package Manager Console

5. Export Data to an Excel File in Razor Net Core

Once the project is created a simple interface of the Razor application is created. Now change the interface to export to Excel export.

How to Export CSV and Excel in Razor, Figure 7: The Web interface of the newly created project The Web interface of the newly created project

Change the above interface by editing index.cshtml file in Pages directory.

@page
@model IndexModel
@{
    ViewData ["Title"] = "Home page";
}
<div class="text-center">
    <h1 class="display-4">IronXL Generate Excel File</h1>
    <p class="m-5">This will be the combination of Razor and IronXL and togather they will Export data to Excel file.</p>
    <form method="post" asp-page-handler="Export">
        <button class="btn btn-success p-3">Export Excel File!</button>
    </form>
</div>
@page
@model IndexModel
@{
    ViewData ["Title"] = "Home page";
}
<div class="text-center">
    <h1 class="display-4">IronXL Generate Excel File</h1>
    <p class="m-5">This will be the combination of Razor and IronXL and togather they will Export data to Excel file.</p>
    <form method="post" asp-page-handler="Export">
        <button class="btn btn-success p-3">Export Excel File!</button>
    </form>
</div>
page model ReadOnly Property () As IndexModel
	ViewData ("Title") = "Home page"
End Property
'INSTANT VB TODO TASK: The following line uses invalid syntax:
'<div class="text-center"> <h1 class="display-4"> IronXL Generate Excel File</h1> <p class="m-5"> This will be the combination @of Razor @and IronXL @and togather they will Export data @to Excel file.</p> <form method="post" asp-page-handler="Export"> <button class="btn btn-success p-3"> Export Excel File!</button> </form> </div>
VB   C#

This code will change the interface of the home page and add the export button.

How to Export CSV and Excel in Razor, Figure 8: The new interface with an export button The new interface with an export button

Now create the onPostExport method in index.cshtml.cs file and write the following code. This code generates a worksheet and writes column names as bold. Users can also set the font size and even set the background color of the columns using style. It is the same as exporting database table data from SQL Server or any other database server to Excel.

public FileResult OnPostExport()
{
    WorkBook workBook = new WorkBook(IronXL.ExcelFileFormat.XLSX);
    WorkSheet workSheet = workBook.CreateWorkSheet("data");
    //Add data and styles to the new worksheet
    workSheet ["A1"].Value = "Name";
    workSheet ["B1"].Value = "Email";
    workSheet ["C1"].Value = "Marks";
    workSheet ["D1"].Value = "Persent Age";
    workSheet ["A1:D1"].Style.Font.Bold = true;
    workSheet ["A2"].Value = "Nick";
    workSheet ["A3"].Value = "Roy";
    workSheet ["A4"].Value = "Chris";
    workSheet ["B2"].Value = "Nick@gmail.com";
    workSheet ["B3"].Value = "Roy123@gmail.com";
    workSheet ["B4"].Value = "Chris1999@gmail.com";
    workSheet ["C2"].Value = "850";
    workSheet ["C3"].Value = "710";
    workSheet ["C4"].Value = "990";
    workSheet ["D2"].Value = "85%";
    workSheet ["D3"].Value = "71%";
    workSheet ["D4"].Value = "99%";

    return File(workBook.ToStream().ToArray(), "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "Exported.xlsx");
}
public FileResult OnPostExport()
{
    WorkBook workBook = new WorkBook(IronXL.ExcelFileFormat.XLSX);
    WorkSheet workSheet = workBook.CreateWorkSheet("data");
    //Add data and styles to the new worksheet
    workSheet ["A1"].Value = "Name";
    workSheet ["B1"].Value = "Email";
    workSheet ["C1"].Value = "Marks";
    workSheet ["D1"].Value = "Persent Age";
    workSheet ["A1:D1"].Style.Font.Bold = true;
    workSheet ["A2"].Value = "Nick";
    workSheet ["A3"].Value = "Roy";
    workSheet ["A4"].Value = "Chris";
    workSheet ["B2"].Value = "Nick@gmail.com";
    workSheet ["B3"].Value = "Roy123@gmail.com";
    workSheet ["B4"].Value = "Chris1999@gmail.com";
    workSheet ["C2"].Value = "850";
    workSheet ["C3"].Value = "710";
    workSheet ["C4"].Value = "990";
    workSheet ["D2"].Value = "85%";
    workSheet ["D3"].Value = "71%";
    workSheet ["D4"].Value = "99%";

    return File(workBook.ToStream().ToArray(), "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "Exported.xlsx");
}
Public Function OnPostExport() As FileResult
	Dim workBook As New WorkBook(IronXL.ExcelFileFormat.XLSX)
	Dim workSheet As WorkSheet = workBook.CreateWorkSheet("data")
	'Add data and styles to the new worksheet
	workSheet ("A1").Value = "Name"
	workSheet ("B1").Value = "Email"
	workSheet ("C1").Value = "Marks"
	workSheet ("D1").Value = "Persent Age"
	workSheet ("A1:D1").Style.Font.Bold = True
	workSheet ("A2").Value = "Nick"
	workSheet ("A3").Value = "Roy"
	workSheet ("A4").Value = "Chris"
	workSheet ("B2").Value = "Nick@gmail.com"
	workSheet ("B3").Value = "Roy123@gmail.com"
	workSheet ("B4").Value = "Chris1999@gmail.com"
	workSheet ("C2").Value = "850"
	workSheet ("C3").Value = "710"
	workSheet ("C4").Value = "990"
	workSheet ("D2").Value = "85%"
	workSheet ("D3").Value = "71%"
	workSheet ("D4").Value = "99%"

	Return File(workBook.ToStream().ToArray(), "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "Exported.xlsx")
End Function
VB   C#

This above code will create a workbook and return the file as an Excel sheet. This method will be linked to the button and once the button is clicked, it will automatically create and download the XLSX exported file.

How to Export CSV and Excel in Razor, Figure 9: Export an XLSX file in the browser Export an XLSX file in the browser

How to Export CSV and Excel in Razor, Figure 10: The data in the exported XLSX file The data in the exported XLSX file

6. Export Data to CSV File

Same as above you can easily export CSV text files with changes in a single line of code in the above code samples. Just replace the return file code in the above source code with this and your Razor page will return a CSV file.

return File(workBook.ToStream().ToArray(), "text/csv", "Student.csv");
return File(workBook.ToStream().ToArray(), "text/csv", "Student.csv");
Return File(workBook.ToStream().ToArray(), "text/csv", "Student.csv")
VB   C#

How to Export CSV and Excel in Razor, Figure 11: Export a CSV file in the browser Export a CSV file in the browser

How to Export CSV and Excel in Razor, Figure 12: The data in the exported CSV file The data in the exported CSV file

7. Conclusion

Exporting data to Excel sheets and CSV files is a common task in web development, and Razor and IronXL make it easy to accomplish. With IronXL, developers can easily create Excel spreadsheets and save them to a file or stream. Razor can then be used to generate dynamic content that includes links to the Excel document, allowing users to download them directly from the web page. This makes it simple to create reports and other data-driven content that can be easily shared with others.

The combination of Razor and IronXL .NET Core Razor Pages provides a powerful toolset for web developers looking to create dynamic, data-driven web pages. To start using Razor and IronXL, one needs to have Visual Studio and .NET Core SDK installed. After that, creating a new Visual Studio project and installing the IronXL library can be done easily. Finally, by changing the interface of the home page and creating an OnPostExport method, developers can export data to Excel documents in a few simple steps.

To learn more about IronXL, Razor and how to export data to Excel and CSV files please visit the following page.

IronXL is free to use for non-commercial development purposes. A free trial is available for testing in production. Look at the pricing plans for more details about prices and licensing.

Users can also benefit from Iron Suite, a Suite of 5 professional ASP.NET Core libraries including IronXL, IronPDF, and more.

< PREVIOUS
How to Freeze a Row in Excel (Beginner Guide)
NEXT >
How to Unhide All Rows in Excel

Ready to get started? Version: 2024.7 just released

Free NuGet Download Total downloads: 883,975 View Licenses >
123