python xlsx追加数据_如何在已有的xlsx表中追加一些数据？

我想将我的数据库信息存储到xlsx文件中。我用python创建了以下程序。在import xlsxwriter

def create_xlsx_file():

workbook = xlsxwriter.Workbook('/home/script/report.xlsx')

worksheet = workbook.add_worksheet()

data = ['DataBase Name', 'Total Images', 'Gallary Name', 'Subject Name']

r = 0

c = 0

for i in data:

worksheet.set_column(c,c, 20)

bold = workbook.add_format({'bold': True})

worksheet.write(r, c, i)

c = c + 1

workbook.close()

def add_info_into_file(DataBase_Name, Total_Images, Gallary_Name, Subject_Name):

workbook = xlsxwriter.Workbook('/home/script/report.xlsx')

worksheet = workbook.add_worksheet()

data = [DataBase_Name, Total_Images, Gallary_Name, Subject_Name]

r = 2

c = 0

for i in data:

worksheet.set_column(c,c, 20)

bold = workbook.add_format({'bold': True})

worksheet.write(r, c, i)

c = c + 1

workbook.close()

create_xlsx_file()

add_info_into_file("msc", 100, "Mat", "rsp")

在上面的程序中，如果我调用add_info_into_file()函数，则现有数据将被截断。那么，如何在现有的工作表中追加一些数据呢？在

拜托，有人帮帮我。提前谢谢。在