UWP Spreadsheet (SfSpreadsheet) Overview

23 Jul 20263 minutes to read

The Syncfusion® UWP Spreadsheet (SfSpreadsheet) is an Excel-inspired control that allows you to create, edit, view, and format Microsoft Excel files without Excel installed. It provides an easy-to-use UI experience with an integrated ribbon to cover common business scenarios. SfSpreadsheet comes with a built-in calculation engine that supports 400+ widely used formulas.

Key Features

UWP Spreadsheet includes several advanced features like

  • Ribbon – Provides a ribbon with an enhanced UI experience.

  • Editing and Selection – Provides interactive support for editing and cell selection in a workbook.

  • Formulas - Provides support for 400+ widely used formulas and allows you to add, remove, and edit formulas as in Excel.

  • Name Manager – Supports named ranges in formulas. By using a named range, you can refer to a cell range by name and use it in formulas without the hassle of remembering cell locations.

  • Floating Cells - Provides support for floating cell mode, in which text that exceeds the cell width floats into the adjacent cell.

  • Merge Cells - Provides support to merge two or more adjacent cells into a single cell and display the contents of one cell in the merged cell.

  • Conditional Formatting - Provides support for Excel-compatible conditional formatting and allows you to apply formats to a cell or range of cells based on the value of cells or formulas that meet specific criteria. Also provides support to define and import conditional formatting rules such as Data Bars, Icon Sets, and Color Scales, which are used to visualize the data.

  • Data Validation – Provides support to ensure data integrity by enforcing end users to enter valid data into cells. If the entered data does not meet the specified criteria, an error message is displayed.

  • Cell Comments - Supports comments that provide additional information about a cell, such as what the value represents. This is useful for giving end users additional context about the data.

  • Undo/Redo - Provides support to undo or redo the changes made in the workbook.

  • Clipboard Operations – Provides support for Cut, Copy, and Paste operations in the Spreadsheet.

  • Fill Series – Provides support to automatically fill cells with data that follows or completes a pattern.

  • Charts, Pictures, and Textboxes - Provides support to import Charts, Pictures, and Textboxes.

  • Sparklines – Provides support to import sparklines.

  • Hyperlinks - Supports hyperlink navigation. A hyperlink is a convenient way to navigate or browse data within a worksheet or to other worksheets in a workbook.

  • Freeze Panes – Provides support to freeze rows and columns.

  • Resizing and Hiding – Provides interactive support to resize and hide or unhide rows and columns.

  • Grouping - Provides support to group and ungroup rows and columns.

  • Workbook and Worksheet Protection - Provides support to protect the worksheet and supports locking down the structure and window of the workbook, preventing structural changes or changes in size.

  • Import – Provides support to import from excel file.

  • Zooming – Provides support to zoom in and zoom out of the worksheet view.

  • Localization - Provides support to localize all static text in the Ribbon and all dialogs to any desired language.

  • Supported File Types - Ability to import the different types of excel which are XLS, XLSX, XLSM, XLT, XLTX, CSV (Comma delimited) respectively.