‘xlrd’ and ‘xlwt’ in Python

‘xlrd‘ and ‘xlwt‘ are two Python tripartite library for working with Excel files.

xlrd

Responsible for reading files.

• Open up the Excel files

  workbook = xlrd.open_workbook(path)

• Get all sheets of file

  workbook.sheet_names()

• Get the sheet and content

    # Get sheet by index
    sheet2 = workbook.sheet_by_index(1)
    
    # Get sheet by name
    sheet2 = workbook.sheet_by_name('sheet2')
    
    # Get content
    sheet2.name
    sheet2.nrows
  sheet2.ncols
    
    sheet2.row_values(index)
    sheet2.col_values(index)

xlwt

Responsible for write files.

Issue

• Excel xlsx file not supported

  Change the version of ‘xlrd’, it has been updated to 2.0.1 and only supports .xls files, not .xlsx

  pip install xlrd==1.2.0

• If file path has Chinese, ‘open’ operation needs to be transcoded.

  1. The prefix ‘r’ to path indicates the native string.
  2. filename = filename.decode(‘utf-8’)

References

python里面的xlrd模块详解（一）

Python中xlrd和xlwt模块使用方法