Edit XLSX Formats in C#
Native and high performance XLSX document editing using server-side Aspose.Cells for .NET APIs, without the use of any software like Microsoft or Adobe PDF.
How to Edit XLSX File Using C#
In order to edit XLSX file, we’ll use Aspose.Cells for .NET API which is a feature-rich, powerful and easy to use API for C# platform for any editor. Open NuGet package manager, search for Aspose.Cells and install. You may also use the following command from the Package Manager Console.
Command
PM> Install-Package Aspose.Cells
Steps for Editing XLSX Files in C#
A basic document editing with Aspose.Cells for .NET APIs can be done with just few lines of code.
- Include the namespace in your class file
- Load your sample file.
- Add and access the new worksheet of the workbook.
- Get the desired cell(s) of the worksheet and put the value in the cell(s).
- Insert PivotTable and set the style
- Use Save method to save the workbook as XLSX file.
System Requirements
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 on your system.
- Microsoft Windows or a compatible OS with .NET Framework, .NET Core, Windows Azure, Mono or Xamarin Platforms
- Development environment like Microsoft Visual Studio
- Add reference to the Aspose.Cells for .NET DLL in your project - Install from NuGet using the Download button above
Edit XLSX Files - C#
Online XLSX Editor Live Demos
Edit XLSX documents right now by visiting our Live Demos website . The live demo has the following benefits
XLSX What is XLSX File Format?
XLSX is well-known format for Microsoft Excel documents that was introduced by Microsoft with the release of Microsoft Office 2007. Based on structure organized according to the Open Packaging Conventions as outlined in Part 2 of the OOXML standard ECMA-376, the new format is a zip package that contains a number of XML files. The underlying structure and files can be examined by simply unzipping the .xlsx file.
Read More