Setting Shadow of Text Effects of Shape or TextBox

Setting Shadow of Text Effects of Shape or TextBox

The following screenshot shows the output excel file generated with the following sample code. The screenshot also shows the value of the Shadow which has been set as Offset Bottom.

todo:image_alt_text

// 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.getSharedDataDir(SettingTextEffectsShadowOfShapeOrTextbox.class) + "articles/";
// Create workbook object
Workbook wb = new Workbook();
// Access first worksheet
Worksheet ws = wb.getWorksheets().get(0);
// Add text box with these dimensions
int idx = ws.getTextBoxes().add(2, 2, 100, 400);
TextBox tb = ws.getTextBoxes().get(idx);
// Set the text of the textbox
tb.setText("This text has the following settings.\n\nText Effects > Shadow > Offset Bottom");
// Set all the text runs shadow to preset offset bottom
for (int i = 0; i < tb.getTextBody().getCount(); i++) {
tb.getTextBody().get(i).getTextOptions().getShadow().setPresetType(PresetShadowType.OFFSET_BOTTOM);
}
// Set the font color and size of the textbox
tb.getFont().setColor(Color.getRed());
tb.getFont().setSize(16);
// Save the output file
wb.save(dataDir + "STESOfShapeOrTextbox_out.xlsx", SaveFormat.XLSX);