DevExpress.Wpf.Spreadsheet 26.1.6

Skip to content DevExpress dxvcs Repository navigation Code Issues 3.8k (3.8k) Pull requests 257 (257) Agents Actions Projects Security and quality 123 (123) Insights Settings Files Go to file t T .claude .github .optimized-index AI ASP Bin Blazor Builds.2005 CLI DB.Standard Demos.ASP Demos.Blazor Demos.Dashboard Demos.DevExtreme Demos.Java Demos.Office Demos.RealLife Demos.Win Demos.XPF DevExpress.Key DevExtreme Java Localization NuGet DevExpress.AIIntegration.Agents DevExpress.AIIntegration.AspNetCore.Reporting DevExpress.AIIntegration.Azure.TextAnalytics DevExpress.AIIntegration.Azure.Translation DevExpress.AIIntegration.Blazor.Chat.WebView DevExpress.AIIntegration.Blazor.Chat DevExpress.AIIntegration.Blazor.Common DevExpress.AIIntegration.Blazor.Editors DevExpress.AIIntegration.Blazor.HtmlEditor DevExpress.AIIntegration.Blazor.Layout DevExpress.AIIntegration.Blazor.Reporting.Viewer DevExpress.AIIntegration.Blazor.RichEdit DevExpress.AIIntegration.Blazor DevExpress.AIIntegration.Desktop DevExpress.AIIntegration.Docs DevExpress.AIIntegration.Printing DevExpress.AIIntegration.Reporting.Common DevExpress.AIIntegration.SemanticSearch DevExpress.AIIntegration.Web.Reporting.Common DevExpress.AIIntegration.Web DevExpress.AIIntegration.WinForms.Chat DevExpress.AIIntegration.WinForms.Reporting DevExpress.AIIntegration.WinForms.SemanticSearch DevExpress.AIIntegration.WinForms DevExpress.AIIntegration.Wpf.Chat DevExpress.AIIntegration.Wpf.Reporting DevExpress.AIIntegration.Wpf DevExpress.AIIntegration DevExpress.AspNetCore.Common DevExpress.AspNetCore.Core DevExpress.AspNetCore.Dashboard DevExpress.AspNetCore.Reporting.Azure DevExpress.AspNetCore.Reporting DevExpress.AspNetCore.RichEdit DevExpress.AspNetCore.Spreadsheet DevExpress.Aspire.AspNetCore.Reporting DevExpress.Aspire.Reporting DevExpress.Blazor.Dashboard DevExpress.Blazor.PdfViewer DevExpress.Blazor.PivotTable DevExpress.Blazor.Reporting.JSBasedControls.BlazorServer DevExpress.Blazor.Reporting.JSBasedControls.Common DevExpress.Blazor.Reporting.JSBasedControls.WebAssembly DevExpress.Blazor.Reporting.JSBasedControls DevExpress.Blazor.Reporting.Viewer DevExpress.Blazor.Reporting DevExpress.Blazor.Resources DevExpress.Blazor.RichEdit DevExpress.Blazor.Themes.Fluent DevExpress.Blazor.Themes DevExpress.Blazor.Viewer DevExpress.Blazor DevExpress.Charts.Core DevExpress.Charts DevExpress.CodeParser DevExpress.Dashboard.Core DevExpress.Data.Desktop DevExpress.Data DevExpress.DataAccess.UI DevExpress.DataAccess DevExpress.DataVisualization.Core DevExpress.Demos.Core DevExpress.Diagram.Core DevExpress.Docs.Barcode DevExpress.Docs.Core DevExpress.Docs.Ocr DevExpress.Docs.Pdf DevExpress.Docs.Presentation DevExpress.Docs.Spreadsheet DevExpress.Document.Processor DevExpress.Drawing DevExpress.Gauges.Core DevExpress.Images.Blazor DevExpress.Images DevExpress.Map.Core DevExpress.Mvvm.CodeGenerators DevExpress.Mvvm DevExpress.Office.Core DevExpress.Pdf.Core DevExpress.Pdf.Drawing DevExpress.Pdf.SkiaRenderer DevExpress.PivotGrid.Core DevExpress.Reporting.CodeCompletion DevExpress.Reporting.Core DevExpress.Reporting.Demos DevExpress.Reporting.Rider.Design DevExpress.Reporting.WCF DevExpress.RichEdit.Core DevExpress.RichEdit.Export DevExpress.Scaffolding.Core DevExpress.Scaffolding.EF6 DevExpress.Scaffolding.EFCore DevExpress.Scheduler.Core.Desktop.Microsoft365Calendar DevExpress.Scheduler.Core DevExpress.Scheduler.CoreDesktop DevExpress.Sparkline.Core DevExpress.SpellChecker.Core DevExpress.Spreadsheet.Core readme.md DevExpress.TreeMap.Core DevExpress.TreeMap DevExpress.Utils.UI DevExpress.Utils DevExpress.Web.Bootstrap DevExpress.Web.Dashboard.Common DevExpress.Web.Dashboard DevExpress.Web.Mvc.Dashboard DevExpress.Web.Mvc DevExpress.Web.Mvc5.Dashboard DevExpress.Web.Mvc5 DevExpress.Web.Office DevExpress.Web.Reporting.Azure DevExpress.Web.Reporting.Common.Services DevExpress.Web.Reporting.Common DevExpress.Web.Reporting DevExpress.Web.Resources DevExpress.Web.Scheduler DevExpress.Web.Themes DevExpress.Web.Visualization DevExpress.Web DevExpress.Win.BonusSkins DevExpress.Win.Charts DevExpress.Win.CodeAnalysis DevExpress.Win.Dashboard.Design DevExpress.Win.Dashboard DevExpress.Win.Demos DevExpress.Win.Design DevExpress.Win.Diagram DevExpress.Win.Dialogs.Core DevExpress.Win.Dialogs DevExpress.Win.Gantt DevExpress.Win.Gauges DevExpress.Win.Grid DevExpress.Win.Map DevExpress.Win.Navigation DevExpress.Win.PdfViewer DevExpress.Win.PivotGrid DevExpress.Win.Printing DevExpress.Win.Reporting DevExpress.Win.RichEdit DevExpress.Win.Scheduler.GoogleCalendar DevExpress.Win.Scheduler DevExpress.Win.SchedulerExtensions DevExpress.Win.SchedulerReporting DevExpress.Win.SpellChecker DevExpress.Win.Spreadsheet DevExpress.Win.TreeList DevExpress.Win.TreeMap DevExpress.Win.VerticalGrid DevExpress.Win DevExpress.WindowsDesktop.ProjectTemplates DevExpress.WindowsDesktop.WpF DevExpress.Wpf.Accordion DevExpress.Wpf.Carousel DevExpress.Wpf.Charts DevExpress.Wpf.Controls DevExpress.Wpf.Core.Extensions DevExpress.Wpf.Core DevExpress.Wpf.Dashboard DevExpress.Wpf.Demos DevExpress.Wpf.Diagram DevExpress.Wpf.Dialogs DevExpress.Wpf.Docking DevExpress.Wpf.DocumentViewer.Core DevExpress.Wpf.ExpressionEditor DevExpress.Wpf.Gantt DevExpress.Wpf.Gauges DevExpress.Wpf.Grid.Core DevExpress.Wpf.Grid.Printing DevExpress.Wpf.Grid DevExpress.Wpf.LayoutControl DevExpress.Wpf.Map DevExpress.Wpf.NavBar DevExpress.Wpf.Office readme.md DevExpress.Wpf.PdfViewer DevExpress.Wpf.PivotGrid DevExpress.Wpf.Printing DevExpress.Wpf.PrismAdapters DevExpress.Wpf.ProjectTemplates DevExpress.Wpf.PropertyGrid DevExpress.Wpf.Reporting DevExpress.Wpf.Ribbon DevExpress.Wpf.RichEdit DevExpress.Wpf.Scheduler DevExpress.Wpf.Scheduling DevExpress.Wpf.SchedulingReporting DevExpress.Wpf.SpellChecker readme.md DevExpress.Wpf.Spreadsheet readme.md DevExpress.Wpf.Themes.All DevExpress.Wpf.Themes.DXStyle DevExpress.Wpf.Themes.LightGray DevExpress.Wpf.Themes.MetropolisDark DevExpress.Wpf.Themes.MetropolisLight DevExpress.Wpf.Themes.Office2007Black DevExpress.Wpf.Themes.Office2007Blue DevExpress.Wpf.Themes.Office2007Silver DevExpress.Wpf.Themes.Office2010Black DevExpress.Wpf.Themes.Office2010Blue DevExpress.Wpf.Themes.Office2010Silver DevExpress.Wpf.Themes.Office2013 DevExpress.Wpf.Themes.Office2013DarkGray DevExpress.Wpf.Themes.Office2013LightGray DevExpress.Wpf.Themes.Office2016Black DevExpress.Wpf.Themes.Office2016BlackSE DevExpress.Wpf.Themes.Office2016Colorful DevExpress.Wpf.Themes.Office2016ColorfulSE DevExpress.Wpf.Themes.Office2016DarkGraySE DevExpress.Wpf.Themes.Office2016White DevExpress.Wpf.Themes.Office2016WhiteSE DevExpress.Wpf.Themes.Office2019Black DevExpress.Wpf.Themes.Office2019Colorful DevExpress.Wpf.Themes.Office2019DarkGray DevExpress.Wpf.Themes.Office2019HighContrast DevExpress.Wpf.Themes.Office2019White DevExpress.Wpf.Themes.Seven DevExpress.Wpf.Themes.TouchlineDark DevExpress.Wpf.Themes.VS2010 DevExpress.Wpf.Themes.VS2017Blue DevExpress.Wpf.Themes.VS2017Dark DevExpress.Wpf.Themes.VS2017Light DevExpress.Wpf.Themes.VS2019Blue DevExpress.Wpf.Themes.VS2019Dark DevExpress.Wpf.Themes.VS2019Light DevExpress.Wpf.Themes.Win10Dark DevExpress.Wpf.Themes.Win10Light DevExpress.Wpf.Themes.Win11Dark DevExpress.Wpf.Themes.Win11Light DevExpress.Wpf.ThemesLW DevExpress.Wpf.TreeMap DevExpress.Wpf.TypedStyles DevExpress.Wpf DevExtreme.AspNet.Core DevExtreme.AspNet.Mvc Tools Readme.md packages.ai.core.config packages.ai.desktop.config packages.ai.web.config packages.asp.config packages.aspire.config packages.blazor.config packages.blazor.richedit.config packages.config packages.core.config packages.devextreme.asp.config packages.testbuild.config packages.win.config packages.win.dashboard.netcore.config packages.win.netcore.config packages.winui.config packages.wpf.config packages.xaf.config packages.xaf.shared.config SAST TestInstall Tests.Dashboard Tests.DataAccess Tests.Win Tools Win XAF XPF npm .dx-meta.json .editorconfig .gitattributes .gitignore .issuetracker .pre-commit-config.yaml .pre-commit-ignore AssemblyVersion.cs CLAUDE.md Directory.Build.targets Directory.Packages.props NuGet.Config build.py buildnetcore.py createlocalsource.py cs2j-buildxl.sh cs2j.sh dxgitlib.py dxupdate.py label.txt publish.txt remove-obj-folders.py dxvcs/NuGet/DevExpress.Wpf.Spreadsheet / readme.md in main

Edit

Preview Indent mode

Spaces Indent size

4 Line wrap mode

Soft wrap Editing readme.md file contents

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75

DevExpress WPF Spreadsheet Control

The DevExpress.Wpf.Spreadsheet package includes the SpreadsheetControl, an Excel-inspired control for WPF applications that lets you create, view, edit, print, and convert workbooks.

SpreadsheetControl supports XLS, XLSX, XLSM, XLSB, BIFF5, XLT, XLTX, XLTM, CSV, and TXT formats, and includes formulas, pivot tables, charts, and other advanced Excel capabilities.

Key Features

• 400+ Excel Formulas and Functions: Build formulas with array formula support, high-precision, multithreaded calculations, and RTD (Real-Time Data) support. Create your own custom functions.
• Data Visualization: Embed pivot tables, 2D/3D charts (column, bar, line, pie, scatter, radar, stock), and sparklines (Line, Column, Win/Loss).
• Conditional Formatting and Styles: Highlight cells with data bars, icons, and color scales; apply predefined cell styles through the Ribbon UI.
• Data Editing and Validation: AutoFill, formula bar, cut, copy, paste, Paste Special, undo and redo, invalid value highlighting, and custom in-place editors.
• Data Editing and Validation: AutoFill, formula bar, cut, copy, paste, Paste Special, undo and redo, invalid value highlighting, and custom in-place editors.
• Printing and Export: Preview, print, and export workbooks or individual worksheets to PDF and HTML.
• Document Protection: Password encryption, workbook/worksheet/range protection, and per-range access restrictions.
• MVVM Support: Bind workbook content and commands using the MVVM pattern.

Examples

Add a SpreadsheetControl

<Window
    x:Class="SpreadsheetSample.MainWindow"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    xmlns:dxsp="http://schemas.devexpress.com/winfx/2008/xaml/spreadsheet">
    <Grid>
        <dxsp:SpreadsheetControl x:Name="spreadsheetControl"

                                CommandBarStyle="Ribbon"

                                ShowStatusBar="True"

                                ShowFormulaBar="True"/>

    </Grid>
</Window>

Load and Save a Workbook

<Grid>
    <dxsps:SpreadsheetControl CommandBarStyle="Ribbon"
                              ShowStatusBar="True"
                              ShowFormulaBar="True"
                              DocumentSource="pack://application:,,,/WpfSpreadsheet;component/Document.xlsx"/>
</Grid>

using DevExpress.Spreadsheet;

// Load a workbook.
spreadsheetControl.LoadDocument("Document.xlsx", DocumentFormat.Xlsx);

// Save the workbook to a different format.
using (FileStream pdfFileStream = new FileStream("Documents\\Document_PDF.pdf", FileMode.Create)) {
    workbook.ExportToPdf(pdfFileStream);
}

Create a Formula

Worksheet worksheet = spreadsheetControl.Document.Worksheets[0];
worksheet.Cells["A1"].Value = 10;
worksheet.Cells["A2"].Value = 20;
worksheet.Cells["A3"].Formula = "=SUM(A1:A2)";

Evaluation Period, Pricing Options, and Licensing Terms

Whether you own a license or want to start a 30-day evaluation period, register your DevExpress license key. To obtain your key, log in to the DevExpress Download Manager. Use your existing DevExpress.com account or create a new account for free. For additional registration instructions, see License Key for DevExpress Products. Use Control + Shift + m to toggle the tab key moving focus. Alternatively, use esc then tab to move to the next interactive element on the page. No file chosen Attach files by dragging & dropping, selecting or pasting them.