def write_data(data):
import openpyxl
try:
workbook = openpyxl.load_workbook(“test.xlsx”)
except Exception as e:
workbook = openpyxl.Workbook()
worksheet = workbook.active
worksheet.title = “test.xlsx”
worksheet.append([“关键字”, “页码”, “排名”, “url”])
worksheet = workbook.worksheets[0]
worksheet.append(data)
workbook.save(filename="test.xlsx")
def read_data():
import xlrd
xl = xlrd.open_workbook(“table1.xlsx”)
table = xl.sheets()[0]
print(table.col_values(1, 5))
return table.col_values(1, 5)
read_data()