您可以

1. 使用row[0].internal_value.

或

1. 在加载工作簿时使用 data_only=True.(例如，workbook = openpyxl.load_workbook("yourxlsx.xlsx", data_only=True))

1. Use data_only=True when you load your workbook. (For example, workbook = openpyxl.load_workbook("yourxlsx.xlsx", data_only=True))

当您确定不希望从工作簿中获取原始公式时，第二个选项是不错的选择.

The second option is good when you are sure you don't wish to ever get the original formula from the workbook.