/// <summary>
        ///     Append given text in the current theme's minor font and default font size.
        /// </summary>
        /// <param name="Text">The text.</param>
        public void AppendText(string Text)
        {
            var font = new SLFont(MajorFont, MinorFont, listThemeColors, listIndexedColors);

            font.SetFont(FontSchemeValues.Minor, SLConstants.DefaultFontSize);

            AppendText(Text, font);
        }
        //For each sheet in the publishing form folder, create a metadata sheet by deleting the unneeded columns
        public void createMetadata()
        {
            listFileNames(folderPath);
            foreach (var f in pubforms)
            {
                SLDocument sl = new SLDocument(folderPath + "\\" + f.Value);

                //Select Publishing tab
                sl.SelectWorksheet(MetaPresTab);

                //Try and rename something in the header row
                //Big "Source"
                //Small "Global master slides or locally developed slides that maintain the main message of that slide = GL; otherwise set to LO"
                //D34
                SLRstType Heading1 = new SLRstType();
                SLFont    Big      = new SLFont();
                SLFont    Small    = new SLFont();
                Big.Bold = true;
                Big.SetFont("Calibri", 14);
                Small.SetFont("Calibri", 9);
                Heading1.AppendText("PBSource", Big);
                Heading1.AppendText("Global PB master slides or locally developed slides that maintain the main message of that slide = GL; otherwise set to LO", Small);
                sl.SetCellValue("D" + (metakeymessagestartrow - 1), Heading1);

                /*
                 * // delete 1 column at column 6 - sl.DeleteColumn(6, 1);
                 * foreach (var i in NonMetadataColumns)
                 * {
                 *  sl.DeleteColumn(i, 1);
                 * }
                 *
                 * foreach (var i in NonMetadataRows)
                 * {
                 *  sl.DeleteRow(i, 1);
                 * }
                 */


                sl.SaveAs(folderPath + "\\METADATATEST-" + f.Value + ".xlsx");
            }
        }