add method

add(self, cell_name, total_rows, total_columns, address)

Adds a hyperlink to a specified cell or a range of cells.

Returns

Hyperlink object index.

def add(self, cell_name, total_rows, total_columns, address):
    ...

Parameter	Type	Description
cell_name	System.String	Cell name.
total_rows	int	Number of rows in this hyperlink range.
total_columns	int	Number of columns of this hyperlink range.
address	System.String	Address of the hyperlink.

add(self, first_row, first_column, total_rows, total_columns, address)

Adds a hyperlink to a specified cell or a range of cells.

Returns

Hyperlink object index.

def add(self, first_row, first_column, total_rows, total_columns, address):
    ...

Parameter	Type	Description
first_row	int	First row of the hyperlink range.
first_column	int	First column of the hyperlink range.
total_rows	int	Number of rows in this hyperlink range.
total_columns	int	Number of columns of this hyperlink range.
address	System.String	Address of the hyperlink.

Example

from aspose.cells import Workbook

# Instantiating a Workbook object
excel = Workbook()
worksheet = excel.worksheets[0]
worksheet.hyperlinks.add("A4", 1, 1, "http://www.aspose.com")
worksheet.hyperlinks.add("A5", 1, 1, "c:\\book1.xls")

add(self, start_cell_name, end_cell_name, address, text_to_display, screen_tip)

Adds a hyperlink to a specified cell or a range of cells.

Returns

Hyperlink object index.

def add(self, start_cell_name, end_cell_name, address, text_to_display, screen_tip):
    ...

Parameter	Type	Description
start_cell_name	System.String	The top-left cell of the range.
end_cell_name	System.String	The bottom-right cell of the range.
address	System.String	Address of the hyperlink.
text_to_display	System.String	The text to be displayed for the specified hyperlink.
screen_tip	System.String	The screenTip text for the specified hyperlink.

See Also

• module aspose.cells
• class Hyperlink
• class HyperlinkCollection