perl使用Spreadsheet::SimpleExcel实现降序升序排列顺序

发布时间：2020-12-15 23:55:13 所属栏目：大数据来源：网络整理

导读：http://search.cpan.org/~reneeb/Spreadsheet-SimpleExcel-1.9/lib/Spreadsheet/SimpleExcel.pm#set_headers $excel-sort_data('Name of Worksheet',1,'ASC'); $excel-sort_data('Name of Worksheet','DESC'); sort_data # sort data of worksheet - ASC or

http://search.cpan.org/~reneeb/Spreadsheet-SimpleExcel-1.9/lib/Spreadsheet/SimpleExcel.pm#set_headers
$excel->sort_data('Name of Worksheet',1,'ASC');

$excel->sort_data('Name of Worksheet','DESC');

sort_data

  # sort data of worksheet - ASC or DESC
  $excel->sort_data('Name of Worksheet','DESC');

sort_data sorts the rows. All sorts for one worksheet are combined,so

  $excel->sort_data('Name of Worksheet','DESC');
  $excel->sort_data('Name of Worksheet','ASC');

will sort the column 0 first and then (within this sorted data) the column 1.

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!