python学习 - 读取xls文件的操作案例代码

#!/usr/bin/evn python
# -*- encoding: utf-8 -*-

import xlrd
import xlwt
import xlutils.copy


class Excels:
    def createExcel(self):
        workbook = xlwt.Workbook()
        sheet = workbook.add_sheet(u"sheet页名称", cell_overwrite_ok=True)

        sheet.write(0, 0, u"Name")  # 写入(行,列,内容)
        sheet.write(0, 1, u"age")

        sheet.write(1, 0, u"DanBrown")
        sheet.write(1, 1, u"18")

        workbook.save(u"../导出demo.xls")  # 保存 ./为当前目录 ../上级目录 /所在磁盘根目录

    def readExcel(self):
        paths = u"../导出demo.xls"
        book = xlrd.open_workbook(paths)  # 打开文件
        table = book.sheets()[0]  # 得到第一个sheet页

        row_value = table.row_values(0)  # 获取第一行数据
        col_value = table.col_values(0)  # 获取第一列数据
        value = table.cell(0, 1).value  # 获取指定格子内容

        print row_value
        print col_value
        print value

        def updataExcel(self):
            paths = u"../导出demo.xls"

        book = xlrd.open_workbook(paths)  # 打开文件

        updataBook = xlutils.copy.copy(book)  # 复制
        sheet = updataBook.get_sheet(0)  # 得到第一个sheet页

        sheet.write(1, 1, u"28")  # 将18跟新为28

        sheet.write(2, 0, u"王xx")
        sheet.write(2, 1, u"30")

        updataBook.save(u"../导出demo.xls")

    def mergeCell(self):
        workbook = xlwt.Workbook()
        sheet = workbook.add_sheet(u"sheet页名称", cell_overwrite_ok=True)
        sheet.write_merge(0, 2, 0, 1, '一年一班')
        workbook.save(u"../导出demo.xls")  # 保存 ./为当前目录 ../上级目录 /所在磁盘根目录

        book = xlwt.Workbook()  # 添加一个sheet
        sheet=book.add_sheet('sheet1') #向sheet中添加数据，行、列、value值 #合并单元格，跨行跨列
        sheet.write_merge(0,2,0,1,'一年一班')
        sheet.write(0,2,'小明')
        sheet.write(1,2,'小李')
        sheet.write(2,2,'小二哈')
        book.save('peitest.xls')
    def main(self):
        # 创建一个Excel
        self.createExcel()

        # 读取Excel内容
        self.readExcel()

        # 修改Excel内容
        self.updataExcel()
        #合并单元格
        self.mergeCell()



if __name__ == '__main__':
    excels = Excels()
    excels.main()