python操作Excelテーブル

注意:pythonがExcelテーブルを操作する場合、ファイルの接尾辞は.xlsフォーマット

#!usr/bin/env python
#-*- coding:utf-8 -*-
"""
@author:doulihang
@file: yecao.py
@time: 2019/04/11
"""
import os
import xlrd
from xlutils.copy import copy

def base_dir(filename=None):
    return os.path.join(os.path.dirname(os.path.dirname(os.path.abspath(__file__)))+"\\data\\",filename)

#    
work = xlrd.open_workbook(base_dir("dou.xls"),"w+b")
sheet = work.sheet_by_index(0)
#     
print(sheet.nrows)
#        
print(sheet.cell_value(13,0))


"""  Excel    """
#     Excel  
old_content = copy(work)
#        sheet 
ws = old_content.get_sheet(0)
#      ，      dou
ws.write(10,1,"dou")
#        
old_content.save(base_dir("dou.xls"))