Python 如何将分隔符添加到打印功能并在 Excel 文件的特定单元格中打印

该脚本的目标是遍历Excel文件中的所有行，提取注释的特定部分，并从我分配的单元格开始垂直输出.

到目前为止，我已经让它在IDE中打印出注释，但我不知道如何设置条件来分隔注释，或者更确切地说，只提取注释的所需部分并将其输出到所需的单元格.

例如，我试图提取的 comments 如下所示

您提交的内容与目录中的‘FASKLS89WYA’冲突.

我只想提取引号内的字符，并且第一个引号之前的字符总是相同的.

感谢任何指导，我仍然在学习Python，所以它对我来说是新的，我正在尽可能多地学习自己来制作这个脚本.

提前谢谢！

import openpyxl as xl
from openpyxl import load_workbook
from tkinter import filedialog
import tkinter as tk
import os

root = tk.Tk()
root.withdraw()

folder = filedialog.askdirectory()

paths = filedialog.askopenfilename(title="Select file", filetypes=(("Excel files", "*.xlsx"), ("Excel files", "*.xls")))
folder = '/'.join(paths.split('/')[0:-1])  # remove filename from path
sample_data = os.path.basename(paths)  # save filename for later use


def process_workbook(filename):
    if len(filename) != 0:  # in case cancel was pressed in filedialog
        wb = xl.load_workbook(filename)
        first_sheet = wb.get_sheet_names()[0]
        worksheet = wb.get_sheet_by_name(first_sheet)

        for row in worksheet.iter_rows(): # iterate through each cell in every row
            for cell in row:
                if cell.comment:
                    print(cell.comment.text)

    wb.save(os.path.join(folder, f'up_{sample_data}'))

process_workbook(paths)