add_copy method

add_copy

Adds a worksheet to the collection and copies data from an existed worksheet.

Returns

Worksheet object index.

def add_copy(self, sheet_name):
    ...
ParameterTypeDescription
sheet_namestrName of source worksheet.

Exceptions

ExceptionDescription
CellsExceptionSpecifies an invalid worksheet name.

add_copy

Adds a worksheet to the collection and copies data from an existed worksheet.

Returns

Worksheet object index.

def add_copy(self, sheet_index):
    ...
ParameterTypeDescription
sheet_indexintIndex of source worksheet.

add_copy

Copy a group of worksheets.

def add_copy(self, source, dest_sheet_names):
    ...
ParameterTypeDescription
sourcelistThe source worksheets.
dest_sheet_nameslistThe names of the copied sheets.

See Also