Python3.x学习笔记[3]通过Py

import xlrd
import re


wb = xlrd.open_workbook('1.xls') # 打开文件

sh = wb.sheet_by_name('考试成绩')


sh=wb.sheet_by_index(0)#第一个表

sheetNames = wb.sheet_names() # 查看包含的工作表

# 获得工作表的两种方法
sh = wb.sheet_by_index(0)
sh = wb.sheet_by_name(u'Sheet1')

# 单元格的值
cellA1 = sh.cell(0,0)
cellA1Value = cellA1.value



# 第一列的值
columnValueList = sh.col_values(0) 

import xlwt
import re


wbk = xlwt.Workbook()

sheet1 = wbk.add_sheet('sheet 1')

sheet1.write(0,1,'test text')
# 修改内容警告解决方式：使用cell_overwrite_ok=True来创建worksheet:
# sheet2 =  wbk.add_sheet('sheet 2', cell_overwrite_ok=True)
wbk.save('test.xls')

from openpyxl.reader.excel import load_workbook


wb = load_workbook('dd.xlsx')


sheetnames = wb.get_sheet_names()
ws = wb.get_sheet_by_name(sheetnames[0])

data_dic = {}    # 建立存储数据的字典     

#把数据存到字典中   
for  rx  in  range(ws.get_highest_row()):  
      
    temp_list = []  
    pid = ws.cell(row = rx,column = 0 ).value  
    w1 = ws.cell(row = rx,column = 1 ).value  
    w2 = ws.cell(row = rx,column = 2 ).value  
    w3 = ws.cell(row = rx,column = 3 ).value  
    w4 = ws.cell(row = rx,column = 4 ).value  
    temp_list = [w1,w2,w3,w4]  
     
    data_dic[pid] = temp_list  
  
#打印字典数据个数   
print   (data_dic[10124020117])