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. Image for the cookie policy date
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Trusted by the world’s leading companies

Syncfusion Trusted Companies

Overview

The ASP.NET MVC Spreadsheet, an ASP.NET MVC Excel viewer, is a feature-rich control for organizing and analyzing data in tabular format. It provides all the common Excel features, including data binding, selection, editing, formatting, resizing, sorting, importing, and exporting Excel documents.


Why choose the Syncfusion ASP.NET MVC Spreadsheet?

ASP.NET MVC Spreadsheet high performance.

High performance

The ASP.NET MVC Spreadsheet is designed and optimized for loading large amounts of data into a worksheet and viewing it on demand with the help of row and column virtualization.

ASP.NET MVC Spreadsheet data binding.

Seamless data binding

Bind data seamlessly with various local and remote data sources such as JSON, OData, WCF, and RESTful web services with the help of a data manager.

ASP.NET MVC Spreadsheet hassle free formatting

Hassle-free formatting

ASP.NET MVC Spreadsheet allows users to format cells, numbers, and also allows conditional formatting to format a cell or range of cells based on the conditions applied.

Transform data to chart in ASP.NET MVC Spreadsheet

Transform data to a chart

The chart feature transforms the Spreadsheet data into an intuitive visual for better understanding and to make smart business decisions.

ASP.NET MVC Spreadsheet built-in formula

Wide range of built-in formulas

The ASP.NET MVC Spreadsheet library provides a wide range of formulas with cross-sheet reference support. The rich UI comes with an built-in calculation engine that performs formula calculations.

ASP.NET MVC Spreadsheet themes

Attractive customizable themes

Cutting edge design with built-in themes such as Fluent, Tailwind CSS, Material, Fabric, and more. Utilize the online Theme Studio tool to customize themes easily.

ASP.NET MVC Spreadsheet globalization

Globalization and localization

Enables users from different locales to use the Spreadsheet by formatting dates, currency, and numbering to suit their preferences.


ASP.NET MVC Spreadsheet code example

Easily get started with the ASP.NET MVC Spreadsheet using a few simple lines of C# code, as demonstrated in the following example. Also explore our ASP.NET MVC Spreadsheet example, which shows you how to render and configure a Spreadsheet in ASP.NET MVC.

@Html.EJS().Spreadsheet("spreadsheet").Sheets(sheet =>
{
        sheet.Ranges(ranges =>
        {
            ranges.DataSource((IEnumerable<object>)ViewBag.DefaultData).Add();

        }).Columns(column =>
        {
            column.Width(80).Add();
            column.Width(80).Add();
            column.Width(100).Add();
            column.Width(100).Add();
            column.Width(100).Add();
        }).Add();
}).Render()
public IActionResult Index()
    {
        List<object> data = new List<object>()
            {
               new { OrderId= "SF1001", Product= "Laptop Backpack (Blue)", OrderedDate= "02/14/2014", OrderedBy= "Rahul Sharma", Shipment= "Delivered"},
               new { OrderId= "SF1002", Product= "Oppo F1 S mobile back cover", OrderedDate= "06/11/2014", OrderedBy= "Adi Pathak", Shipment= "Delivered"},
               new { OrderId= "SF1003", Product= "Tupperware 4 bottle set", OrderedDate= "07/27/2014", OrderedBy= "Himani Arora", Shipment= "Pending"},
               new { OrderId= "SF1004", Product= "Tupperware Lunch box", OrderedDate= "11/21/2014", OrderedBy= "Samuel Samson", Shipment= "Shipped"},
               new { OrderId= "SF1005", Product= "Panosonic Hair Dryer", OrderedDate= "06/23/2014", OrderedBy= "Neha", Shipment= "Cancelled"},
            };
        ViewBag.DefaultData = data;
        return View();
    }

Worksheet

A worksheet is a collection of cells arranged in rows and columns that lets you save, format, and work with data. You can create, delete, and rename worksheets, as well as customize the headers, gridlines, and sheet visibility in our ASP.NET MVC Spreadsheet.

ASP.NET MVC worksheet.


Work with cell ranges

A cell range refers to a set of cells in a sheet. Spreadsheet supports several features for working with cell ranges.

Wrap text in ASP.NET MVC Spreadsheet.

Wrap text

You can display a large amount of content in multiple lines within a single cell by using text wrap.

Merge cells in ASP.NET MVC Spreadsheet.

Merge cells

Combine two or more cells from the same row or column into a single cell by merging them.

Data validation in ASP.NET MVC Spreadsheet.

Data validation

Restrict the entry of wrong data by users with data validation. You can also highlight the incorrect data.

Autofill in ASP.NET MVC Spreadsheet.

Autofill

The autofill option allows users to fill or copy a series or pattern of values and formats into adjacent cells in any direction.


ASP.NET MVC Spreadsheet editing

Editing

Data editing allows you to add, edit, and remove formulas or values in a cell. Edit the contents of a cell directly in the cell or by typing in the formula bar.


Excel-like selection

The ASP.NET MVC Spreadsheet library provides interactive support to highlight the cells, rows, columns, and sheets selected. Selection can be done through mouse, touch, or keyboard interaction.

ASP.NET MVC Spreadsheet selection


Number formatting in ASP.NET MVC Spreadsheet

Number formatting

Number formatting is used to change the appearance of numbers in ASP.NET MVC Spreadsheet. It helps display data as currency, percentages, short dates, long dates, time, fractions, and scientific numbers, similar to Excel.


Cell formatting

Using cell formatting, users can highlight a particular cell or range of cells from a whole workbook. The component supports various formatting options: font size, font family, font color, fill color, indent, and horizontal and vertical alignments of text.

Sheet tabs in ASP.NET MVC Spreadsheet


Conditional formatting in ASP.NET MVC Spreadsheet.

Conditional formatting

Conditional formatting can format a cell or range of cells based on the conditions that are applied. This enables you to highlight data based on the appropriate condition.


Sort and filter

  • Reorganize data by sorting the range of cells in either the ascending or descending order. The custom sort option allows you to sort multiple columns.
  • When filtering, if values in one or more columns do not meet the filtering criteria, all the data will be hidden. You can filter text, dates, and numbers.

ASP.NET MVC Spreadsheet sorting and filtering


Hyperlink in ASP.NET MVC Spreadsheet Viewer

There is built-in support for hyperlinks and bookmarks. Navigate to web links or cell references within the sheet or other sheets in the workbook.


Images

The image feature allows users to view, insert, and modify a picture in an ASP.NET MVC Spreadsheet with customizing options.

Image in ASP.NET MVC Spreadsheet component


Chart in ASP.NET MVC Spreadsheet.

Charts

The chart feature transforms the Spreadsheet data into an intuitive visual for better understanding.


Ribbon UI

An interactive ribbon organizes the Spreadsheet’s features into a series of tabs. Collapse the ribbon to make more rows visible in the viewport.

Ribbon in ASP.NET MVC Spreadsheet


Searching in ASP.NET MVC Spreadsheet.

Find and replace

You can use Find and Replace option to search for content easily within a worksheet or workbook and then change out the original text for an alternative.


Freeze panes

The freeze panes allow users to keep specified rows and columns always visible at the top or left side of the sheet while scrolling through it.

Freeze panes in ASP.NET MVC Spreadsheet.


Protection in ASP.NET MVC Spreadsheet.

Protection

  • Encrypt workbooks with a password to prevent unauthorized users from opening them.
  • Encrypt worksheets with a password and restrict user actions like editing, row and column resizing, inserting, and deleting.

Adaptive UI layout

The ASP.NET MVC Spreadsheet user interface has been customized and redesigned for great views and usability on small screens.

ASP.NET MVC Spreadsheet adaptive UI layout.


Interactive features

Clipboard operations in ASP.NET MVC Spreadsheet

Copy to clipboard

Use the clipboard operations, cut, copy, and paste, just like Microsoft Excel. You can paste the values or formulas with or without formatting in a newly selected range.

Undo and redo in ASP.NET MVC Spreadsheet

Undo and redo

The Spreadsheet component provides options to undo and redo changes made in a workbook. You can customize the limit of undo and redo operations.

Context menu in ASP.NET MVC Spreadsheet.

Context menu

The context menu improves user interaction with the ASP.NET MVC Spreadsheet using a pop-up menu. It appears when a cell, row header, column header, or sheet tab is right-clicked.

Cell comments in ASP.NET MVC Spreadsheet

Cell comments (notes)

The Spreadsheet component provides options to add, edit, and delete cell comments.

Row and column resizing in ASP.NET MVC Spreadsheet

Resize and autofit

The resize and autofit options help you adjust the row height and column width.

Smooth scrolling in ASP.NET MVC Spreadsheet

Smooth scrolling

The ASP.NET MVC Spreadsheet component provides a smooth scrolling experience even with many cells in a view.


Open and save

ASP.NET MVC Spreadsheet Excel and CSV import

Excel and CSV import

Load Excel documents initially or open them like an Excel application with data accuracy, styles, and formats. Microsoft Excel (.xlsx), Microsoft Excel 97-2003 (.xls), and comma-delimited values (.csv) file formats can be opened in an ASP.NET MVC Spreadsheet.

ASP.NET MVC Spreadsheet Excel and CSV export

Excel and CSV export

Easily save the ASP.NET MVC Spreadsheet component with data accuracy, styles, and formats as an Excel file. The ASP.NET MVC Spreadsheet supports file formats such as Microsoft Excel (.xlsx), Microsoft Excel 97-2003 (.xls), and comma-delimited values (.csv).


Accessibility

Keyboard navigation in ASP.NET MVC Spreadsheet

Keyboard navigation

The ASP.NET MVC Excel Spreadsheet ensures that every cell is accessible using a keyboard. Major features like selection, clipboard, and editing can be performed using keyboard commands alone, no mouse interaction required. This helps in creating highly accessible applications using this component.

Accessibility and screen reader support in ASP.NET MVC Spreadsheet

Screen readers

The ASP.NET MVC Excel Spreadsheet has complete WAI-ARIA accessibility support. Its rich UI includes high-contrast visual elements, helping visually impaired people have the best viewing experience. Also, valid UI descriptions are easily accessible through assistive technologies such as screen readers.

Show right-to-left language in ASP.NET MVC Spreadsheet

Right to left (RTL)

Right-to-left rendering allows you to display the text and layout of the ASP.NET MVC Spreadsheet from right to left. This improves the user experience and accessibility for RTL languages.


Additional features

 ASP.NET MVC Spreadsheet touch friendly

Touch-friendly and responsive

It recognizes touch gestures, allowing the user to swipe left or right to move the sheet. The responsive, mobile-friendly design provides the best user experience on all mobiles, tablets, and desktop form factors.

ASP.NET MVC Spreadsheet developer friendly APIs

Developer-friendly APIs

Developers can customize their UI and control its behaviors according to the end user’s requirement using the control’s rich set of client-side APIs.

Printing in ASP.NET MVC Spreadsheet.

Print

With the ASP.NET MVC Spreadsheet control, you can print a single or multiple sheets of data easily.





Other supported frameworks

The Spreadsheet component is also available for Angular, React, Vue, JavaScript, and ASP.NET Core frameworks. Check out the Spreadsheet for different platforms:

Supported browsers

The ASP.NET MVC Spreadsheet works well with all modern web browsers: Chrome, Firefox, Edge, Safari, and IE11. It supports IE11 with the help of polyfills.

Supported browsers of ASP.NET MVC Spreadsheet

85+ ASP.NET MVC UI CONTROLS

Frequently Asked Questions

  • Seamless data analysis and visualization like in Microsoft Excel.
  • Compatibility with Microsoft Excel file formats.
  • Highly intuitive user interfaces.
  • Flexible data binding with support to use local and remote data source services.
  • Support for freeze panes, keyboard shortcuts, and all the common Excel features.
  • Support for all modern browsers.
  • -ouch friendly and responsive UI.
  • Expansive learning resources such as demos and documentation let you get started quickly with the ASP.NET MVC Spreadsheet.

We do not sell the ASP.NET MVC Spreadsheet separately. It is only available for purchase as part of the Syncfusion team license. This contains over 1,800 components and frameworks, including the ASP.NET MVC Spreadsheet. The price of the team license starts at $395 per month for 5 developers, and includes support and updates until the subscription expires. In addition, we might offer discounts based on currently active promotions. Please contact our product specialists to see if you qualify for any additional discounts.

You can find our ASP.NET MVC Spreadsheet demo here. It demonstrates how to render and configure the Spreadsheet.

No, our 1,800+ components and frameworks for web, mobile, and desktop, including our ASP.NET MVC Spreadsheet, are not sold individually. They are only available as part of a team license. However, we have competitively priced the product, so it only costs a little bit more than what some other vendors charge for their Spreadsheet control alone. We have also found that, in our experience, our customers usually start off using one of our products and then expand to several products quickly, so we felt it was best to offer all 1,800+ components and frameworks for a subscription fee that starts at $395 per month for a team of 5 developers. Additionally, we might be able to offer discounts based on currently active promotions. Please contact our product specialists to see if you qualify for any additional discounts.

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, 5 or fewer developers, and 10 or fewer total employees.

A good place to start would be our comprehensive getting started documentation.

Our Customers Love Us

Having an excellent set of tools and a great support team, Syncfusion reduces customers’ development time.
Here are some of their experiences.

Rated by users across the globe

Transform your applications today by downloading our free evaluation version
Download Free Trial No credit card required.

Awards

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.

Up arrow icon
Live Chat Icon For mobile