Archive

How To Implement Geometric Transformation of Images Using xlwings?

Method

Using the methods provided by the `Shape` object, you can perform translation, rotation, scaling, and reflection transformations on a given graphic. The implementation of these methods is exactly the same for images.

 

shp=sht.api.Shapes.AddPicture(r”D:\picpy.jpg”, True, True, 100, 50, 100, 100)

shp.IncrementRotation(30)    #Rotate 30° clockwise around the center

shp.Flip(0)    #Horizontal flip

Sample Code

#Picture Geometric Transformations

import xlwings as xw    #Import xlwings package

app=xw.App()
bk=app.books.active   #Get the active workbook
sht=bk.sheets.active    #Get the active worksheet

shp=sht.api.Shapes.AddPicture(r"D:\picpy.jpg", True, True, 100, 50, 100, 100)
shp.IncrementRotation(30)    #Rotate 30° clockwise around the center
shp.Flip(0)    #Horizontal flip

#bk.save()
#bk.close()
#app.kill()

How To Add Image In the Worksheet Using xlwings?

Method

Use the `AddPicture` method of the `Shape` object to create an image from an existing file. This method returns a `Shape` object representing the new image. The syntax of this method is:

 

sht.api.Shapes.AddPicture(FileName,LinkToFile,SaveWithDocument,Left,Top,Width,Height)

 

Here, `sht` represents the worksheet, and the parameters are as follows:

 

 

sht.api.Shapes.AddPicture(root+”/picpy.jpg”, True, True, 100, 50, 100, 100)

Sample Code

#Add Picture

import xlwings as xw    #Import xlwings package
import os

root = os.getcwd()
app=xw.App()
bk=app.books.active   #Get the active workbook
sht=bk.sheets.active    #Get the active worksheet

sht.api.Shapes.AddPicture(r"D:\picpy.jpg", True, True, 100, 50, 100, 100)

#bk.save()
#bk.close()
#app.kill()

How To Implement Graphic Flipping Using xlwings?

Method

Graphic flipping, also known as image reflection or symmetry transformation, is achieved using the `Flip` method of the `Shape` object. This method flips the graphic around either the horizontal or vertical axis. It has one parameter that specifies whether to flip horizontally or vertically. The corresponding values for horizontal and vertical flips are 0 and 1, respectively.

 

shp=sht.api.Shapes.AddShape(1, 100, 50, 200, 100)    #Rectangular area

shp.Fill.PresetTextured(22)    #Preset texture: Walnut wood

shp.Flip(0)    #Horizontal flip

shp.Flip(1)    #Vertical flip

Sample Code

#Iterating Over Shapes in the Worksheet

import xlwings as xw    #Import xlwings package

app=xw.App()
bk=app.books.active   #Get the active workbook
sht=bk.sheets.active    #Get the active worksheet

shp1=sht.api.Shapes.AddShape(1, 50, 50, 200, 100)    #Rectangular area
shp2=sht.api.Shapes.AddShape(9, 30, 80, 200, 100)    #Elliptical area
shp2.Fill.ForeColor.RGB=xw.utils.rgb_to_int((255,0,0))
shp2.Fill.Transparency=0.7
shp3=sht.api.Shapes.AddLine(10,10,200,120)    #Line segment
sht.range('F1').value=['Name', 'Type', 'Top-left X', 'Top-left Y', 'Width', 'Height']  # Header
i=0
for shp in sht.api.Shapes:    #Iterate through each Shape object in the worksheet
    i+=1
    sht.api.Cells(i+1, 'F').Value=shp.Name    #Output each Shape object's properties
    sht.api.Cells(i+1, 'G').Value=shp.Type
    sht.api.Cells(i+1, 'H').Value=shp.Left
    sht.api.Cells(i+1, 'I').Value=shp.Top
    sht.api.Cells(i+1, 'J').Value=shp.Width
    sht.api.Cells(i+1, 'K').Value=shp.Height

#bk.save()
#bk.close()
#app.kill()

How To Implement Graphic Scaling Using xlwings?

Method

Graphic scaling, also known as affine transformation, is the process of enlarging or reducing a given graphic by a certain ratio. Use the `ScaleWidth` and `ScaleHeight` methods of the `Shape` object to specify the scaling ratios for the horizontal and vertical directions, respectively, to achieve the scaling operation.

 

Both `ScaleWidth` and `ScaleHeight` methods have three parameters, as shown in the table.

 

Name	Required/Optional	Data Type	Description
Factor	Required	Single	Specifies the ratio of the adjusted width to the current or original width
RelativeToOriginalSize	Required	MsoTriState	When `False`, scales relative to the current size. This parameter can only be set to `True` when the graphic is a picture or OLE object.
Scale	Optional	Variant	One of the constants from MsoScaleFrom type, specifying which part of the graphic remains at the original position when scaling.

 

The `Scale` parameter takes constants from the `MsoScaleFrom` enumeration, indicating which part of the graphic remains at the original position after scaling. The possible values are as follows:

 

Name	Value	Description
msoScaleFromBottomRight	2	The bottom-right corner of the graphic remains at the original position
msoScaleFromMiddle	1	The midpoint of the graphic remains at the original position
msoScaleFromTopLeft	0	The top-left corner of the graphic remains at the original position

 

shp=sht.api.Shapes.AddShape(9, 100, 50, 200, 100)    #Elliptical area

ff=shp.Fill

ff.PresetTextured(12)    #Preset texture: Granite

shp.ScaleWidth(0.75,False)    #Width × 0.75

shp.ScaleHeight(1.75,False)    #Height × 1.75

Sample Code

#Flip transformation

import xlwings as xw    #Import xlwings package

app=xw.App()
bk=app.books.active   #Get the active workbook
sht=bk.sheets.active    #Get the active worksheet

shp=sht.api.Shapes.AddShape(1, 100, 50, 200, 100)    #Rectangular area
shp.Fill.PresetTextured(22)    #Preset texture: Walnut wood
shp.Flip(0)    #Horizontal flip
shp.Flip(1)    #Vertical flip

#bk.save()
#bk.close()
#app.kill()

How To Implement Graphic Rotation Using xlwings?

Method

Use the `IncrementRotation` method of the `Shape` object to rotate the graphic. This method rotates the graphic around the Z-axis by a specified angle. It has one parameter, representing the angle of rotation in degrees. A positive value rotates the graphic clockwise, while a negative value rotates the graphic counterclockwise.

 

shp=sht.api.Shapes.AddShape(1, 100, 50, 200, 100)    #Rectangular area

shp.Fill.PresetTextured(5)    #Preset texture: Water drop

shp.IncrementRotation(30)    #Rotate clockwise by 30°°

Sample Code

#Scaling transformation

import xlwings as xw    #Import xlwings package

app=xw.App()
bk=app.books.active   #Get the active workbook
sht=bk.sheets.active    #Get the active worksheet

shp=sht.api.Shapes.AddShape(9, 100, 50, 200, 100)    #Elliptical area
ff=shp.Fill
ff.PresetTextured(12)    #Preset texture: Granite
shp.ScaleWidth(0.75,False)    #Width × 0.75
shp.ScaleHeight(1.75,False)    #Height × 1.75

#bk.save()
#bk.close()
#app.kill()

How To Implement Graphic Translation Using xlwings?

Method

Use the `IncrementLeft` method of the `Shape` object to translate the graphic horizontally. This method has one parameter: when the value is greater than 0, the graphic moves to the right; when the value is less than 0, the graphic moves to the left.

 

Use the `IncrementTop` method of the `Shape` object to translate the graphic vertically. This method has one parameter: when the value is greater than 0, the graphic moves down; when the value is less than 0, the graphic moves up.

 

shp=sht.api.Shapes.AddShape(1, 100, 50, 200, 100)    #Rectangular area

shp.Fill.PresetTextured(5)    #Preset texture: Water drop

shp.IncrementLeft(70)    #Move right by 70 units

shp.IncrementTop(50)    #Move down by 50 units

Sample Code

#Rotation transformation

import xlwings as xw    #Import xlwings package

app=xw.App()
bk=app.books.active   #Get the active workbook
sht=bk.sheets.active    #Get the active worksheet

shp=sht.api.Shapes.AddShape(1, 100, 50, 200, 100)    #Rectangular area
shp.Fill.PresetTextured(5)    #Preset texture: Water drop
shp.IncrementRotation(30)    #Rotate clockwise by 30°

#bk.save()
#bk.close()
#app.kill()

How To Set Text Properties Using xlwings?

Method

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.

 

The main properties of the `Font` object include: 

– Bold: Whether the font is bold. `True` for bold, `False` for not bold.

– Color: RGB color shading.

– ColorIndex: Index coloring. The index number of a color in the color lookup table.

– FontStyle: Font style, such as “Bold Italic”.

– Italic: Whether the font is italicized. `True` for italicized, `False` for not italicized.

– Name: Font name.

– Size: Font size.

– Strikethrough: Whether to apply a strikethrough. `True` to apply, `False` to not apply.

– Subscript: Whether the text is set as subscript. `True` to apply, `False` to not apply.

– Superscript: Whether the text is set as superscript. `True` to apply, `False` to not apply.

– ThemeColor: Theme color shading.

– ThemeFont: Theme font.

– TintAndShade: Darken or lighten the font color, with a value between -1 (darkest) to 1 (lightest).

– Underline: The type of underline. 

  – Value -4142: No underline 

  – Value 2: Single underline 

  – Value -4119: Bold double underline 

  – Value 5: Close together thin double underline

 

sht.api.Range(‘C3′).Value=’Font Test123’

ft=sht.api.Range(‘C3’).Font

ft.Name = ‘Times New Roman’

ft.ColorIndex = 3

ft.Size = 20

ft.Bold=True

ft.Strikethrough = False

ft.Underline = 5

ft.Italic=True

Sample Code

#Translation transformation

import xlwings as xw    #Import xlwings package

app=xw.App()
bk=app.books.active   #Get the active workbook
sht=bk.sheets.active    #Get the active worksheet

shp=sht.api.Shapes.AddShape(1, 100, 50, 200, 100)    #Rectangular area
shp.Fill.PresetTextured(5)    #Preset texture: Water drop
shp.IncrementLeft(70)    #Move right by 70 units
shp.IncrementTop(50)    #Move down by 50 units

#bk.save()
#bk.close()
#app.kill()

How To Set Face Properties Using xlwings? – Transparency

Method

shp=sht.api.Shapes.AddShape(1, 200, 50, 200, 100)    #Rectangular area

shp2=sht.api.Shapes.AddShape(9, 150, 70, 200, 100)    #Elliptical area

ff=shp2.Fill

ff.ForeColor.RGB= xw.utils.rgb_to_int((255,0,0))    #Set elliptical area to red

ff.Transparency=0.7    #Transparency 0.7

Sample Code

#Text Properties

import xlwings as xw    #Import xlwings package

app=xw.App()
bk=app.books.active   #Get the active workbook
sht=bk.sheets.active    #Get the active worksheet

sht.api.Range('C3').Value='Font Test123'
ft=sht.api.Range('C3').Font
ft.Name = 'Times New Roman'
ft.ColorIndex = 3
ft.Size = 20
ft.Bold=True
ft.Strikethrough = False
ft.Underline = 5
ft.Italic=True

#bk.save()
#bk.close()
#app.kill()

How To Set Face Properties Using xlwings? – Preset Texture Fill

Method

shp1=sht.api.Shapes.AddShape(1, 100, 50, 200, 100)    #Rectangular area

ff1=shp1.Fill

ff1.PresetTextured(9)    #Preset texture: Green marble

Sample Code

#Area properties - Transparency

import xlwings as xw    #Import xlwings package

app=xw.App()
bk=app.books.active   #Get the active workbook
sht=bk.sheets.active    #Get the active worksheet

shp=sht.api.Shapes.AddShape(1, 200, 50, 200, 100)    #Rectangular area
shp2=sht.api.Shapes.AddShape(9, 150, 70, 200, 100)    #Elliptical area
ff=shp2.Fill
ff.ForeColor.RGB= xw.utils.rgb_to_int((255,0,0))    #Set elliptical area to red
ff.Transparency=0.7    #Transparency 0.7

#bk.save()
#bk.close()
#app.kill()

How To Set Face Properties Using xlwings? – Texture Fill

Method

Using UserTextured method.

 

shp1=sht.api.Shapes.AddShape(1, 100, 50, 200, 100)    #Rectangular area

ff1=shp1.Fill

ff1.UserTextured(root+r”/picpy.jpg”)    #Texture fill

Sample Code

#Area properties - Preset texture fill.

import xlwings as xw    #Import xlwings package

app=xw.App()
bk=app.books.active   #Get the active workbook
sht=bk.sheets.active    #Get the active worksheet

shp1=sht.api.Shapes.AddShape(1, 100, 50, 200, 100)    #Rectangular area
ff1=shp1.Fill
ff1.PresetTextured(9)    #Preset texture: Green marble

shp2=sht.api.Shapes.AddShape(9, 400, 50, 200, 100)    #Elliptical area
ff2=shp2.Fill
ff2.PresetTextured(22)    #Preset texture: Walnut wood

#bk.save()
#bk.close()
#app.kill()