Class TextParagraphCollection

TextParagraphCollection class

Represents all text paragraph.

public class TextParagraphCollection : IEnumerable

Properties

NameDescription
Count { get; }Gets the count of text paragraphs.
Item { get; }Gets the TextParagraph object at specific index.

Methods

NameDescription
GetEnumerator()Gets the enumerator of the paragraphs.

Examples

using System;
using Aspose.Cells;
using Aspose.Cells.Drawing;
using Aspose.Cells.Drawing.Texts;

namespace AsposeCellsExamples
{
    public class TextsClassTextParagraphCollectionDemo
    {
        public static void Run()
        {
            // Create a new workbook
            Workbook workbook = new Workbook();
            
            // Add a text box to the first worksheet
            Worksheet worksheet = workbook.Worksheets[0];
            Shape shape = worksheet.Shapes.AddTextBox(0, 0, 0, 0, 400, 400);
            
            // Set multi-line text
            shape.Text = "First paragraph\nSecond paragraph";
            
            // Get the paragraph collection
            TextParagraphCollection paragraphs = shape.TextBody.TextParagraphs;
            
            // Access and modify the second paragraph
            TextParagraph secondParagraph = paragraphs[1];
            secondParagraph.LineSpaceSizeType = LineSpaceSizeType.Points;
            secondParagraph.LineSpace = 20;
            secondParagraph.SpaceAfter = 30;
            secondParagraph.SpaceBefore = 40;
            
            // Save the workbook
            workbook.Save("TextParagraphCollectionDemo.xlsx");
            
            Console.WriteLine("Text paragraph formatting saved successfully.");
        }
    }
}

See Also