How to read and write excel files in python

Python mainly uses the two libraries xlrd and xlwt to operate excel, that is, xlrd is a library for reading excel, and xlwt is a library for writing excel. The following records python reading excel.

python reading excel——xlrd

There are several troublesome problems in this process, such as reading date, reading Merge cell contents. Let’s take a look at the basic operations:

First read an excel file with two sheets. Use the second sheet for testing. The content of sheet2 is as follows:

python’s basic operations on excel are as follows:

# -*- coding: utf-8 -*-import xlrd
import xlwtfrom datetime import date,datetimedef read_excel():    # 打开文件
    workbook = xlrd.open_workbook(r'F:\demo.xlsx')    # 获取所有sheet
    print workbook.sheet_names() # [u'sheet1', u'sheet2']
    sheet2_name = workbook.sheet_names()[1]    # 根据sheet索引或者名称获取sheet内容
    sheet2 = workbook.sheet_by_index(1) # sheet索引从0开始
    sheet2 = workbook.sheet_by_name('sheet2')    # sheet的名称，行数，列数
    print sheet2.name,sheet2.nrows,sheet2.ncols    # 获取整行和整列的值（数组）
    rows = sheet2.row_values(3) # 获取第四行内容
    cols = sheet2.col_values(2) # 获取第三列内容
    print rows    print cols    # 获取单元格内容
    print sheet2.cell(1,0).value.encode('utf-8')    print sheet2.cell_value(1,0).encode('utf-8')    print sheet2.row(1)[0].value.encode('utf-8')    
    # 获取单元格内容的数据类型
    print sheet2.cell(1,0).ctypeif __name__ == '__main__':
    read_excel()

The running results are as follows:

The above is the detailed content of How to read and write excel files in python. For more information, please follow other related articles on the PHP Chinese website!