MetadataCoreWriter.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 © 2025
 * 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 NanoXLSX.Interfaces.Writer;
using NanoXLSX.Registry;
using NanoXLSX.Registry.Attributes;
using NanoXLSX.Utils;
using NanoXLSX.Utils.Xml;
using System;
 
namespace NanoXLSX.Internal.Writers
{
    [NanoXlsxPlugIn(PlugInUUID = PlugInUUID.MetadataCoreWriter)]
    internal class MetadataCoreWriter : IPlugInWriter
    {
        private XmlElement properties;
 
        #region properties
        public Workbook Workbook { get; set; }

        public XmlElement XmlElement { get => properties; }
 
        #endregion
        #region constructors
        internal MetadataCoreWriter()
        {
        }
 
        #endregion
        #region methods
        public void Init(IBaseWriter baseWriter)
        {
            this.Workbook = baseWriter.Workbook;
        }

        public void Execute()
        {
            properties = XmlElement.CreateElement("coreProperties", "cp");
            properties.AddNameSpaceAttribute("dc", "xmlns", "http://purl.org/dc/elements/1.1/");
            properties.AddNameSpaceAttribute("cp", "xmlns", "http://schemas.openxmlformats.org/package/2006/metadata/core-properties");
            properties.AddNameSpaceAttribute("dcterms", "xmlns", "http://purl.org/dc/terms/");
            properties.AddNameSpaceAttribute("xsi", "xmlns", "http://www.w3.org/2001/XMLSchema-instance");
            Metadata md = Workbook.WorkbookMetadata;
            properties.AddChildElementWithValue("title", md.Title, "dc");
            properties.AddChildElementWithValue("subject", md.Subject, "dc");
            properties.AddChildElementWithValue("creator", md.Creator, "dc");
            properties.AddChildElementWithValue("lastModifiedBy", md.Creator, "cp");
            properties.AddChildElementWithValue("keywords", md.Keywords, "cp");
            properties.AddChildElementWithValue("description", md.Description, "dc");
            string time = DateTime.Now.ToString("yyyy-MM-ddThh:mm:ssZ", ParserUtils.InvariantCulture);
            XmlElement child1 = properties.AddChildElementWithValue("created", time, "dcterms");
            child1.AddAttribute("type", "dcterms:W3CDTF", "xsi");
            XmlElement child2 = properties.AddChildElementWithValue("modified", time, "dcterms");
            child2.AddAttribute("type", "dcterms:W3CDTF", "xsi");
            properties.AddChildElementWithValue("category", md.Category, "cp");
            properties.AddChildElementWithValue("contentStatus", md.ContentStatus, "cp");
 
            WriterPlugInHandler.HandleInlineQueuePlugins(ref properties, Workbook, PlugInUUID.MetadataCoreInlineWriter);
        }
 
        #endregion
    }
}