WorksheetExtensions.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 System.ComponentModel;
using NanoXLSX.Exceptions;
using NanoXLSX.Styles;
 
namespace NanoXLSX
{
    [EditorBrowsable(EditorBrowsableState.Never)]
    public static class WorksheetExtensions
    {
        public static void AddFormattedTextCell(this Worksheet worksheet, FormattedText formattedText, int columnNumber, int rowNumber)
        {
            AddFormattedText(worksheet, formattedText, columnNumber, rowNumber);
        }

 
        public static void AddFormattedTextCell(this Worksheet worksheet, FormattedText formattedText, int columnNumber, int rowNumber, Style style)
        {
            AddFormattedText(worksheet, formattedText, columnNumber, rowNumber, style);
        }

        public static void AddFormattedTextCell(this Worksheet worksheet, FormattedText formattedText, string address)
        {
            int column;
            int row;
            Cell.ResolveCellCoordinate(address, out column, out row);
            AddFormattedText(worksheet, formattedText, column, row);
        }

        public static void AddFormattedTextCell(this Worksheet worksheet, FormattedText formattedText, string address, Style style)
        {
            int column;
            int row;
            Cell.ResolveCellCoordinate(address, out column, out row);
            AddFormattedText(worksheet, formattedText, column, row, style);
        }

        public static void AddNextFormattedTextCell(this Worksheet worksheet, FormattedText formattedText)
        {
            AddFormattedText(worksheet, formattedText);
        }

        public static void AddNextFormattedTextCell(this Worksheet worksheet, FormattedText formattedText, Style style)
        {
            AddFormattedText(worksheet, formattedText, style);
        }

        public static void AddFormattedTextCellRange(this Worksheet worksheet, IReadOnlyList<FormattedText> values, string startAddress, string endAddress, Style style = null)
        {
            AddFormattedTextRange(worksheet, values, (Address)startAddress, (Address)endAddress, style);
        }

        public static void AddFormattedTextCellRange(this Worksheet worksheet, IReadOnlyList<FormattedText> values, Address startAddress, Address endAddress, Style style = null)
        {
            AddFormattedTextRange(worksheet, values, startAddress, endAddress, style);
        }

        public static void AddFormattedTextCellRange(this Worksheet worksheet, IReadOnlyList<FormattedText> values, string cellRange, Style style = null)
        {
            Range range = new Range(cellRange);
            AddFormattedTextRange(worksheet, values, range.StartAddress, range.EndAddress, style);
        }
 

        private static void AddFormattedText(Worksheet worksheet, FormattedText formattedText, int columnNumber, int rowNumber, Style cellStyle = null)
        {
            if (formattedText == null)
            {
                throw new WorksheetException("A formatted text to add cannot be null");
            }
            if (formattedText.WrapText)
            {
                if (cellStyle == null)
                {
                    worksheet.AddCell(formattedText, columnNumber, rowNumber, FormattedText.LineBreakStyle);
                }
                else
                {
                    Style mergedStyle = cellStyle.Append(FormattedText.LineBreakStyle);
                    worksheet.AddCell(formattedText, columnNumber, rowNumber, mergedStyle);
                }
            }
            else
            {
                worksheet.AddCell(formattedText, columnNumber, rowNumber, cellStyle);
            }
        }

        private static void AddFormattedText(Worksheet worksheet, FormattedText formattedText, Style cellStyle = null)
        {
            if (formattedText == null)
            {
                throw new WorksheetException("A formatted text to add cannot be null");
            }
            if (formattedText.WrapText)
            {
                if (cellStyle == null)
                {
                    worksheet.AddNextCell(formattedText, FormattedText.LineBreakStyle);
                }
                else
                {
                    Style mergedStyle = cellStyle.Append(FormattedText.LineBreakStyle);
                    worksheet.AddNextCell(formattedText, mergedStyle);
                }
            }
            else
            {
                worksheet.AddNextCell(formattedText, cellStyle);
            }
        }

        private static void AddFormattedTextRange(Worksheet worksheet, IReadOnlyList<FormattedText> formattedTexts, Address startAddress, Address endAddress, Style cellStyle = null)
        {
            if (formattedTexts == null || formattedTexts.Count == 0)
            {
                throw new WorksheetException("A range of formatted texts to add cannot be null or empty");
            }
            List<Cell> cells = new List<Cell>(formattedTexts.Count);
            foreach (FormattedText text in formattedTexts)
            {
                if (text == null || string.IsNullOrEmpty(text.PlainText))
                {
                    Cell emptyCell = new Cell(null, Cell.CellType.Empty);
                    if (cellStyle != null)
                    {
                        emptyCell.SetStyle(cellStyle);
                    }
                    cells.Add(emptyCell);
                    continue;
                }
                Cell cell = new Cell(text, Cell.CellType.String);
                if (text.WrapText && cellStyle != null)
                {
                    Style merged = cellStyle.Append(FormattedText.LineBreakStyle);
                    cell.SetStyle(merged);
                }
                else if (text.WrapText && cellStyle == null)
                {
                    cell.SetStyle(FormattedText.LineBreakStyle);
                }
                else if (!text.WrapText && cellStyle != null)
                {
                    cell.SetStyle(cellStyle);
                }
                cells.Add(cell);
            }
            if (cellStyle != null)
            {
                worksheet.AddCellRange(cells, startAddress, endAddress, cellStyle);
            }
            else
            {
                worksheet.AddCellRange(cells, startAddress, endAddress);
            }
        }
 
    }
}