#coding=utf-8
import xlrd
import json
import csv
#地址前用'\'转译符要加
workbook=xlrd.open_workbook('D:/untitled/1022/date.xls')
#提取表格名称
sheets=workbook.sheet_names()
#提取第一个表格内容
worksheet=workbook.sheet_by_name((sheets[0]))
#统计有多少行
worksheet.nrows
#统计有多少列
worksheet.ncols
#遍历所以单元格
for i in range(worksheet.nrows):
for j in range(worksheet.ncols):
print(worksheet.cell_value(i,j),'\t',end='')
print('')
#json load(filed)出来直接是对象
with open('D:/untitled/1022/date.json','r',encoding='utf-8') as filed:
filedd = json.load(filed)
print(filedd)
#csv.DictReader(fils)出来是首行对应值字典
with open('D:/untitled/1022/date.csv','r',encoding='utf-8') as fils:
global jsonlist
jsonlist = []
reader=csv.DictReader(fils)
for i in reader:
print(i)
#转换成字典
print(dict(i))
jsonlist.append(dict(i))
with open('D:/untitled/1022/date.csv','r',encoding='utf-8') as fils:
#不能提取第一行
reader=csv.reader(fils)
for i in reader:
print(i)