设置形状或文本框中段落的行间距

设置形状或文本框中段落的行间距

以下示例代码解释了上述属性的用法。请下载代码生成的 输出excel文件 进行参考。

// 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);