Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
XLSX2CSV(1)	      User Contributed Perl Documentation	   XLSX2CSV(1)

NAME
	  xlsx2csv - convert spreadsheet to CSV(s)

SYNOPSIS
	  xlsx2csv [ -A	[ -N ||	-J str ] | -o file.csv ] [-f] [-i] file.xls
	  xlsx2csv   --help | --man | --info

DESCRIPTION
       Convert a spreadsheet (all formats supported by Spreadsheet::Read) to
       CSV (using Text::CSV_XS).

OPTIONS
       -?
       --help
	   Print short usage and exit.

       --man
	   Print this help using nroff and exit.

       --info
	   Print this help and exit.

       -V
       --version
	   Print the version and exit.

       -f
       --force
	   Overwrite existing output file.

       -A
       --all
	   Output data from all	sheets.

	   Each	sheet will go to extra file with name built from output	CSV-
	   file	and sheet name.

       -N
       --no-pfx
	   If specified, dump all will not use output CSV-file but sheet name
	   only.

       -J str
       --join=str
	   If specified, output	file names under "-A" will join	on "str"
	   instead of the default "-".

       -o CSV-file
       -c CSV-file
       --out=CSV-file
	   Output file name (used only with "--all" and	without	"--no-pfx").

	   Default value is derived from XLS-file.

       -i XLS-file
       -s XLS-file
       --in=XLS-file
	   Allows to specify input xls file.

	   Default: Last ARGUMENT file that exists.

SEE ALSO
       Spreadsheet::Read, Text::CSV_XS,	xlscat

AUTHOR
       H.Merijn	Brand <perl5@tux.freedom.nl>

COPYRIGHT AND LICENSE
       Copyright (C) 2008-2021 H.Merijn	Brand

       This library is free software; you can redistribute it and/or modify it
       under the same terms as Perl itself.

perl v5.32.1			  2021-01-01			   XLSX2CSV(1)

NAME | SYNOPSIS | DESCRIPTION | OPTIONS | SEE ALSO | AUTHOR | COPYRIGHT AND LICENSE

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=xlsx2csv&sektion=1&manpath=FreeBSD+13.0-RELEASE+and+Ports>

home | help