python操作EXCEL之xlrd，xlwt的使用

https://blog.csdn.net/chengxuyuanyonghu/article/details/54951399

https://www.cnblogs.com/zhaoyingjie/p/6554858.html

https://www.cnblogs.com/nancyzhu/p/8401552.html

一、安装

pip install xlrd 读

pip install xlwt 写

二、xlrd使用介绍

    1、导入模块
        import xlrd
   2、打开Excel文件读取数据
        data = xlrd.open_workbook('excelFile.xls')
   3、使用技巧
        获取一个工作表
        table = data.sheets()[0]          #通过索引顺序获取
        table = data.sheet_by_index(0) #通过索引顺序获取
        table = data.sheet_by_name(u'Sheet1')#通过名称获取

        获取整行和整列的值（数组）　　
        table.row_values(i)
        table.col_values(i)
 
        获取行数和列数　　
        nrows = table.nrows 
        ncols = table.ncols
       
        循环行列表数据
        for i in range(nrows):
               print table.row_values(i)
 
        单元格
        cell_A1 = table.cell(0,0).value
        cell_C4 = table.cell(2,3).value
 
        使用行列索引
        cell_A1 = table.row(0)[0].value
        cell_A2 = table.col(1)[0].value
 
        简单的写入
        row = 0
        col = 0
 
        # 类型 0 empty,1 string, 2 number, 3 date, 4 boolean, 5 error
        ctype = 1 value = '单元格的值'
        xf = 0 # 扩展的格式化
        table.put_cell(row, col, ctype, value, xf)
        table.cell(0,0)  #单元格的值'
        table.cell(0,0).value #单元格的值'

 

三 xlwt操作

import xlwt
#只能写不能读
stus = [['姓名', '年龄', '性别', '分数'],
        ['mary', 20, '女', 89.9],
        ['mary', 20, '女', 89.9],
        ['mary', 20, '女', 89.9],
        ['mary', 20, '女', 89.9]
        ]
book = xlwt.Workbook()#新建一个excel
sheet = book.add_sheet('case1_sheet')#添加一个sheet页
row = 0#控制行
for stu in stus:
    col = 0#控制列
    for s in stu:#再循环里面list的值，每一列
        sheet.write(row,col,s)
        col+=1
    row+=1
book.save('stu_1.xls')#保存到当前目录下

 

 

 

 

 

 

 

 

Python错误：IndentationError:unindent does not match any outer indentation level 缩进问题

ValueError: I/O operation on closed file 的解决办法   缩进问题