太赞！Python和Excel终于可以互通了

正文

请到「今天看啥」查看全文

(line)
file_obj. close ()
returnres_list
"" "
function：
读出*.xlsx中的每一条记录，把它保存在data_dic中返回
Param:
excel_name: 要读出的文件名
Return:
data_dic：返回的记录的dict
" ""
defread_excel_with_openpyxl(self, excel_name= "testexcel2007.xlsx" ):
# 读取excel2007文件
wb = load_workbook(filename=excel_name)
# 显示有多少张表
print "Worksheet range(s):" , wb.get_named_ranges()
print "Worksheet name(s):" , wb.get_sheet_names()
# 取第一张表
sheetnames = wb.get_sheet_names()
ws = wb.get_sheet_by_name(sheetnames[ 0 ])
# 显示表名，表行数，表列数
print "Work Sheet Titile:" ,ws.title
print "Work Sheet Rows:" ,ws.get_highest_row()
print "Work Sheet Cols:" ,ws.get_highest_column()
# 获取读入的excel表格的有多少行，有多少列
row_num=ws.get_highest_row()
col_num=ws.get_highest_column()
print "row_num: " ,row_num, " col_num: " ,col_num
# 建立存储数据的字典
data_dic = {}
sign= 1
# 把数据存到字典中
forrowinws.rows:
temp_list=[]
# print "row" ,row
forcellinrow:
printcell.value,
temp_list. append (cell.value)
print ""
data_dic[sign]=temp_list
sign+= 1
printdata_dic
returndata_dic
"" "
function：
读出*.xlsx中的每一条记录，把它保存在data_dic中返回
Param:
records: 要保存的，一个包含每一条记录的list
save_excel_name: 保存为的文件名
head_row_stu_arrive_star:
Return:
data_dic：返回的记录的dict
" ""
defwrite_to_excel_with_openpyxl(self,records,head_row,save_excel_name= "save.xlsx" ):
# 新建一个workbook
wb = Workbook()
# 新建一个excelWriter
ew = ExcelWriter(workbook=wb)
# 设置文件输出路径与名称
dest_filename = save_excel_name.decode( 'utf-8'

请到「今天看啥」查看全文