配置文件越来越多,人工运营容易出错,根据一些规则来进行检测就比较有需要了,这个时候使用python就能比较快的进行对应的检查,这里简单介绍一些如何使用python来读取xls文件。
老规矩,先来一段代码:
# -*- coding:utf-8 -*-
import xlrd
def main():
xlsFile = xlrd.open_workbook("test.xls")
sheets = xlsFile.sheet_names()
print "xls has %d sheets" % xlsFile.nsheets
for sheetName in sheets:
printSheet(xlsFile, sheetName)
def printSheet(oXls, sheetName):
sheetIsEmpty = True
tmpSheet = oXls.sheet_by_name(sheetName)
tmpLine = ""
for row in range(tmpSheet.nrows):
for col in range(tmpSheet.ncols):
if tmpSheet.cell(row, col).value != None:
sheetIsEmpty = False
try:
tmpLine += str(tmpSheet.cell(row, col).value) + "\t"
except:
tmpLine += tmpSheet.cell(row, col).va