dgzm.net
当前位置:首页 >> sort_vAluEs >>

sort_vAluEs

ActiveSheet.Sort.SortFields.Clear ActiveSheet.Sort.SortFields.Add Key:=Range("B:B"), _ SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNor...

my @keys = sort { $h{$b} $h{$a} } keys %h; #sort the hash table 上面的那一行就是排序的代码。程序如下: #!/usr/perl/bin use strict; use Data::Dumper; my %h=( "Alex"=>24, "Sam"=>25, "Bob"=>30, "Andy"=>11, "Wills"=>35, "Mary"=>16,...

.Worksheets(ActiveSheet.name).Sort.SortFields.Add Key:=Range("G2:G" & l _ ), SortOn:=xlSortOnValues, Order:=xlDescending, DataOption:=xlSortNormal...

网站首页 | 网站地图
All rights reserved Powered by www.dgzm.net
copyright ©right 2010-2021。
内容来自网络,如有侵犯请联系客服。zhit325@qq.com