xlrdでpythonからexcelファイルを操作する（個人的メモ） - Qiita# coding: utf-8 from xlrd import open_workbook, XL_CELL_TEXT , cellname import re from datetime import datetime wtdlist = ('月', '火', '水' , '木', '金', '土', '日' ) wb = open_workbook('test.xls') outfile = open('bscs_rate', 'w', 1000 ) for s in wb.sheets(): print 'Sheet:',s .name channel = s .cell(0 ,0 ).value # date -> 2014-02-01 ymd = s .cell(0 ,26 ).value s_date, others = ymd.strip().split( '（') tda
IndexError with merged cells that extend beyond right edge of non-merged data · Issue #129 · python-excel/xlrd · GitHub
