For a developer, who is trying to update XLTX files via .NET application. Aspose.Total for .NET API can help to automate the updating process. It’s a full package of various .NET APIs dealing different formats including Microsoft Excel files. Aspose.Cells for .NET API that is part of Aspose.Total for .NET package makes this modifying process easy. Below is the process of updating the XLTX document.
How to Update XLTX File in .NET
- Create new Workbook class object having the source XLTX file as parameter
- Access of relevant Worksheet and relevant cell using Worksheets[0].Cells[column] method
- Insert new data in the accessed cell using PutValue(data) method
- Save the file as .xltx file using save() method by passing the file with path as the parameter
Modification Requirements
- For XLTX modification, Microsoft Windows or a compatible OS with .NET, .NET Core, Mono or Xamarin Platforms
- Development environment like Microsoft Visual Studio
- Install from command line as
nuget install Aspose.Cells
or via Package Manager Console of Visual Studio withInstall-Package Aspose.Cells
- Alternatively, get the offline MSI installer or all DLLs in a ZIP file from Downloads
Code - Update XLTX File in .NET
Explore File Editor Options with .NET
Edit CSV
(Comma Seperated Values)
Edit TSV
(Tab-separated Values)
Edit XLS
(Microsoft Excel Binary Format)
Edit XLSB
(Excel Binary Workbook)
Edit XLSM
(Macro-enabled Spreadsheet)
Edit XLSX
(Open XML Workbook)
Edit XLT
(Excel 97 - 2003 Template)
Edit XLTM
(Excel Macro-Enabled Template)
Edit XLTX
(Excel Template)