by
8,582 17
0
5
121k
0
Top 1% !
Pearl of Wisdom
Easy-to-find
Specified
OpenSource
Popularity: 17513rd place
Languagestata
LicenseMIT_X11

How to Set Line Spacing of a Paragraph in an Excel Shape or Textbox inside .NET Apps

This technical tip shows how to Set Line Spacing of the Paragraph in a Shape or Textbox in .NET applications. You can set the line space of the paragraph, its space before and space after using the TextParagraph.LineSpace, TextParagraph.SpaceBefore and TextParagraph.SpaceAfter respectively. The following example shows how to Set Line Spacing of the Paragraph in a Shape or Textbox.
Copy Embed Code
<iframe id="embedFrame" style="width:600px; height:300px;"
src="https://www.snip2code.com/Embed/1367841/How-to-Set-Line-Spacing-of-a-Paragraph-i?startLine=0"></iframe>
Click on the embed code to copy it into your clipboard Width Height
Leave empty to retrieve all the content Start End
// Enter here the actual content of the snippet. //[C# Code] // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET // The path to the documents directory. string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); // Create a workbook Workbook wb = new Workbook(); // Access first worksheet Worksheet ws = wb.Worksheets[0]; // Add text box inside the sheet ws.Shapes.AddTextBox(2, 0, 2, 0, 100, 200); // Access first shape which is a text box and set is text Shape shape = ws.Shapes[0]; shape.Text = "Sign up for your free phone number.\nCall and text online for free."; // Acccess the first paragraph TextParagraph p = shape.TextBody.TextParagraphs[1]; // Set the line space p.LineSpaceSizeType = LineSpaceSizeType.Points; p.LineSpace = 20; // Set the space after p.SpaceAfterSizeType = LineSpaceSizeType.Points; p.SpaceAfter = 10; // Set the space before p.SpaceBeforeSizeType = LineSpaceSizeType.Points; p.SpaceBefore = 10; // Save the workbook in xlsx format wb.Save(dataDir + "output_out_.xlsx", SaveFormat.Xlsx); //[VB.NET Code] ' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET ' The path to the documents directory. Dim dataDir As String = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType) ' Create a workbook Dim wb As New Workbook() ' Access first worksheet Dim ws As Worksheet = wb.Worksheets(0) ' Add text box inside the sheet ws.Shapes.AddTextBox(2, 0, 2, 0, 100, 200) ' Access first shape which is a text box and set is text Dim shape As Shape = ws.Shapes(0) shape.Text = "Sign up for your free phone number." & vbLf & "Call and text online for free." ' Acccess the first paragraph Dim p As TextParagraph = shape.TextBody.TextParagraphs(1) ' Set the line space p.LineSpaceSizeType = LineSpaceSizeType.Points p.LineSpace = 20 ' Set the space after p.SpaceAfterSizeType = LineSpaceSizeType.Points p.SpaceAfter = 10 ' Set the space before p.SpaceBeforeSizeType = LineSpaceSizeType.Points p.SpaceBefore = 10 ' Save the workbook in xlsx format wb.Save(dataDir & Convert.ToString("output_out_.xlsx"), SaveFormat.Xlsx)
If you want to be updated about similar snippets, Sign in and follow our Channels

blog comments powered by Disqus