Python annotate openpyxl cell, cell values will be overwritten-CodePudding

Use cell.com ment (" A1 ")=openpyxl.com ments (" * * * ") on the cell A1 add comments,
But the cell A1 original value, strives for the great god,
Do not answer like this answer: first to cell A1 assignment, after add a comment, or to add annotations to cell after assignment,

CodePudding user response:

refer to the original poster micromsg response:

use cell.com ment (" A1 ")=openpyxl.com ments (" * * * ") on the cell A1 add comments,
But the cell A1 original value, strives for the great god,
Do not answer like this answer: first to cell A1 assignment, after add a comment, or to add annotations to the cell after assignment,

The code in the correct problems as follows:
Cell [r]. "A1" comment=openpyxl.com ments (" * * * ")

CodePudding user response:

Problem solved, put a less parameter