{"id":87,"date":"2026-02-27T18:14:41","date_gmt":"2026-02-27T10:14:41","guid":{"rendered":"https:\/\/xlwings.net\/blog\/?p=87"},"modified":"2026-01-17T10:42:50","modified_gmt":"2026-01-17T10:42:50","slug":"how-to-set-text-properties-using-xlwings","status":"publish","type":"post","link":"https:\/\/xlwings.net\/blog\/how-to-set-text-properties-using-xlwings\/","title":{"rendered":"How To Set Text Properties Using xlwings?"},"content":{"rendered":"
Method<\/h2>\n
In Excel, fonts are represented by the `Font` object. When setting the font, it is usually done by obtaining the `Font` object through a property, and then using the properties and methods of the object for configuration.<\/p>\n
\u00a0<\/p>\n
The main properties of the `Font` object include:\u00a0<\/p>\n
– Bold: Whether the font is bold. `True` for bold, `False` for not bold.<\/p>\n
– Color: RGB color shading.<\/p>\n
– ColorIndex: Index coloring. The index number of a color in the color lookup table.<\/p>\n
– FontStyle: Font style, such as “Bold Italic”.<\/p>\n
– Italic: Whether the font is italicized. `True` for italicized, `False` for not italicized.<\/p>\n
– Name: Font name.<\/p>\n
– Size: Font size.<\/p>\n
– Strikethrough: Whether to apply a strikethrough. `True` to apply, `False` to not apply.<\/p>\n
– Subscript: Whether the text is set as subscript. `True` to apply, `False` to not apply.<\/p>\n
– Superscript: Whether the text is set as superscript. `True` to apply, `False` to not apply.<\/p>\n
– ThemeColor: Theme color shading.<\/p>\n
– ThemeFont: Theme font.<\/p>\n
– TintAndShade: Darken or lighten the font color, with a value between -1 (darkest) to 1 (lightest).<\/p>\n
– Underline: The type of underline.\u00a0<\/p>\n
\u00a0 – Value -4142: No underline\u00a0<\/p>\n
\u00a0 – Value 2: Single underline\u00a0<\/p>\n
\u00a0 – Value -4119: Bold double underline\u00a0<\/p>\n
\u00a0 – Value 5: Close together thin double underline<\/p>\n
\u00a0<\/p>\n
sht.api.Range(‘C3′).Value=’Font Test123’<\/p>\n
ft=sht.api.Range(‘C3’).Font<\/p>\n
ft.Name = ‘Times New Roman’<\/p>\n
ft.ColorIndex = 3<\/p>\n
ft.Size = 20<\/p>\n
ft.Bold=True<\/p>\n
ft.Strikethrough = False<\/p>\n
ft.Underline = 5<\/p>\n
ft.Italic=True<\/p>\n
Sample Code<\/h2>\n\n\n
#Translation transformation\n\nimport xlwings as xw #Import xlwings package\n\napp=xw.App()\nbk=app.books.active #Get the active workbook\nsht=bk.sheets.active #Get the active worksheet\n\nshp=sht.api.Shapes.AddShape(1, 100, 50, 200, 100) #Rectangular area\nshp.Fill.PresetTextured(5) #Preset texture: Water drop\nshp.IncrementLeft(70) #Move right by 70 units\nshp.IncrementTop(50) #Move down by 50 units\n\n#bk.save()\n#bk.close()\n#app.kill()<\/code><\/pre>\n\n\n\n<\/figure>\n","protected":false},"excerpt":{"rendered":"
![\"Set](\"https:\/\/xlwings.net\/blog\/wp-content\/uploads\/2026\/02\/image-15.png\")
<\/figure>\n","protected":false},"excerpt":{"rendered":"