add_scroll_bar method

add_scroll_bar

Adds a ScrollBar to the worksheet.

Returns

A ScrollBar object.

def add_scroll_bar(self, upper_left_row, top, upper_left_column, left, height, width):
    ...
ParameterTypeDescription
upper_left_rowintUpper left row index.
topintRepresents the vertical offset of ScrollBar from its left row, in unit of pixel.
upper_left_columnintUpper left column index.
leftintRepresents the horizontal offset of ScrollBar from its left column, in unit of pixel.
heightintRepresents the height of ScrollBar, in unit of pixel.
widthintRepresents the width of ScrollBar, in unit of pixel.

Example


# add a scroll bar
scrollBar = shapes.add_scroll_bar(1, 0, 1, 0, 100, 20)

See Also