小工具:xls2csv

Prefix

xls2csv

xls2csv is a perl script to convert xls to csv.

installation

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
[root@localhost] perl -MCPAN -e shell
cpan> install Locale::Recode
cpan> install Unicode::Map
cpan> install Spreadsheet::ParseExcel
cpan> install Text::CSV_XS
cpan> q
[root@localhost] wget https://cpan.metacpan.org/authors/id/K/KE/KEN/xls2csv-1.07.tar.gz
[root@localhost] tar -zxvf xls2csv-1.07.tar.gz
[root@localhost] cd xls2csv-1.07
[root@localhost] perl Makefile.pl
[root@localhost] make
[root@localhost] make test
[root@localhost] make install
[root@localhost] whereis xls2csv
[root@localhost] which xls2csv

Usage

type xls2csv -h to get help from xls2csv inside.

1
[root@localhost] xls2csv -x file.xls -b encoding_type -c output.csv -b encoding_type