replace method

replace(self, place_holder, new_value)

Replaces a cell’s value with a new string.

def replace(self, place_holder, new_value):
    ...

Parameter	Type	Description
place_holder	str	Cell placeholder
new_value	str	String value to replace

Example

from aspose.cells import Workbook

workbook = Workbook()
# ......
workbook.replace("AnOldValue", "NewValue")

replace(self, place_holder, new_value)

Replaces a cell’s value with a new integer.

def replace(self, place_holder, new_value):
    ...

Parameter	Type	Description
place_holder	str	Cell placeholder
new_value	int	Integer value to replace

Example

from aspose.cells import Workbook

workbook = Workbook()
# ......
newValue = 100
workbook.replace("AnOldValue", newValue)

replace(self, place_holder, new_value)

Replaces a cell’s value with a new double.

def replace(self, place_holder, new_value):
    ...

Parameter	Type	Description
place_holder	str	Cell placeholder
new_value	float	Double value to replace

Example

from aspose.cells import Workbook

workbook = Workbook()
# ......
newValue = 100.0
workbook.replace("AnOldValue", newValue)

replace(self, bool_value, new_value)

Replaces cells’ values with new data.

def replace(self, bool_value, new_value):
    ...

Parameter	Type	Description
bool_value	bool	The boolean value to be replaced.
new_value	any	New value. Can be string, integer, double or DateTime value.

replace(self, int_value, new_value)

Replaces cells’ values with new data.

def replace(self, int_value, new_value):
    ...

Parameter	Type	Description
int_value	int	The integer value to be replaced.
new_value	any	New value. Can be string, integer, double or DateTime value.

replace(self, place_holder, new_values, is_vertical)

Replaces a cell’s value with a new string array.

def replace(self, place_holder, new_values, is_vertical):
    ...

Parameter	Type	Description
place_holder	str	Cell placeholder
new_values	list	String array to replace
is_vertical	bool	True - Vertical, False - Horizontal

Example

from aspose.cells import Workbook

workbook = Workbook()
# ......
newValues = ["Tom", "Alice", "Jerry"]
workbook.replace("AnOldValue", newValues, True)

replace(self, place_holder, new_values, is_vertical)

Replaces cells’ values with an integer array.

def replace(self, place_holder, new_values, is_vertical):
    ...

Parameter	Type	Description
place_holder	str	Cell placeholder
new_values	list	Integer array to replace
is_vertical	bool	True - Vertical, False - Horizontal

Example

from aspose.cells import Workbook

workbook = Workbook()
# ......
newValues = [1, 2, 3]
workbook.replace("AnOldValue", newValues, True)

replace(self, place_holder, new_values, is_vertical)

Replaces cells’ values with a double array.

def replace(self, place_holder, new_values, is_vertical):
    ...

Parameter	Type	Description
place_holder	str	Cell placeholder
new_values	list	Double array to replace
is_vertical	bool	True - Vertical, False - Horizontal

Example

from aspose.cells import Workbook

workbook = Workbook()
# ......
newValues = [1.23, 2.56, 3.14159]
workbook.replace("AnOldValue", newValues, True)

replace(self, place_holder, new_value, options)

Replaces a cell’s value with a new string.

def replace(self, place_holder, new_value, options):
    ...

Parameter	Type	Description
place_holder	str	Cell placeholder
new_value	str	String value to replace
options	ReplaceOptions	The replace options

See Also

• module aspose.cells
• class Workbook