About Syncfusion Blazor Spreadsheet Control
23 Sep 20262 minutes to read
The Blazor Spreadsheet Editor is a user-interactive component designed to organize and analyze data in a tabular format with configuration options for customization. It will load data by importing an Excel file or from local file paths and Base64 string data. The populated data can be exported as Excel with xlsx, xls, CSV and PDF formats.
Key features
- Selection: Flexible selection of cells, rows, columns, and ranges using mouse and keyboard
- Editing: Familiar Excel-like experience for faster productivity with seamless in-cell and formula bar input
- Formulas: Advanced calculation engine with built-in functions and named ranges
- Clipboard: Powerful cut, copy, and paste with cross-platform compatibility (Excel, Google Sheets)
- Cell formatting: Rich cell formatting options including fonts, colors, borders, alignment, and styling
- Number formatting: Provides the option to format the cell value.
- Open and save: Seamless support for Excel files (.xlsx, .xls) with local and Base64 operations
- Sorting: Efficient data sorting in ascending and descending order for quick organization
- Filtering: Advanced filtering with support for text, numbers, dates, and custom condition
- Undo Redo: Fast error correction with history tracking up to 25 actions
- Hyperlink: Easy navigation across web URLs and worksheets
- Worksheet management: Complete worksheet management including insert, delete, rename, move, duplicate, and hide/unhide
- Wrap text: Provides the option to display the large content as multiple lines in a single cell.
- Data validation: Provides the option to validate edited values based on data validation rules defined for a cell or range of cells.
- Find and replace: Provides the option to find the data and replace it across all sheets in Spreadsheet.
- Protection: Robust workbook and sheet protection with password, permissions, and selective locking
- Borders: Provides the option to customize cell gridlines such as color and its style for enhanced UI.
- Show/hide: Provides the option to show/hide sheets.
- Insert: Provides the option to insert rows and columns.
- Merge cells: Provides the option to combine two or more cells located in the same row or column into a single cell.
- Conditional formatting: Provides the option to format a cell or range of cells based on conditions applied.
- Autofill: Provides the option to fill or copy a series or pattern of values and formats into adjacent cells in any direction.
- Clear: Provides the option to clear the content, formats, and hyperlinks applied to a cell or range of cells in a Spreadsheet.
- Aggregates: Provides the option to check the sum, average, count, and more for the selected cells or range in the sheet.
- Picture: Allows you to view, insert, and modify a picture in a Spreadsheet with customizing options.
- Chart: Transforms your Spreadsheet data to an intuitive overview for better understanding and to make smart business decisions.
- Password protection: Allows you to protect the workbook with a password.
- Cell range: Boost efficiency with auto-fill, wrap text, and quick content clearing
- Context Menu: Speed up workflows with instant access to key actions via smart menus
- Accessibility: Built-in accessibility support including keyboard navigation, ARIA attributes, and screen reader