python 使用xlrd模块解析.xls文件

xlrd 官网

#  -*-  coding:utf-8  -*-
import xlrd
import io
import sys

#解决输出时的乱码问题
sys.stdout=io.TextIOWrapper(sys.stdout.buffer,encoding='utf8')

#获取数据
book = xlrd.open_workbook(filename=r'D:\python\businessType.xls')
#通过名称获取指定的sheet
table = book.sheet_by_name('businessType')
 
#获取总行数
nrows = table.nrows
#获取总列数
ncols = table.ncols

print("方案一")
for rindex in range(1,nrows):
    #根据下标获取指定行
    row = table.row_values(rindex)
    for cell in row:
    	#打印内容且不换行
        print(cell + " ", end="")
    print()

print("方案二")
for rindex in range(1,nrows):
    for cindex in range(ncols):
        cell_value = table.cell(rindex,cindex).value
        print(cell_value + " ",end="")
    print()


data = '';
rows = '';
rows_values = table.get_rows()

#rows_values的类型
print(type(rows_values))

print("方案三")
for row in rows_values:
    print(row[0].value + " " + row[1].value + " " + row[2].value)
    rows = row[0].value + " " + row[1].value + " " + row[2].value
    data = data + rows + '\t\n'


output = open("D:\\python\\businessType.sql","w", encoding='UTF-8')
output.writelines(data)
output.close()