python给excel排序_python3实现excel里面读数据进行排序

一、数据：名称空气质量污染程度其他得分

上海44.58.15194914.4615467.11349

北京348.09523815.1587357.25397

广州3310.2336413.2710356.50467

成都38.510.212915.9440664.65695

武汉42.513.2679618.5227374.29069

南京507.46145214.6357672.09721

重庆5011.1609915.2112776.37226

南昌48.512.391317.8260978.71739

贵阳49.5302099.5

二、处理脚本：#!/usr/bin/env python3

# -*- coding: utf-8 -*-

'''

使用python对数据排序。

# date 2016-11-10

'''

import xlrd

def Read_execl_ranking(FileName,WorkTable='Sheet1'):

#对数据排序，优化版本。

workbook = xlrd.open_workbook(FileName)

sheet_name = workbook.sheet_names()[1]

sheet = workbook.sheet_by_index(1)

sheet = workbook.sheet_by_name(WorkTable)

print ("各项排名！")

print ('-'*20)

for j in range(1,sheet.ncols):

lie = {}

print (sheet.cell(0,j).value+"：")

for i in range(1,sheet.nrows):

lie[sheet.cell(i,0).value] = sheet.cell(i,j).value

i = i+1

newlie = sorted(lie.items(),key = lambda d:d[1],reverse = True)

for i in range(0,len(newlie)):

print (newlie[i][0]+":"+str(newlie[i][1])+"分，" ,end = ' ')

i = i+1

print ("")

if __name__ == "__main__":

FileName=r'execl_test.xlsx'

Read_execl_ranking(FileName=FileName,WorkTable='Sheet4')

三、结果图：