Set Line Spacing of the Paragraph in a Shape or Textbox

Set Line Spacing of the Paragraph in a Shape or Textbox

The following sample code explains the usage of mentioned properties. Please download the output excel file generated by the code for your reference.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
// The path to the documents directory.
String dataDir = Utils.getDataDir(SetLineSpacingofParagraph.class);
// Create a workbook
Workbook wb = new Workbook();
// Access first worksheet
Worksheet ws = wb.getWorksheets().get(0);
// Add text box inside the sheet
ws.getShapes().addShape(MsoDrawingType.TEXT_BOX, 2, 0, 2, 0, 100, 200);
// Access first shape which is a text box and set is text
Shape shape = ws.getShapes().get(0);
shape.setText("Sign up for your free phone number.\nCall and text online for free.");
// Acccess the first paragraph
TextParagraph p = shape.getTextBody().getTextParagraphs().get(1);
// Set the line space
p.setLineSpaceSizeType(LineSpaceSizeType.POINTS);
p.setLineSpace(20);
// Set the space after
p.setSpaceAfterSizeType(LineSpaceSizeType.POINTS);
p.setSpaceAfter(10);
// Set the space before
p.setSpaceBeforeSizeType(LineSpaceSizeType.POINTS);
p.setSpaceBefore(10);
// Save the workbook in xlsx format
wb.save(dataDir + "output.xlsx", SaveFormat.XLSX);