Extract Metadata From XLSM File In C#

Read & Extract metadata information from a wide range of documents, images, audio & video formats using GroupDocs.Metadata for .NET

Download Free Trial

About GroupDocs.Metadata for .NET API

GroupDocs.Metadata for .NET offers an advanced set of metadata management and manipulation features, allowing developers to easily read, edit, remove, search, compare, replace and export metadata information from images and document formats without using any external software. Extract metadata details from PDF, Word, Excel, PowerPoint, Outlook, OneNote, Visio, Project, AutoCAD, Archive and Multimedia file formats, and perform supported metadata operations with true flexibility.

Steps for XLSM Metadata Extraction in C#

GroupDocs.Metadata for .NET makes it easy for .NET developers to extract to read and extract metadata information from XLSM files from within their applications by implementing a few easy steps.

  • Load the XLSM with an instance of Metadata class.
  • Make up a predicate to examine all metadata properties.
  • Pass the predicate to the FindProperties method.
  • Iterate through the found properties.

System Requirements

GroupDocs.Metadata for .NET 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: Visual Studio, Xamarin, MonoDevelop
  • Frameworks: .NET Framework, .NET Standard, .NET Core, Mono
  • Download the latest version of GroupDocs.Metadata for .NET from NuGet

using (var metadata = new GroupDocs.Metadata.Metadata("input.xlsm"))
    // extract all metadata properties that fall into a particular category
    var properties = metadata.FindProperties(
      p => p.Tags.Any(t => t.Category == GroupDocs.Metadata.Tagging.Tags.Content));
    // iterate over all properties and display
    foreach (var property in properties)
        Console.WriteLine("{0} = {1}", property.Name, property.Value);

    // extract all properties having a specific type and value
    var year = DateTime.Today.Year;
    properties = metadata.FindProperties(
      p => p.Value.Type == GroupDocs.Metadata.Common.MetadataPropertyType.DateTime && 
      p.Value.ToStruct(DateTime.MinValue).Year == year);

    // display all datetime properties with the year value equal to the current year
    foreach (var property in properties)
        Console.WriteLine("{0} = {1}", property.Name, property.Value);

    // extract all properties having names matching the specified regex
    const string pattern = "^author|company|(.+date.*)$";
    var regex = new System.Text.RegularExpressions.Regex(pattern, 
    properties = metadata.FindProperties(p => regex.IsMatch(p.Name));

    // display properties whose names match the following pattern
    foreach (var property in properties)
        Console.WriteLine("{0} = {1}", property.Name, property.Value);

Metadata Extraction Live Demos

Retrieve metadata information of XLSM file right now by visiting GroupDocs.Metadata Live Demos website. The live demo has the following benefits.

No need to download API

No need to write any code

Just upload the source file

Get download link to save the file

Reading & Extracting Other File Formats

Multi format documents and images metadata extraction API for .NET. Retrieve metadata of some of the popular file formats as stated below.

Extract XLTX Metadata

(Excel Template)

Extract XLTM Metadata

(Excel Macro-Enabled Template)

Extract XLT Metadata

(Excel 97 - 2003 Template)

Extract XLSX Metadata

(Open XML Workbook)

Extract XLSB Metadata

(Excel Binary Workbook)

Extract XLS Metadata

(Microsoft Excel Spreadsheet (Legacy))

Extract WMF Metadata

(Windows Metafile)

Extract WEBP Metadata

(Raster Web Image Format)

Extract WAV Metadata

(WAVE Audio File)

Extract VSX Metadata

(Visio Stencil XML File)

Extract VSS Metadata

(Visio Stencil File)

Extract VSDX Metadata

(Visio Drawing)

Extract VSD Metadata

(Visio Drawing File)

Extract VDX Metadata

(The 7th Guest Video File)

Extract TTF Metadata

(TrueType Font)

Extract TTC Metadata

(TrueType Font Collection)

Extract TIFF Metadata

(Tagged Image File Format)

Extract PSD Metadata

(Photoshop Document)

Extract PPTX Metadata

(Open XML presentation Format)

Extract PPTM Metadata

(Macro-enabled Presentation File)

Extract PPT Metadata

(Microsoft PowerPoint 97-2003)

Extract PPSX Metadata

(PowerPoint Slide Show)

Extract PPSM Metadata

(Macro-enabled Slide Show)

Extract PPS Metadata

(PowerPoint Slide Show)

Extract POTX Metadata

(Microsoft PowerPoint Template Presentation)

Extract POTM Metadata

(Microsoft PowerPoint Template File)

Extract POT Metadata

(Microsoft PowerPoint Template Files)

Extract PNG Metadata

(Portable Network Graphic)

Extract PDF Metadata

(Portable Document Format)

Extract OTF Metadata

(OpenType Font)

Extract ODT Metadata

(OpenDocument Text File Format)

Extract ODS Metadata

(OpenDocument Spreadsheet)

Extract MSG Metadata

(Outlook Message Item File)

Extract MPT Metadata

(Microsoft Project Template)

Extract MPP Metadata

(Microsoft Project File)

Extract MP3 Metadata

(MP3 Audio File)

Extract MOV Metadata

(Apple QuickTime Movie)

Extract JPF Metadata

(JPEG 2000 Image)

Extract JPEG Metadata

(Joint Photographic Expert Group Image)

Extract JP2 Metadata

(JPEG 2000 Core Image)

Extract HEIF Metadata

(High Efficiency Image Format)

Extract HEIC Metadata

(High Efficiency Image Format)

Extract GIF Metadata

(Graphical Interchange Format)

Extract FLV Metadata

(Flash Video File)

Extract EPUB Metadata

(Open eBook File)

Extract EML Metadata

(E-Mail Message)

Extract EMF Metadata

(Enhanced Metafile Format)

Extract DXF Metadata

(Autodesk Drawing Exchange Format)

Extract DWG Metadata

(AutoCAD Drawing File)

Extract DOTX Metadata

(Microsoft Word Template File )

Extract DOTM Metadata

(Microsoft Word 2007+ Template File)

Extract DOT Metadata

(Microsoft Word Template Files)

Extract DOCX Metadata

(Office 2007+ Word Document)

Extract DOCM Metadata

(Microsoft Word 2007 Marco File)

Extract DOC Metadata

(Microsoft Word Binary Format)

Extract DJVU Metadata

(Graphics File Format)

Extract DICOM Metadata

(Digital Imaging and Communications in Medicine)

Extract BMP Metadata

(Bitmap Image File)

Extract AVI Metadata

(Audio Video Interleave File)

Extract ASF Metadata

(Advanced Systems Format File)

Extract MKV Metadata

(Matroska Video File)

Extract ONE Metadata

(OneNote Document)

Extract DJVU Metadata

(Graphics File Format)

Back to top