View or Update XLSM Metadata Online or Update via .NET
Develop powerful .NET based XLSM document metadata management utility application. Code listed for adding and modifying XLSM file metadata through .NET.
View or Update XLSM Metadata Online
- Import XLSM file by uploading it.
- Do it by clicking inside the drop area via drag and drop of metadata app.
- Depending on the size of XLSM file and internet speed wait for few seconds.
- Same page will display metadata.
- Edit the properties as of your choice.
- Save the document.
- Download the file instantly.
Manage XLSM Properties via .NET
- Create Workbook class.
- Access system defined properties using BuiltInDocumentProperties
- Assign updated values such as Language
- Call the Save() method to save the updated XLSM document.
.NET Code: Update XLSM Metadata
//Create workbook object. | |
Workbook wb = new Workbook(); | |
//Access system defined document property collection. | |
Aspose.Cells.Properties.BuiltInDocumentPropertyCollection sdmd = wb.BuiltInDocumentProperties; | |
//Set the language of the Excel document. | |
sdmd.Language = "German, French"; | |
//Save the workbook in xlsx format. | |
wb.Save(outputDir + "system-defined-properties-updated.xlsx", SaveFormat.Xlsx); |
.NET Code: Add XLSM Custom Properties
// string dataDir = "he path to the documents directory." | |
// Instantiate a Workbook object | |
// Open an Excel file | |
Workbook wkb = new Workbook(dataDir + "sample-document-properties.xlsx"); | |
// Retrieve a list of all custom document properties of the Excel file | |
Aspose.Cells.Properties.CustomDocumentPropertyCollection customProperties = wkb.Worksheets.CustomDocumentProperties; | |
// Adding a custom document property to the Excel file | |
Aspose.Cells.Properties.DocumentProperty publisher = customProperties.Add("Publisher", "Aspose"); | |
// Add link to content. | |
customProperties.AddLinkToContent("Owner", "MyRange"); | |
// way to access custom property by using the property name | |
Aspose.Cells.Properties.DocumentProperty customProperty1 = customProperties["Owner"]; | |
// Saving resultant spreadsheet | |
wkb.Save(dataDir + "out_sample-document-properties.xlsx"); |
Develop XLSM Metadata Management Application via .NET
Need to develop a XLSM Metadata management app or utility? With
Aspose.Cells for .NET
a child API of
Aspose.Total for .NET
, any .NET developer can integrate the above API code within its document metadata application. Powerful .NET library allows programming any document metadata solution. Moreover it can support many popular formats including XLSM format.
.NET Utility to Manage XLSM Metadata
There are three alternative options to install “Aspose.Cells for .NET” or “Aspose.Total for .NET” onto your system. Please choose one that resembles your needs and follow the step-by-step instructions:
- Install a NuGet Package . See Documentation
- Install the library using Package Manager Console within Visual Studio IDE
- Install the library by hand using Windows Installer
System Requirements
Our product is fully cross-platform and supports all major .NET implementations following ‘.NET Standard 2.0’ specification:
- Microsoft .NET Framework, starting from the earliest 2.0 version, and ending with the latest ‘.NET Framework 4.8’
- .NET Core, starting from the earliest 2.0, and ending with the latest ‘.NET 6’
- Mono >= 2.6.7
As .NET code doesn’t rely on the underlying hardware or operating system, but only on a Virtual Machine, so you are free to develop any kind of software for Windows, macOS, Android, iOS and Linux. Just make sure you have installed the corresponding version of .NET Framework, .NET Core, Windows Azure, Mono or Xamarin.
We recommend using Microsoft Visual Studio, Xamarin, and MonoDevelop IDE to create C#, F#, VB.NET applications.
For more details please refer to Product Documentation .
FAQs
- Can I use above .NET code in my application?Yes, you are welcome to download this code and utilize it for the purpose of developing .NET-based document metadata application. This code can serve as a valuable resource to enhance the functionality and capabilities of your projects in the domain of backend document processing and manipulation.
- Is this online document metadata app work only on Windows?You have the flexibility to initiate document metadata management at any device, irrespective of the operating system it runs on, whether it be Windows, Linux, Mac OS, or Android. All that's required is a contemporary web browser and an active internet connection.
- Is it safe to use the online app to manage XLSM document properties?Of course! The output files generated through our service will be securely and automatically removed from our servers within a 24-hour timeframe. As a result, the display links associated with these files will cease to be functional after this period.
- What browser should to use App?You can use any modern web browser like Google Chrome, Firefox, Opera, or Safari for online XLSM document properties management. However, if you're developing a desktop application, we recommend using the Aspose.Total document processing API for efficient management.