Python获取excel表格数据例子
# -*- coding: utf-8 -*-# 通过excel文件信息生成配置文件
import xlrd
def get_info(row_num):
workbook = xlrd.open_workbook(u'表格数据.xlsx')
booksheet = workbook.sheets()
total_rows = int(booksheet.nrows)
begin_row = int(total_rows) - row_num
total_data = []
for n in range(begin_row,total_rows):
total_data.append(booksheet.row_values(n))
zone_list = []
world_id_list = []
local_ip_list = []
inter_ip_list = []
open_server_time = []
for x in total_data:
zone_list.append(x[-3])
world_id_list.append(x[-2])
local_ip_list.append(x)
inter_ip_list.append(x)
open_server_time.append(x[-1])
return zone_list,world_id_list,local_ip_list,inter_ip_list,open_server_time
页:
[1]