GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages
XLS2CSV(1) User Contributed Perl Documentation XLS2CSV(1)

   xlsx2csv - convert spreadsheet to CSV(s)

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

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

-?
--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.

Spreadsheet::Read, Text::CSV_XS, xlscat

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

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.

2021-01-01 perl v5.32.1

Search for    or go to Top of page |  Section 1 |  Main Index

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with ManDoc.