import xlrd
import re
import sqlite3
import numpy as np
def read_xlsx():
workbook = xlrd.open_workbook('F:/zpcs/wordcode.xlsx')
booksheet = workbook.sheet_by_name('Sheet1')
# 获取所有sheet
print workbook.sheet_names() # [u'sheet1', u'sheet2']
# 根据sheet索引或者名称获取sheet内容
sheet2 = workbook.sheet_by_index(1) # sheet索引从0开始
sheet2 = workbook.sheet_by_name('Sheet1')
# sheet的名称,行数,列数
print sheet2.name,sheet2.nrows,sheet2.ncols
# 获取整行和整列的值(数组)
rows = sheet2.row_values(3) # 获取第四行内容
cols = sheet2.col_values(2) # 获取第三列内容
# 清洗数据,去除没有分隔符‘---’
i = 0
while i < len(cols):
if '--' in cols[i]:
writegbkucode(cols[i][0:4])
writegbkucode(cols[i][-4::1])
i += 1
#print cols[150]
#print cols[150][-4::1]
#writegbkucode(cols[i][-5:0:1])
read_xlsx()