SharedStringsReplacer.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.Collections.Generic;
using NanoXLSX.Interfaces;
using NanoXLSX.Interfaces.Reader;
using NanoXLSX.Registry;
using NanoXLSX.Registry.Attributes;
 
namespace NanoXLSX.Internal.Readers
{
    [NanoXlsxQueuePlugIn(PlugInUUID = "FORMATTED_TEXT_SHARED_STRINGS_REPLACER", QueueUUID = PlugInUUID.FinalizingInlineProcessor, PlugInOrder = 1000)]
    internal class SharedStringsReplacer : IPluginInlineReadProcessor
    {
        #region properties
        public IOptions Options { get; set; }
        public Workbook Workbook { get; set; }
        #endregion
 
        #region methods
        public void Init(Workbook workbook, IOptions readerOptions, int? index = null)
        {
            this.Workbook = workbook;
            this.Options = readerOptions;
        }

        public void Execute()
        {
            Dictionary<string, FormattedText> formattedTexts = Workbook.AuxiliaryData.GetData<Dictionary<string, FormattedText>>(PlugInUUID.SharedStringsReader, FormattedSharedStringsReader.AUXILIARY_DATA_ID);
            if (formattedTexts == null)
            {
                return;
            }
            for (int i = 0; i < Workbook.Worksheets.Count; i++)
            {
                Worksheet sheet = Workbook.Worksheets[i];
                foreach (KeyValuePair<string, FormattedText> entry in formattedTexts)
                {
                    List<Cell> cells = sheet.CellsByValue(entry.Key);
                    if (cells != null && cells.Count > 0)
                    {
                        foreach (Cell cell in cells)
                        {
                            sheet.Cells[cell.CellAddress].Value = entry.Value;
                        }
                    }
                }
            }
        }
        #endregion
    }
}