ASP.NET Web Forms Spreadsheet - Syncfusion ASP.NET Web Forms UI Controls

The ASP.NET Web Forms Spreadsheet is a Microsoft Excel-like control for the web that allows you to create, view, edit and format Microsoft Excel files. It ships with a built-in calculation engine with support for more than 200 of the most widely used formulas. Its functionalities include editing, data binding, filtering, formulas, charts, formatting, data validation, pivot tables, printing, importing and exporting.

Features and benefits

Performance

Spreadsheet is designed and optimized for high performance. A high volume of data can be loaded without performance degradation by using row virtualization.

Sort and filter

Analyze data with automatic filtering and sorting. The Spreadsheet control provides support for filtering specific data from the spreadsheet and sorting columns by ascending or descending order.

Formulas

A wide range of formulas is available with cross-sheet references, named ranges support.The built-in calculation engine is preloaded with more than 200 Excel-compatible functions covering a broad range of business scenarios.

Data Editing

• Data editing comes with the ability to add, edit, and remove formulas/values in a cell.
• Validate the edited values based on the data validation rules defined for a cell or range of cells.
• There's built-in support for hyperlinks and bookmarks.

Learn more about editing

Formatting

Number formatting changes the appearance of numbers in a cell by adding percent signs, commas, currency symbols, decimals, and more to signify different meanings. Text formatting allows users to change the font, font size, color, weight, style, alignment, and wrapping of text in a cell.

Learn more about formatting

Conditional formatting

In JavaScript Spreadsheet, Conditional formatting helps you visually explore and analyze data, detect critical issues, and identify patterns and trends. Format the appearance of cells based on their value or the values of any other cells.

Charts and Pivot table

• Data in columns or rows on a worksheet can be plotted as a chart. Spreadsheet supports various chart types
  • Line chart
  • Column chart
  • Bar chart
  • Pie or Doughnut chart
  • Area chart
• Sparklines used to show trends in series of values. It is a small chart in the cell of worksheet.
• Pivot table support for summarizing and analyzing large amounts of data in Spreadsheet.

Learn more about charts and pivot table

Touch optimized

The JavaScript Spreadsheet control is touch-optimized for all user interactions like swipe for scrolling and taps for selection, sorting, filtering and more.

Import and Export

Existing Excel worksheets can be imported into the Spreadsheet control and edited by users. This control supports exporting spreadsheets as XLS, XLSX, and comma-delimited value files.

Related links

Download Free Trial

Pricing

Online Examples

Community Forums

Documentation

Knowledge base

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.

Today we provide 1800+ controls and frameworks for web (Blazor, ASP.NET Core, ASP.NET MVC, ASP.NET WebForms, JavaScript, Angular, React, Vue, and Flutter), mobile (Xamarin, Flutter, UWP, JavaScript, and MAUI), and desktop development ( WinForms, WPF, WinUI, UWP, Flutter, and MAUI). We provide ready-to deploy enterprise software for dashboards, reports, data integration, and big data processing. Many customers have saved millions in licensing fees by deploying our software.

sales@syncfusion.com | www.syncfusion.com | Toll Free: 1-888-9 DOTNET