python excel xlsx写入_excel – Python Xlsx Writer – 将字符串写入新行

我正在使用xlsxwriter工具从用户输入将一些数据写入.xlsx.

(我对编程很新,所以很抱歉,如果我的代码很糟糕,如果你建议/纠正我犯过的任何错误,我将不胜感激！抱歉！)

以下是当前的代码：

但是,我在将数据写入新行而不是替换前一行时遇到一些问题,因此.xlsx最终成为用户数据的集合.

import getpass

import os

import xlsxwriter

print('Hello, please answer the follow questions to complete your registration.')

userfirstname = input('Please enter your FIRST name.\n')

print('Thank you, %s' % userfirstname, )

userlastname = input('Please enter your LAST name.\n')

print('Thank you %s' % userfirstname, '%s' % userlastname)

userage = input('Please enter your AGE.\n')

print('Thank you %s' % userfirstname, '%s' % userlastname)

username = input('Please enter your desired USER NAME.\n')

print('Thank you %s' % userfirstname, '%s' % userlastname, 'Your chosen username is %s' % username)

#Within this section, a database scan must take place to check current used usernames and text match

userpwd = getpass.getpass('Please enter your desired PASSWORD.\n')

print('Thank you %s' % userfirstname, '%s' % userlastname)

#within this section, a application password authentication must take place to fit password criteria

usermailid = input('Please enter the email address you wish to register with.\n')

print('Your chosen registration email address is: %s' % usermailid)

#Within this section, a database scan must take place to check current registered mail addresses and text match

#User Database .xlsx

workbook =xlsxwriter.Workbook('UserDatabase.xlsx')

worksheet = workbook.add_worksheet()

worksheet.set_column('A:A',20)

worksheet.set_column('B:B',20)

worksheet.set_column('C:C',20)

worksheet.set_column('D:D',20)

worksheet.set_column('E:E',20)

worksheet.set_column('F:F',20)

worksheet.write('A1', 'First Name')

worksheet.write('B1', 'Last Name')

worksheet.write('C1', 'Age')

worksheet.write('D1', 'User Name')

worksheet.write('E1', 'Password')

worksheet.write('F1', 'Email ID')

worksheet.write_string( , userfirstname)

worksheet.write_string('', userlastname)

worksheet.write_string('', userage)

worksheet.write_string('', username)

worksheet.write_string('', userpwd)

worksheet.write_string('', usermailid)

workbook.close()

所以从这里开始,使用列标题创建了一个可爱的.xlsx,而第二行创建了一个非常棒的用户数据.

worksheet.write_string(

我需要知道如何指定如何将字符串写入新行,或者可能需要一些条件格式来说明“如果行已包含文本然后写入下一个空行”等.

如果你知道一个更好的工具而不是xlsxwriter,请随时告诉我！

谢谢 ：)