--- title: "Create, View, Edit, and Save Your Excel Files Using WPF Spreadsheet" published_at: "2021-08-10T10:00:21+00:00" modified_at: "2026-05-18T13:20:48+00:00" url: "https://www.syncfusion.com/blogs/post/create-view-edit-and-save-your-excel-files-using-wpf-spreadsheet" excerpt: "Spreadsheets are the heart of data analysis and storage. Almost everyone uses spreadsheets at some point, for personal use or for business. Our Syncfusion WPF Spreadsheet is an Excel-inspired control that allows you to create, view, edit, and format Microsoft..." taxonomy_category: - "Desktop" - "Excel" - "Spreadsheet" - "WPF" taxonomy_post_tag: - "Excel" - "productivity" - "Spreadsheet" - "WPF" --- # Create, View, Edit, and Save Your Excel Files Using WPF Spreadsheet [Nijamudeen](https://www.syncfusion.com/blogs/author/nijamudeensulaiman) ![Create, View, Edit and Save Your Excel Files Using WPF Spreadsheet](https://www.syncfusion.com/blogs/wp-content/uploads/2021/08/Create-View-Edit-and-Save-Your-Excel-Files-Using-WPF-Spreadsheet.png) Spreadsheets are the heart of data analysis and storage. Almost everyone uses spreadsheets at some point, for personal use or for business. Our Syncfusion [WPF Spreadsheet](https://www.syncfusion.com/spreadsheet-editor-sdk/wpf-spreadsheet-editor) is an Excel-inspired control that allows you to create, view, edit, and format [Microsoft Excel](https://en.wikipedia.org/wiki/Microsoft_Excel) files without having Microsoft Excel installed. It provides an integrated ribbon to cover any possible business scenario. In addition, this control supports a built-in calculation engine with more than 400 widely used formulas. It was built with the [.NET Excel Library](https://www.syncfusion.com/document-sdk/net-excel-library) (Essential XlsIO), which features a full-fledged object model similar to the Microsoft Office automation libraries. In this blog, I will explain how to create, read, and edit an Excel file using our Syncfusion WPF Spreadsheet control. **Note:** If you are new to our Spreadsheet control, then please read the [Getting Started with WPF Spreadsheet](https://help.syncfusion.com/wpf/spreadsheet/getting-started) documentation before proceeding. ## Create a simple Spreadsheet project The following steps illustrate how to create a simple Spreadsheet project in WPF: 1. First, open **Visual Studio** and select ** Create a New Project**. 2. Then, the New Project dialog will open. Choose **WPF Application** from the dropdown list and provide a name for your application. Refer to the following screenshot.![Create a New WPF Project](https://www.syncfusion.com/blogs/wp-content/uploads/2021/08/Create-a-new-WPF-project.png) Create a New WPF Project 3. Now, install the [Syncfusion.SfSpreadsheet.WPF](https://www.nuget.org/packages/Syncfusion.SfSpreadsheet.WPF/) NuGet package as a reference to your .NET Framework app from [Nuget.org](https://www.nuget.org/) .![Install the Syncfusion.SfSpreadsheet.WPF NuGet Package](https://www.syncfusion.com/blogs/wp-content/uploads/2021/08/Install-the-Syncfusion.SfSpreadsheet.WPF-NuGet-package.png) Install the Syncfusion.SfSpreadsheet.WPF NuGet Package The spreadsheet is available in the namespace **Syncfusion.UI.Xaml.Spreadsheet** and you can create it programmatically either by using the XAML or C# code. 1. Next, add the **SpreadsheetRibbon** and bind the Spreadsheet as the DataContext to the SpreadsheetRibbon to make an interaction between the ribbon items and Spreadsheet. 1. To add the SpreadsheetRibbon to your application, use the RibbonWindow since the backstage of the ribbon will open only when the ribbon is loaded under the RibbonWindow. Refer to the following code.``` ``` Now, we have created a simple WPF Spreadsheet project. ## Create a new Excel workbook You can create a new workbook by using the [Create](https://help.syncfusion.com/cr/wpf/Syncfusion.UI.Xaml.Spreadsheet.SfSpreadsheet.html#Syncfusion_UI_Xaml_Spreadsheet_SfSpreadsheet_Create_System_Int32_) method. By default, a workbook will be created with a single worksheet. Use the following code to load the Spreadsheet workbook with a specified number of worksheets. ``` spreadsheetControl.Create(2); ``` Also, you can add new worksheets on-demand in the WPF Spreadsheet control by clicking the **AddNew** button. Refer to the following screenshot. ![Creating an Excel Workbook Using WPF Spreadsheet](https://www.syncfusion.com/blogs/wp-content/uploads/2021/08/Creating-an-Excel-Workbook-Using-WPF-Spreadsheet.png) Creating an Excel Workbook Using WPF Spreadsheet ## View the existing Excel sheet The following code snippet illustrates how to view Excel files using the WPF Spreadsheet control. ``` /// View the Excel file. spreadsheetControl.Open (@"..\..\Data\GettingStarted.xlsx"); (or) ExcelEngine excelEngine = new ExcelEngine(); IWorkbook workbook = excelEngine.Excel.Workbooks.Open(@"..\..\Data\GettingStarted.xlsx"); spreadsheetControl.Open(workbook); (or) using (FileStream fileStream = new FileStream(@"..\..\Data\ GettingStarted.xlsx”, FileMode.Open)) { spreadsheetControl.Open(fileStream); } ``` Also, you can open the existing Excel files by clicking **Open** in the **SpreadsheetRibbon** backstage, like in the following screenshot. ![Opening an Existing Excel File Using WPF Spreadsheet](https://www.syncfusion.com/blogs/wp-content/uploads/2021/08/Opening-an-Existing-Excel-File-Using-WPF-Spreadsheet.png) Opening an Existing Excel File Using WPF Spreadsheet ## Edit the values in an Excel file The Spreadsheet provides support for editing, so you can modify and commit the cell values in a workbook. The following code snippet illustrates how to edit data in an Excel file using the WPF Spreadsheet control. ``` /// Editing a specific cell value. var range = spreadsheetControl.ActiveSheet.Range[2,2]; spreadsheetControl.ActiveGrid.SetCellValue(range, "Syncfusion"); spreadsheetControl.ActiveGrid.InvalidateCell(2,2); ``` Refer to the following screenshot. ![Editing the Cell Values in an Excel File Using WPF Spreadsheet](https://www.syncfusion.com/blogs/wp-content/uploads/2021/08/Editing-the-Cell-Values-in-an-Excel-File-Using-WPF-Spreadsheet.png) Editing the Cell Values in an Excel File Using WPF Spreadsheet ## Saving an Excel sheet You can save Excel workbooks using the Save() method. If the workbook already exists in the system drive, then it will be saved in the same location. Otherwise, the **Save** dialog box will open to let you save the workbook in a specified location. Refer to the following code snippet. ``` /// Save the changes made in the file. If the file is not created yet, then it prompts to enter the filename to save. spreadsheetControl.Save(); /// Save the changes made in the file using the SaveFileDialog. spreadsheetControl.SaveAs(); ``` Also, you can save the Excel files using **Save** or ** SaveAs** in the ribbon backstage. ![Saving an Excel File Using WPF Spreadsheet](https://www.syncfusion.com/blogs/wp-content/uploads/2021/08/Saving-an-Excel-File-Using-WPF-Spreadsheet.png) Saving an Excel File Using WPF Spreadsheet ## GitHub reference You can download the complete sample from [Create, View, Edit, and Save Excel Files Using WPF Spreadsheet demo](https://github.com/SyncfusionExamples/create-view-edit-excel-files-using-wpf-spreadsheet) . ## Conclusion Thanks for reading! In this blog post, we gave a quick overview of how to create, view, edit, and save Excel files using the Syncfusion [WPF Spreadsheet](https://www.syncfusion.com/spreadsheet-editor-sdk/wpf-spreadsheet-editor) control. This control also supports hyperlinks, bookmarks, encryption, localization, cell formatting, and more. Try out these versatile features and share your feedback in the comments section of this blog post! The Spreadsheet control is also available in our ASP.NET ([Core](https://www.syncfusion.com/aspnet-core-ui-controls/spreadsheet) , [MVC](https://www.syncfusion.com/aspnet-mvc-ui-controls/spreadsheet) , [Web Forms](https://www.syncfusion.com/jquery/aspnet-web-forms-ui-controls) ), [JavaScript](https://www.syncfusion.com/javascript-ui-controls/js-spreadsheet) , [Angular](https://www.syncfusion.com/angular-ui-components) , [React](https://www.syncfusion.com/react-ui-components/react-spreadsheet) , [Vue](https://www.syncfusion.com/vue-ui-components/vue-spreadsheet) , [UWP](https://www.syncfusion.com/uwp-ui-controls/spreadsheet) , [WinForms](https://www.syncfusion.com/winforms-ui-controls/spreadsheet) , and [WPF](https://www.syncfusion.com/wpf-controls/spreadsheet) platforms. If you are an existing Syncfusion user, please download the latest version from the [License and Downloads](https://www.syncfusion.com/account/downloads) page and try the new features for yourself. Also, our NuGet packages are available on [NuGet.org](https://www.nuget.org/) . If you aren’t a customer yet, you can try our 30-day [free trial](https://www.syncfusion.com/downloads) to check out these features. Also, try our other demos from this [GitHub](https://github.com/SyncfusionExamples) repository. You can also contact us through our [support forums](https://www.syncfusion.com/forums) , [Direct-Trac](https://www.syncfusion.com/support/directtrac/incidents) , or [feedback portal](https://www.syncfusion.com/feedback/) . We are always happy to assist you! ## Related blogs - [How to Interact with the WPF Scheduler Using a Keyboard](https://www.syncfusion.com/blogs/post/how-to-interact-with-the-wpf-scheduler-using-a-keyboard.aspx) - [Enjoy 30+ New, Elegant Palettes in WPF Theme Studio](https://www.syncfusion.com/blogs/post/enjoy-30-new-elegant-palettes-in-wpf-theme-studio.aspx) - [Add, Edit, and Delete Cloud Shapes in PDF Files with Ease in WPF](https://www.syncfusion.com/blogs/post/add-edit-delete-cloud-shapes-in-pdf-files-wpf.aspx) - [Simple Steps to Design a Temperature Monitor Using WPF Radial Gauge](https://www.syncfusion.com/blogs/post/design-a-temperature-monitor-using-wpf-radial-gauge.aspx)