MetadataCoreReader.cs

/*
 * NanoXLSX is a small .NET library to generate and read XLSX (Microsoft Excel 2007 or newer) files in an easy and native way
 * Copyright Raphael Stoeckli © 2026
 * This library is licensed under the MIT License.
 * You find a copy of the license in project folder or on: http://opensource.org/licenses/MIT
 */
 
using System;
using System.IO;
using System.Xml;
using NanoXLSX.Interfaces;
using NanoXLSX.Interfaces.Reader;
using NanoXLSX.Registry;
using NanoXLSX.Registry.Attributes;
 
namespace NanoXLSX.Internal.Readers
{
    [NanoXlsxPlugIn(PlugInUUID = PlugInUUID.MetadataCoreReader)]
    public class MetadataCoreReader : IPluginBaseReader
    {
        private MemoryStream stream;
 
        #region properties
        public Workbook Workbook { get; set; }
        public IOptions Options { get; set; }
        public Action<MemoryStream, Workbook, string, IOptions, int?> InlinePluginHandler { get; set; }
        #endregion
 
        #region constructors
        internal MetadataCoreReader()
        {
        }
 
        #endregion
 
        #region methods
        public void Init(MemoryStream stream, Workbook workbook, IOptions readerOptions, Action<MemoryStream, Workbook, string, IOptions, int?> inlinePluginHandler)
        {
            this.stream = stream;
            this.Workbook = workbook;
            this.Options = readerOptions;
            this.InlinePluginHandler = inlinePluginHandler;
        }

        public void Execute()
        {
            try
            {
                using (stream) // Close after processing
                {
                    Metadata metadata = Workbook.WorkbookMetadata;
 
                    XmlDocument xr = new XmlDocument() { XmlResolver = null };
                    using (XmlReader reader = XmlReader.Create(stream, new XmlReaderSettings() { XmlResolver = null }))
                    {
                        xr.Load(reader);
                        foreach (XmlNode node in xr.DocumentElement.ChildNodes)
                        {
                            if (node.LocalName.Equals("Category", StringComparison.OrdinalIgnoreCase))
                            {
                                metadata.Category = node.InnerText;
                            }
                            else if (node.LocalName.Equals("ContentStatus", StringComparison.OrdinalIgnoreCase))
                            {
                                metadata.ContentStatus = node.InnerText;
                            }
                            else if (node.LocalName.Equals("Creator", StringComparison.OrdinalIgnoreCase))
                            {
                                metadata.Creator = node.InnerText;
                            }
                            else if (node.LocalName.Equals("Description", StringComparison.OrdinalIgnoreCase))
                            {
                                metadata.Description = node.InnerText;
                            }
                            else if (node.LocalName.Equals("Keywords", StringComparison.OrdinalIgnoreCase))
                            {
                                metadata.Keywords = node.InnerText;
                            }
                            else if (node.LocalName.Equals("Subject", StringComparison.OrdinalIgnoreCase))
                            {
                                metadata.Subject = node.InnerText;
                            }
                            else if (node.LocalName.Equals("Title", StringComparison.OrdinalIgnoreCase))
                            {
                                metadata.Title = node.InnerText;
                            }
                        }
                        InlinePluginHandler?.Invoke(stream, Workbook, PlugInUUID.MetadataCoreInlineReader, Options, null);
                    }
                }
            }
            catch (Exception ex)
            {
                throw new IOException("The XML entry could not be read from the input stream. Please see the inner exception:", ex);
            }
 
        }
        #endregion
    }
}