Python read/write XLS

Library Required:

XLRD, XLWT, xlutils

Import

Import xlrd  from Import Copy

Open File

data = Xlrd.open_workbook (R'E:\work\Text id.xls'= data.sheet_by_name (U')  Sheet1')

Read the value of a cell

Textid = Table.cell (i,0). Value

Write value

Table.put_cell (row,col,1, "string", 0)

Add some Notes

# Simple Write to row =#  type 0 empty,1 string, 2 number, 3 date, 4 Boolean, 5 error' 
     Cell Value '#  Extended formatted Table.put_cell (Row, col, CType, value, XF)

Writing to the file requires Xlwt,xlutils

WB = Copy (data) wb.save ('e:/work/result.xls')

Python read/write XLS