There is also a utility 'xls2csv' that does the job nicely. Its part of package 'catdoc' and should be in a repository of most popular distros.
on RH variants:
Hi,
I have a file coming in xxx.txt(csv format) i do some work on it and i need to send out as a .xls format. Is there any way there is some code i can use in my script to convert this?
I'm struggling on this.
Thanks (11 Replies)
Hi does anybody know how to convert xls to csv undex linux.
I need only data (that is log from test, dont need any macro and so on) from xls.
Any idea how to do that? Perl? shell? Could you give me any example?
Thanks in advance for answer.
Gracjan (4 Replies)
Hi,
i don't know anything about PERL. Can anyone help me providing PERL scripts for
1. converting XLS to CSV (and vice-versa)
2. converting DOC/RTF to TXT
Thanks much
Prvn (1 Reply)
Hi All,
I have a java program running in AIX machine which gives me the output in form of .CSV but my clients wants output in the form of .xls
When I gave the command mv <filename.csv> <filename.xls>
The contents of this .xls file is not exactly in seprate columns as in CSV, the contents... (1 Reply)
Hi
I wanted to convert some XLS files into CSV format in my UNIX box. Unix box is handling very important data which are related to data warehouse.It is fully optimized by installing minimum packages since server need more resources to handle reports generating.
Just for convert XLS files... (6 Replies)
Hi All,
I've got in a situation where I need to convert .xlsx or .xls formatted files into simple text file or .csv file.
I've found many options but doing this using PERL script is the best way I believe.I'm in AIX box.
Perl code should have 2 params while running. i.e
perl... (1 Reply)
Discussion started by: manab86
1 Replies
LEARN ABOUT DEBIAN
xls2csv
xls2csv(1) General Commands Manual xls2csv(1)NAME
xls2csv - reads MS-Excel file and puts its content as comma-separated data on standard output
SYNOPSIS
xls2csv [-xlV] [-f format ] [-b string ] [-s charset ] [-d charset ] [-q number ] [-c char] files
DESCRIPTION
xls2csv reads MS-Excel spreadsheet and dumps its content as comma-separated values to stdout. Numbers are printed without delimiters,
strings are enclosed in the double quotes. Double-quotes inside string are doubled.
OPTIONS -x print unknown Unicode chars as xNNNN, rather than as question marks
-l list known charsets and exit successfully
-cchar cell separator char. By default - comma.
-bstring
sheet break string. This string (by default - formfeed) would be output at the end of each workbook page. This string is printed
after page starting at start of line, but no linefeed would be automatically added at the end of string. Include newline at the ent
of sheet separator if you want it to appear on separate line by itself
-gnumber number of decimal digits in the numbers. By default maximal double precision (system-dependent macro DBL_DIG) is used.
-qnumber
set quote mode. In quote mode 0 cell contents is never quoted. In quote mode 1 only strings which contain spaces, double quotes or
commas are quoted. In quote mode 2 (default) all cells with type string are quoted. In quote mode 3 all cells are quoted.
-dcharset`
- specifies destination charset name. Charset file has format described in CHARACTER SETS section of catdoc(1) manual page. By
default, current locale charset would be used if langinfo support was enabled at the compile time.
-scharset
- specifies source charset. Typically, Excel files have CODE PAGE record, which denotes input charset, but for some reason you may
wish to override it.
-fformat
- specifies date/time format to use for output of all Excel date and time values. If this option is not specified, format, speci-
fied in the spreadsheet is used. On POSIX system any format, allowed by strftime(3) can be used as value of this option. Under MS-
DOS xls2csv implements limited set of strftime formats, namely m, d, y, Y, b, l, p, H, M, S.
-V outputs version number
FILES
${HOME}/.catdocrc, catdoc charset files and substitution map files (see catdoc(1) manual page for details,
SEE ALSO cat(1), catdoc(1), strings(1), utf8(7), unicode(7)AUTHOR
V.B.Wagner <vitus@45.free.net>, based on biffview by David Rysdam
MS-Word reader Version 0.94.4 xls2csv(1)