Steps to Edit XLSM in C#

GroupDocs.Editor for .NET provides an easy and straightforward way for developers to edit the XLSM files using a few lines of code.

Create an instance of Editor class with mandatory file path or stream and optional SpreadsheetLoadOptions class and load the XLSM file
Create & set the SpreadsheetEditOptions class instance for the XLSM file format
Call Editor.Edit() method and obtain XLSM document in HTML format that is easily editable with any WYSIWYG-editor.
Call Editor.Save() method and save edited XLSM file using SpreadsheetSaveOptions class

System Requirements

A basic document editing with GroupDocs.Editor for .NET APIs can be done by implementing a few easy steps. Our APIs are supported on all major platforms and operating systems. Before executing the code below, please make sure that you have the following prerequisites installed on your system.

Operating Systems: Microsoft Windows, Linux, MacOS
Development Environments: Microsoft Visual Studio, Xamarin, MonoDevelop
Frameworks: .NET Framework, .NET Standard, .NET Core, Mono
Get the latest version of GroupDocs.Editor for .NET downloaded from NuGet

// Load the XLSM file into Editor with the optional SpreadsheetLoadOptions
Editor editor = new Editor("source.xlsm", delegate { return new SpreadsheetLoadOptions(); });

// Create and adjust the edit options
SpreadsheetEditOptions editOptions = new SpreadsheetEditOptions();
editOptions.WorksheetIndex = 1;//select a tab (worksheet) to edit

// Open input XLSM document for edit — obtain an intermediate document, that can be edited
EditableDocument beforeEdit = editor.Edit(editOptions);

// Grab XLSM document content and associated resources from editable document
string content = beforeEdit.GetContent();

// Send the content to WYSIWYG-editor, edit it there, and send edited content back to the server-side
// This step simulates a such operation
string updatedContent = content.Replace("Cell Text", "Edited Cell Text");

// Grab edited content and resources from WYSIWYG-editor and create a new EditableDocument instance from it
EditableDocument afterEdit = EditableDocument.FromMarkup(updatedContent, null);

// Create a save options and select a desired output format
SpreadsheetSaveOptions saveOptions = new SpreadsheetSaveOptions(Formats.SpreadsheetFormats.Xlsm);

// Save edited XLSM document to the file
editor.Save(afterEdit, "edited.xlsm", saveOptions);