The WpfSpreadsheetEditorControl control is a WPF control that allows to view and edit a spreadsheet (XLSX) document.

The WpfSpreadsheetEditorControl control allows to:

• Create a new or open an existing XLSX document
• Work with spreadsheet document
  • Set culture of spreadsheet document
  • Assign settings (author, etc) of spreadsheet document
  • Edit style properties of spreadsheet document
  • Add/delete defined names to/from spreadsheet document
• Work with worksheets of spreadsheet document
  • Get a list of worksheets
  • Add/delete/rename a worksheet; copy/insert a worksheet; reorder worksheets
• Work with worksheet of spreadsheet document
  • Render a worksheet
  • Change settings of worksheet view
  • Navigate by cells using mouse and keyboard
  • Insert or delete columns/rows
  • Change size of columns/rows
  • Show/hide columns/rows
  • Search and replace text
• Work with selected cells of worksheet
  • Select cells using mouse and keyboard
  • Insert, copy, paste and delete selected cells
  • Change style properties (font, fill, borders, number format, text style, alignment, indent, etc) of selected cells
  • Change size of selected cells
  • Auto-fit column width or row height of selected cells
  • Clear styles, content, hyperlinks of selected cells
  • Merge and unmerge selected cells
  • Show and hide selected cells
  • Set hyperlink to URL or location in document of selected cells
• Work with cell of worksheet
  • Display formatted and localized text of cell
  • Calculate formula of cell
  • Edit cell text directly in cell region
  • Edit cell text in formula bar
  • Highlight references while editing a cell formula
• Work with Drawing (Charts, Pictures, Graphics)
  • Render drawings on worksheet
  • Update a chart if chart data has changed
  • Select a drawing on worksheet
  • Add picture
  • Delete drawing
• Work with comments
  • Render comments on worksheet
  • Add, edit, delete a comment

If you want to use the WpfSpreadsheetEditorControl control in your WPF application, you need License for VintaSoft Office .NET Plug-in ("Reader+Writer" and "Spreadsheet Editor" edition).

Here is screenshot of VintaSoft WPF Spreadsheet Editor Demo that uses WpfSpreadsheetEditorControl control:


Source codes of VintaSoft WPF Spreadsheet Editor Demo can be found in installation of VintaSoft Imaging .NET SDK: "<SdkInstallPath>\VintaSoft\Imaging .NET 14.0\Examples\WPF\CSharp\WpfSpreadsheetEditorDemo\"