xlsx操作

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()