How do you write a string in Excel using Python?

I am trying to open an Excel spreadsheet and save the data to a new spreadsheet using Python.

The spreadsheet should contain rows of data separated by colons and each row should contain one string separated by spaces. However, I am getting errors when I try to do this. Here is my code:
Import xlwt. Workbook = xlwt.Workbook() worksheet = workbook.addsheet("Loan Application") worksheet.write(0, "Loan Number") worksheet.write(0, 1, "Amount") worksheet.write(0, 2, "Loan Type") worksheet.write(0, 3, "Loan Product") worksheet.write(0, 4, "Scheduled Amount") worksheet.write(0, 5, "Scheduled Interest") worksheet.write(0, 6, "Monthly Payment") worksheet.write(0, 7, "Monthly Rate") worksheet.write(0, 8, "Term") worksheet.write(0, 9, "Prepayment Penalty") worksheet.write(0, 10, "Amortization Payment") worksheet.write(0, 11, "Installment") worksheet.write(0, 12, "Current Payment") worksheet.write(0, 13, "Total Payment") worksheet.write(0, 14, "New Loan Purpose") worksheet.write(0, 15, "Current Interest Rate") worksheet.write(0, 16, "Current Balance") worksheet.write(0, 17, "Date Entered") worksheet.write(0, 18, "Last Updated") worksheet.write(0, 19, "Comments") worksheet.write(1, 0, "Loan Number") worksheet.write(1, "Amount") worksheet.write(1, 2, "Loan Type") worksheet.write(1, 3, "Loan Product") worksheet.write(1, 4, "Scheduled Amount") worksheet.write(1, 5, "Scheduled Interest") worksheet.write(1, 6, "Monthly Payment")

How to write in an existing Excel sheet using Python?

I have a set of data that I want to write to an Excel sheet from Python.

I know how to do it using the .xls file module:
Import openpyxl. Wb = openpyxl.loadworkbook(path) ws = wb.cell(row=1, column=1) cell.value = data wb.save("test.xls")
However, is there a way to do this from within an existing Excel file? I don't want to save the workbook as a new .xls file and want to keep the existing Excel file.

Import xlwt. File = 'D:/someexistingfile.xls' wb = xlwt.Workbook() sheet = wb.addsheet('Some new sheet') for row in range(1,2): cell = sheet.cell(row=row, column=1) cell.value = 'foobar' wb.save(file) You can read Excel files directly using the xlrd library: import xlrd.

Doc = xlrd.openworkbook(filename)