Extract XLSX Metadata via .NET
Build your own .NET apps to add, edit, remove or extract metadata from XLSX files using server-side APIs.
How to Extract XLSX Metadata Using C#
In order to extract XLSX metadata, we’ll use
API which is a feature-rich, powerful and easy to use document metadata API for C# platform. Open
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 to Extract Metadata of XLSX via C#
Access useful information stored in the XLSX file including when the XLSX file was received, processed, time-stamped and so on.
- Load XLSX with an instance of Workbook
- Get the BuiltInDocumentProperties collection of Workbook object
- Iterate over the collection
- Display Property Name, Type & Value
System Requirements
Aspose.Cells for .NET is supported on all major operating systems. Just make sure that you have the following prerequisites.
- Microsoft Windows or a compatible OS with .NET Framework, .NET Core, Mono or Xamarin Platforms.
- Development environment like Microsoft Visual Studio.
- Add reference to the Aspose.Cells for .NET DLL in your project.
Extract Metadata of XLSX - C#
// load the XLSX with an instance of Workbook
var book = new Aspose.Cells.Workbook("template.xlsx");
// iterate over the BuiltInDocumentProperties collection
foreach (Aspose.Cells.Properties.DocumentProperty property in book.Worksheets.BuiltInDocumentProperties)
{
Console.WriteLine($"\tType:\t{property.Type}");
// Some properties may store multiple values
if (property.Value is Array)
{
foreach (object value in property.Value as Array)
Console.WriteLine($"\tValue:\t\"{value}\"");
}
else
{
Console.WriteLine($"\tValue:\t\"{property.Value}\"");
}
}
About Aspose.Cells for .NET API
Aspose.Cells API can be used to create, edit, convert and render Microsoft Excel formats to different formats. Moreover, it can be used for comprehensive charting, scalable reporting and reliable calculations within software applications. Aspose.Cells is a standalone API and it does not require any software like Microsoft or OpenOffice.Extract Metadata of XLSX via Online App
View & edit Metadata to XLSX documents by using our Live Demos with 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