Setting Shadow of Text Effects of Shape or TextBox

You can set the Shadow of Text Effects of any Shape or TextBox. Please use the Shape.text_body property. It presents the setting of the shape’s text and returns FontSetting objects. After accessing it, please set the Shadow via FontSetting.text_options.shadow.preset_type property. This property is of the type PresetShadowType which has several values. Some of these are

• OFFSET_DIAGONAL_BOTTOM_RIGHT
• OFFSET_BOTTOM
• OFFSET_DIAGONAL_TOP_RIGHT
• INSIDE_LEFT
• INSIDE_CENTER
• PERSPECTIVE_DIAGONAL_UPPER_LEFT
• PERSPECTIVE_DIAGONAL_UPPER_RIGHT

The following code snippet demonstrates the use of FontSetting.text_options.shadow.preset_type property to set shadow of text effects of Shape or TextBox.

from aspose.cells import SaveFormat, Workbook
from aspose.cells.drawing import PresetShadowType
from aspose.pydrawing import Color

#  For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET
# Output directory
outputDir = RunExamples.Get_OutputDirectory()
#  Create workbook object
wb = Workbook()
#  Access first worksheet
ws = wb.worksheets[0]
#  Add text box with these dimensions
tb = ws.shapes.add_text_box(2, 0, 2, 0, 100, 400)
#  Set the text of the textbox
tb.text = "This text has the following settings.\n\nText Effects > Shadow > Offset Bottom"
#  Set all the text runs shadow to preset offset bottom
for i in range(len(tb.text_body)):
    tb.text_body[i].text_options.shadow.preset_type = PresetShadowType.OFFSET_BOTTOM
#  Set the font color and size of the textbox
tb.font.color = Color.red
tb.font.size = 16
#  Save the output file
wb.save(outputDir + "outputSettingTextEffectsShadowOfShapeOrTextbox.xlsx", SaveFormat.XLSX)