atomica.excel.transfer_comments

atomica.excel.transfer_comments(target, comment_source)[source]

Copy comments between spreadsheets

This function copies comments from one spreadsheet to another. Under the hood, a new spreadsheet is created with values from the target Spreadsheet and cell-wise formatting from the comment_source Spreadsheet. If a cell exists in this spreadsheet and not in the source, it will be retained as-is. If more cells exist in the comment_source than in this spreadsheet, those cells will be dropped. If a sheet exists in the comment_source and not in the current workbook, it will be added

Parameters:

  • target (Spreadsheet) – The target spreadsheet to write comments into

  • comment_source (Spreadsheet) – The source spreadsheet containing comments

Return type:

None