*misc

3 files changed, 205 insertions, 0 deletions

diff --git a/Tools/XlsToCsv/man/Makefile b/Tools/XlsToCsv/man/Makefile
new file mode 100644
index 0000000..14afe2a
--- /dev/null
+++ b/Tools/XlsToCsv/man/Makefile
@@ -0,0 +1,14 @@
+# Makefile
+
+PACKAGE = xlsx2csv
+
+all: man
+
+clean:
+	rm -f *.1
+
+man:
+
+	$(MAKE) -f pod2man.mk PACKAGE=$(PACKAGE) makeman
+
+# End of file
diff --git a/Tools/XlsToCsv/man/pod2man.mk b/Tools/XlsToCsv/man/pod2man.mk
new file mode 100644
index 0000000..7c114d7
--- /dev/null
+++ b/Tools/XlsToCsv/man/pod2man.mk
@@ -0,0 +1,71 @@
+# pod2man.mk -- Makefile portion to convert *.pod files to manual pages
+#
+#   Copyright information
+#
+#	Copyright (C) 2008-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
+#
+#	Convert *.pod files to manual pages. Add this to Makefile:
+#
+#	    PACKAGE = package
+#
+#	    man:
+#		    make -f pod2man.mk PACKAGE=$(PACKAGE) makeman
+#
+#	    build: man
+
+ifneq (,)
+    This makefile requires GNU Make.
+endif
+
+# This variable *must* be set when called
+PACKAGE		?= package
+
+# Optional variables to set
+MANSECT		?= 1
+PODCENTER	?= User Commands
+PODDATE		?= $$(date "+%Y-%m-%d")
+
+# Directories
+MANSRC		?=
+MANDEST		?= $(MANSRC)
+
+MANPOD		?= $(MANSRC)$(PACKAGE).$(MANSECT).pod
+MANPAGE		?= $(MANDEST)$(PACKAGE).$(MANSECT)
+
+POD2MAN		?= pod2man
+POD2MAN_FLAGS	?= --utf8
+
+makeman: $(MANPAGE)
+
+
+$(MANPAGE): $(MANPOD)
+	# make target - create manual page from a *.pod page
+	podchecker $(MANPOD)
+	LC_ALL= LANG=C $(POD2MAN) $(POD2MAN_FLAGS) \
+		--center="$(PODCENTER)" \
+		--date="$(PODDATE)" \
+		--name="$(PACKAGE)" \
+		--section="$(MANSECT)" \
+		$(MANPOD) \
+	| sed 's,[Pp]erl v[0-9.]\+,$(PACKAGE),' \
+	  > $(MANPAGE) && \
+	rm -f pod*.tmp
+
+# End of of Makefile part
diff --git a/Tools/XlsToCsv/man/xlsx2csv.1.pod b/Tools/XlsToCsv/man/xlsx2csv.1.pod
new file mode 100644
index 0000000..788f3a8
--- /dev/null
+++ b/Tools/XlsToCsv/man/xlsx2csv.1.pod
@@ -0,0 +1,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