1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
|
# Copyright
#
# Copyright (C) 2011-2012 Jari Aalto
#
# License
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; either version 2 of the License, or
# (at your option) any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program. If not, see <http://www.gnu.org/licenses/>.
#
# Description
#
# To learn what TOP LEVEL sections to use in manual page,
# see POSIX/Susv standard about "Utility Description Defaults" at
# http://www.opengroup.org/onlinepubs/009695399/utilities/xcu_chap01.html#tag_01_11
#
# This manual page in Perl POD format. Read more at
# http://perldoc.perl.org/perlpod.html or run command:
#
# perldoc perlpod | less
#
# To check the syntax:
#
# podchecker *.pod
#
# To create manual:
#
# pod2man PROGRAM.N.pod > PROGRAM.N
=pod
=head1 NAME
xlsx2csv - Convert xlsx xml files to csv format
=head1 SYNOPSIS
xlsx2csv [options] INFILE [OUTPUT FILE]
=head1 DESCRIPTION
The conversion uses Expat SAX parser for xml processing.
=head1 OPTIONS
=over 4
=item B<-d DELIMITER, --delimiter=DELIMITER>
Output csv columns delimiter. Use "tab" or "x09" for
tab. Defaults to comma.
=item B<-f DATEFORMAT, --dateformat=DATEFORMAT>
Set date/time format. See strftime(3) for %-format specifiers. An
example "%Y-%m-%d".
=item B<-i, --ignoreempty>
Skip empty lines.
=item B<-p SHEETDELIMITER, --sheetdelimiter=SHEETDELIMITER>
Sheet delimiter used to separate sheets, pass "" if you don't want
delimiters. DEfaults to "--------".
=item B<-q QUOTING, --quoting=QUOTING>
Output csv fields quoting. Use "none" "minimal" "nonnumeric" or "all".
Defaults to none.
=item B<-r, --recursive>
Convert recursively.
=item B<-s SHEETID, --sheet=SHEETID>
Sheet to convert (0 for all sheets).
=item B<-h, --help>
Display short help and exit.
=item B<--version>
Display program's version number and exit.
=back
=head1 ENVIRONMENT
None.
=head1 FILES
None.
=head1 SEE ALSO
catdoc(1)
=head1 AUTHORS
Program was written by Dilshod Temirkhodjaev <tdilshod@gmail.com>
This manual page was written by Jari Aalto <jari.aalto@cante.net>. Released
under license GNU GPL version 2 or (at your option) any later
version. For more information about the license, visit
<http://www.gnu.org/copyleft/gpl.html>.
=cut
|
