Read and write Excel tables in Python

1 #!usr/bin/env python2 #-*-coding:utf-8-*-3 Importxlrd4 ImportXLWT5  fromXlutils.copyImportCopy6 ImportOS7 8data = Xlrd.open_workbook ('M3000.xls')#open an Excel table9Table = data.sheets () [0]#The sheet read by this method is read-only and cannot be writtenTenrows =table.nrows OneNcols =Table.ncols A  -datanew = copy (data)#copy a new Excel table -sheetnew = Datanew.get_sheet (0)#The sheet read by this method can be written the  - defrxcel (rows): -      forRinchRange (rows-1): -str = Table.cell (r+1,1). Value +num=len (str) -Sheetnew.write (r+1,7, num) +Os.remove ('M3000.xls')#The old Excel table was deleted ADatanew.save ('M3000.xls')#in the original position, re-save a table with the original table name at      - if __name__=='__main__': -Rxcel (rows)

Read and write Excel tables in Python