常用模块
模块 | 功能 |
---|
xlrd | 读取excel文件数据 |
xlsxwriter/xlwd | 写excel文件 |
openpyxl | |
pip install xlrd,xlsxwriter
一、操作Excel
读取Excel内容
import xlrd
file = xlrd.open_workbook(r'filename.xls','r')
sheet = file.sheet_by_name('Sheet1')
title_list = sheet.row_values(0)
user_list = []
for row in range(1,sheet.nrows):
content = sheet.row_values(row)
zip_object = zip(title_list,content)
content_dict = dict(zip_object)
user_list.append(content_dict)
print(user_list)
二、操作googlesheet
写入数据
import pygsheets
import pandas as pd
key_path = 'xxxxx.json'
gc = pygsheets.authorize(service_file=key_path)
file_name = 'filename'
df = pd.DataFrame()
df = ['年份', '增量', '名义增长率', '排名', '排名变化']
sh = gc.open(file_name)
wks = sh[0]
wks.set_dataframe(df,(1,1))
读取数据
results = wks.get_all_records()