XLS::Simple read xls, write xls
my $header = read_xls( 'test.xlsx', only_header => 1, ); my $data = read_xls( 'test.xlsx', skip_header => 1, ); my $all = read_xls( 'test.xlsx');
write_xls([ ['测试', '写入' ] ], 'test.xlsx', header=> ['一二', '三四'], charset=>'utf8');
To install XLS::Simple, copy and paste the appropriate command in to your terminal.
cpanm
cpanm XLS::Simple
CPAN shell
perl -MCPAN -e shell install XLS::Simple
For more information on module installation, please visit the detailed CPAN module installation guide.