background

UI for WPF

WPF Spreadsheet

  • Enjoy virtually no limitations on the number of cells in a sheet, providing unmatched performance-even with thousands of cells with the Telerik UI for WPF Spreadsheet.
  • Part of the Telerik UI for WPF library along with 160+ professionally-designed UI controls.
  • Includes support, documentation, demos, virtual classrooms, Visual Studio Extensions and more!
Telerik UI for WPF Spreadsheet
  • MS Excel-Like Authoring

    Provide Microsoft Excel-like authoring and editing in your applications with a smooth familiar interface for your end-users.
    WPF Spreadsheet control displaying MS Excel-Like Authoring
  • Workbook and Worksheet Protection

    Full support for Workbook protection allows you to ask for a password if users want to delete, add or rename worksheets. Worksheet protection allows you to apply a set of options that define what the user can do within the worksheet. You can allow users to change certain perimeters such as column weight and lock others such as row height for example. You also can make certain cells read-only to prevent users form changing their content.
  • Support for XLSM

    Since R3 2021, the Telerik UI for WPF Spreadsheet now support working with XLSM files. In addition to XLSX, XLS, CSV, TXT and PDF, we’ve added support for XLSM files without working with macros. Macros won’t be stripped from your file; however, they won’t be active in applications.  

    Telerik UI for WPF Spreadsheet Documentation
  • Images Support

    RadSpreadsheet allows your application users to easily insert and format images in their worksheets.
  • Formulas

    There are more than 100 built-in formulas, covering a broad range of categories, which can meet even the most demanding requirements, including:
    • Financial formulas
    • Statistical formulas
    • Engineering formulas
    WPF Spreadsheet control displaying Formulas
  • Sorting and Filtering

    Organize and search data easily. Get a better understanding of data spanning across multiple rows and columns and quickly analyze data with the sorting functionality.

    The filtering functionality enables you to add flexibility to your data. Display and focus on the data that you need at any given moment, without breaking its initial structure and content.

    WPF Spreadsheet control displaying Sorting and Filtering
  • Copy/Paste

    Copy-paste cells from a sheet with their formatting, using different paste options, all neatly organized in a drop-down in the ribbon view.
    WPF Spreadsheet control displaying Copy and Paste
  • Number Formats

    Manipulate, create and represent data in a variety of formats using any of the options for displaying numbers that RadSpreadsheet for Silverlight provides. All the main number formats are supported, including dates, currencies, percentages, text, and others.  

    WPF Spreadsheet control displaying Number Formats
  • Freeze Pane Support

    To ease the user experience of working with multiple rows and columns, the RadSpreadsheet control for WPF now enables you to pin rows and columns in your worksheet.
    WPF Spreadsheet control displaying Freeze Pane Support
  • Named Ranges

    Define a name for a cell or range of cells, so you can easily remember and use it throughout your spreadsheet, instead of a cell reference.
    WPF Spreadsheet control displaying Named Ranges
  • Cell Formatting

    Provide your end-users the ability to apply different fonts and font sizes, as well as foreground and background color for the text in the cells. This functionality is further enhanced by the ability to use styles and themes for a more consistent look-and-feel in the document.
  • Conditional Formatting UI

    Conditional formatting allows users to precisely define the formatting of cells that satisfy predefined conditions, making it easier to analyze data and spot irregularities in it. The feature comes with a wide range of predefined conditions, formatting options and also supports utilizing a formula to define a condition.

    WPF Spreadsheet Control displaying Conditional formatting
  • Insert/Delete Comments

    This functionality of the Telerik Spreadsheet enables adding a comment to a specific cell. Users can also delete or reply to a comment. Additionally, a comment (thread) can be marked as resolved, deleted or reopened at a later stage.

    WPF Spreadsheet control displaying Insert and delete comments
  • Performance

    Enjoy virtually no limitations on the number of cells in a sheet, providing unmatched performance--even with thousands of cells.
  • Multiple Sheets and Undo/Redo

    Your end-users have the ability to create and use multiple sheets, each one with its own history stack. Separate sheets can be edited at the same time, and every single action can be undone and redone.
  • Powerful Ribbon

    The SpreadsheetRibbon control compliments Spreadsheet, with convenient ribbon exposing the variety of features the latter supports. With few lines of XAML you get all the UI expected from a standard spreadsheet editing application, including multiple ribbon tabs full of commands, styles gallery, formula and status bar. When updating from version to version, you'll automatically get UI for all the new commands we expose.

    The Spreadsheet control provides convenient design-time experience – dragging Spreadsheet in the XAML designer will start code-generation wizard. You can choose a set of components, and all of the needed XAML code and assembly references are automatically added to the project.

    WPF Spreadsheet Control showcasing design time experience
  • Charts Support

    The Spreadsheet component offers support for Charts to better visualize and summarize the data in the spreadsheet document for end users in a visually appealing and understandable way. The functionality offers the ability to not only display charts, but also add and remove chart objects in the spreadsheet itself.

    The supported chart types are:


    Column
    Bar
    Line
    Pie & Donut
    Area
    Bubble
    Stock

    WPF Spreadsheet Control showcasing Charts support
  • Export/Import

    Save documents in three different formats to achieve best persistence of the data:

    • Excel Microsoft Office Open XML Spreadsheet (.xlsx)
    • Comma separated values (.CSV)
    • Tab separated values (.txt)
    • Portable document format (.pdf) - export only
  • Printing and Print Preview

    The new printing feature allows you to insert page breaks, define page areas and choose between numerous printing options. Virtual printers help you easily export your workbooks to different file formats.
  • Repeat Specific Rows or Columns on Every Printed Page

    You can specify a row or a column that will be repeated on every printed page. You will find this API useful when you need to print or export PDF data spanning on multiple pages and still allow the users to see the important information on the top/left side.

All WPF Components

Next Steps