python 将数据写入excle

Question

问题遇到的现象和发生背景

写入时一个字节一个单元格 想要他写道一个单元格中

问题相关代码，请勿粘贴截图

    def pushButton_create(self):
        send_data1 = {}  # 创建字典
        send_data2 = {}
        send_data3 = {}
        send_data4 = {}  # 创建字典
        send_data1['data'] = self.ui.textEdit_name.toPlainText()+ "\r\n"# 数据等于lineEdit_name的值 简单文本用toPlainText()
        send_data2['data'] = self.ui.textEdit_come.toPlainText()+ "\r\n"   # 数据等于lineEdit_name的值 简单文本用toPlainText()
        send_data3['data'] = self.ui.textEdit_lp.toPlainText()+ "\r\n"   # 数据等于lineEdit_name的值 简单文本用toPlainText()
        send_data4['data'] = self.ui.textEdit_bl.toPlainText()+ "\r\n" # 数据等于lineEdit_name的值 简单文本用toPlainText()
        data = send_data1['data']+send_data2['data']+send_data3['data']+send_data4['data']
        print(data)
        workbook = xlsxwriter.Workbook(u'C:\\Users\\mushiny\\Desktop\\批次管理.xlsx')
        worksheet = workbook.add_worksheet()
        titles = [u'物料信息', u'来料数',u'良品', u'次品']
        worksheet.write_row(0, 0, titles)
        worksheet.write_row(1, 0, send_data1['data'])
        workbook.close()

运行结果及报错内容

我的解答思路和尝试过的方法

我想要达到的结果

Answer 1

worksheet.write_row(1, 0, send_data1['data'])
改成
worksheet.write('A2',send_data1['data'])