Xls2csv - Revision history

Christoph: /* Transpose csv files */

2007-05-17T05:00:10Z

‎Transpose csv files

Christoph at 04:59, 17 May 2007

2007-05-17T04:59:42Z

Christoph: /* Install */

2007-05-17T01:42:43Z

‎Install

Christoph at 01:42, 17 May 2007

2007-05-17T01:42:12Z

Christoph at 04:58, 11 March 2007

2007-03-11T04:58:58Z

Christoph at 09:59, 2 January 2007

2007-01-02T09:59:00Z

New page

{{lowercase|xls2csv}}
'''xls2csv''' is a [[:Category:Linux Command Line Tools|command line]] script that recodes a spreadsheet's charset and saves as CSV. It was written by Ken Prows.

== Basic usage ==
The following example will convert a spreadsheet that is in the WINDOWS-1252 character set (WinLatin1) and save it as a csv file in the UTF-8 character set.

xls2csv -x "1252spreadsheet.xls" -b WINDOWS-1252 -c "ut8csvfile.csv" -a UTF-8

This example with convert the worksheet named "Users" in the given spreadsheet.

xls2csv -x "multi_worksheet_spreadsheet.xls" -w "Users" -c "users.csv"

==Options==
-x : filename of the source spreadsheet
-b : the character set the source spreadsheet is in (before)
-c : the filename to save the generated csv file as
-a : the character set the csv file should be converted to (after)
-q : quiet mode
-s : print a list of supported character sets
-h : print help message
-v : get version information
-W : list worksheets in the spreadsheet specified by -x
-w : specify the worksheet name to convert (defaults to the first worksheet)

== See also ==
* [[CPAN]]

== External links ==
* [http://search.cpan.org/~ken/xls2csv-1.06/script/xls2csv CPAN.org - xls2csv]

[[Category:Linux Command Line Tools]]

@@ Line 31: / Line 31: @@
   -w : specify the worksheet name to convert (defaults to the first worksheet)
-==Transpose csv files==
+==Transpose CSV files==
-If you need to transpose your csv matrix before using it (i.e., rows->columns and columns->rows), try the following little [[Perl]] script:
+If you need to transpose your CSV matrix before using it (i.e., rows->columns and columns->rows), try the following little [[Perl]] script:
   # Example CSV file
   # FROM:

@@ Line 6: / Line 6: @@
   perl -MCPAN -e "install Unicode::Map"
   perl -MCPAN -e "install Spreadsheet::ParseExcel"
-  perl -MCPAN -e "install Spreadsheet::ParseExcel::FmtUnicode" (should be included with Spreadsheet::ParseExcel)
+  perl -MCPAN -e "install Spreadsheet::ParseExcel::FmtUnicode" # should be included with Spreadsheet::ParseExcel
   perl -MCPAN -e "install Text::CSV_XS"

@@ Line 1: / Line 1: @@
 '''xls2csv''' is a [[:Category:Linux Command Line Tools|command line]] script that recodes a spreadsheet's charset and saves as CSV. It was written by Ken Prows.
@@ Line 11: / Line 10: @@
   wget http://search.cpan.org/CPAN/authors/id/K/KE/KEN/xls2csv-1.06.tar.gz
-== Basic usage ==
+==Basic usage==
 The following example will convert a spreadsheet that is in the WINDOWS-1252 character set (WinLatin1) and save it as a csv file in the UTF-8 character set.
@@ Line 21: / Line 20: @@
 ==Options==
-  -x     : filename of the source spreadsheet
+  -x : filename of the source spreadsheet
-  -b     : the character set the source spreadsheet is in (before)
+  -b : the character set the source spreadsheet is in (before)
-  -c     : the filename to save the generated csv file as
+  -c : the filename to save the generated csv file as
-  -a     : the character set the csv file should be converted to (after)
+  -a : the character set the csv file should be converted to (after)
-  -q     : quiet mode
+  -q : quiet mode
-  -s     : print a list of supported character sets
+  -s : print a list of supported character sets
-  -h     : print help message
+  -h : print help message
-  -v     : get version information
+  -v : get version information
-  -W     : list worksheets in the spreadsheet specified by -x
+  -W : list worksheets in the spreadsheet specified by -x
-  -w     : specify the worksheet name to convert (defaults to the first worksheet)
+  -w : specify the worksheet name to convert (defaults to the first worksheet)
 ==Transpose csv files==
@@ Line 43: / Line 42: @@
   #  a3,b3
-  perl -e '$unequal=0;$_=<>;s/\r?\n//;@out_rows=split(/\,/, $_);\
+  perl -e'$unequal=0;$_=<>;s/\r?\n//;@out_rows=split(/\,/, $_);\
   $num_out_rows=$#out_rows+1;while(<>){s/\r?\n//;@F=split(/\,/,$_);\
-  foreach $i (0 .. $#F){$out_rows[$i] .="\,$F[$i]";}if($num_out_rows !=$#F+1){\
+  foreach $i(0 .. $#F){$out_rows[$i] .="\,$F[$i]";}if($num_out_rows !=$#F+1){\
   $unequal=1;}}END{foreach $row (@out_rows){print"$row\n"}\
   warn "\nWARNING! Rows in input had different numbers of columns\n" if $unequal;\
-  warn "\nTransposed table: result has $. columns and $num_out_rows rows\n\n" }' $1
+  warn "\nTransposed table: result has $. columns and $num_out_rows rows\n\n"}' $1
 ==See also==

@@ Line 32: / Line 32: @@
   -w     : specify the worksheet name to convert (defaults to the first worksheet)
-== See also ==
+==Transpose csv files==
-* [[CPAN]]
+If you need to transpose your csv matrix before using it (i.e., rows->columns and columns->rows), try the following little [[Perl]] script:
-== External links ==
+ perl -e '$unequal=0;$_=<>;s/\r?\n//;@out_rows=split(/\,/, $_);\
-* [http://search.cpan.org/~ken/xls2csv-1.06/script/xls2csv CPAN.org - xls2csv]
+ $num_out_rows=$#out_rows+1;while(<>){s/\r?\n//;@F=split(/\,/,$_);\
 [[Category:Linux Command Line Tools]]