Python's Excel file append content

The first thing to install is three modules: Xlrd,xlwt,xlutils

Command: Pip install xlrd XLWT xlutils

Example code:

1 #!/usr/bin/env python2 #-*-coding:utf-8-*-3 4  fromXlrdImportOpen_workbook5  fromXlutils.copyImportCopy6 7R_xls = Open_workbook ("Test.xls")#reading Excel Files8row = R_xls.sheets () [0].nrows#get the number of rows that are already there9Excel = Copy (R_xls)#Converts an object of Xlrd to a XLWT objectTenTable = Excel.get_sheet (0)#get the sheet to manipulate One  A #append a row to an Excel table -Table.write (row, 0,'Content 1')#the number of rows, columns, and contents in parentheses, respectively -Table.write (row, 1,'Content 2') theTable.write (Row, 2,'Content 3') -  -Excel.save ("Test.xls")#save and overwrite files

Python's Excel file append content