xlsx2csv

Package: WA2L/WinTools 1.2.08
Section: Library Commands (3)
Updated: 24 April 2019
Index Return to Main Contents

NAME

xlsx2csv - extract individual Excel sheets as CSV output

SYNOPSIS

WA2LWinTools/lib/xlsx2csv [ -h | -l | -v ]

xlsx2csv [ -c | -n ] workbook [ worksheet ]

AVAILABILITY

WA2L/WinTools

DESCRIPTION

xlsx2csv is a tool to extract individual Excel sheets as CSV output from an Excel workbook in the .xlsx format.

CSV content is written to stdout.

OPTIONS

-h

display help

-c

display number of sheets in Excel Workbook

-l

display license

-n

display sheet names in Excel W9rkbook

-v

display version

EXIT STATUS

0

no error.

1

error.

EXAMPLES

1) get first sheet of workbook

This would get the first sheet from the workbook and save it as a CSV file:

  xlsx2csv my-workbook.xlsx "Sheet 1" > sheet1.csv

2) print number of sheets in workbook

This will output the number of sheets in the Workbook:

  xlsx2csv -c my-workbook.xlsx

3) print sheet names

This will display a list of sheet names, one per line:

  xlsx2csv -n my-workbook.xlsx

NOTES

xlsx2csv was developed by Robert S. Doiel <rsdoiel@gmail.com>. See https://rsdoiel.github.io/jsontools/xlsx2csv.html for more information.

Parts of this manual page are extracted from the web page: https://rsdoiel.github.io/jsontools/xlsx2csv.html.

BUGS

AUTHOR

xlsx2csv was developed by Robert S. Doiel <rsdoiel@gmail.com> and integrated into WA2L/WinTools by Christian Walther. Send suggestions and bug reports related to the integration to wa2l@users.sourceforge.net .

COPYRIGHT

This is free software; see WA2LWinTools/man/COPYING for copying conditions. There is ABSOLUTELY NO WARRANTY; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

This document was created by man2html using the manual pages.
Time: 16:33:24 GMT, September 14, 2024