need batch xls to csv conversion for sco unix 1

[fdf]

need batch xls to csv conversion for sco unix

 

[vgersh99]

thanks for sharing.

what have you got so far?

vlad
+----------------------------+
| #include<disclaimer.h> |
+----------------------------+

 

[fdf]

I have around 1000 Excel files being maintained on a Unix drive for a startup data conversion.

Worksheets contain 1-1000 records ea, 20 columns, product info by vendor. I need to convert worksheets to CSV preparatory to Cobol import to accounting system.

Due to a dynamic conversion process, I'd prefer to run conversions on the Unix side using shell scripts. The missing piece is the utility to convert xls in to csv out.

 

[PHV]

If you have some remote shell facility on a NT/2k/XP box, the unix shell can launch a VBScript that will do the conversion.
You can also play with ftp, having a daemon on a win box watching for commands to execute.

Hope This Help
PH.

 

[vgersh99]

doing it natively on UNIX might be hard.
I believe perl provide Excell related module:
Spreadsheet::Writeexcel


Also I'd suggest browsing USENET [and/or google]:

http://groups.google.com/groups?hl=en&lr=&ie=ISO-8859-1&safe=off&q=xls&btnG=Google+Search&meta=

vlad
+----------------------------+
| #include<disclaimer.h> |
+----------------------------+

 

[feherke]

Hi

Try catdoc's brother, xls2csv :

http://www.45.free.net/~vitus/ice/catdoc/

Feherke.

 

[vgersh99]

nice link, feherke!

vlad
+----------------------------+
| #include<disclaimer.h> |
+----------------------------+

 

[fdf]

feherke:

xls2cv in catdoc looks good. Thanks. However...

I downloaded catdoc to Unix. The included Makefile.in is looking for a number of variable settings I'm unfamiliar with. I want to install executables into /usr2/bin. What should these be for SCO_SV 3.2v5.0.4?

srcdir = @srcdir@
top_srcdir = @top_srcdir@
VPATH = @srcdir@
prefix = @prefix@
exec_prefix = @exec_prefix@
installroot = @installroot@
bindir = @bindir@
libdir = @libdir@
mandir = @mandir@
INSTALL = @INSTALL@
WISH = @WISH@
CC = @CC@
build_targets = @buildtargets@
install_targets = @installtargets@

 

[feherke]

Hi

> I downloaded catdoc to Unix.

I not. I am old fashion DOS fan, and I use it with DOSEmu.

> The included Makefile.in is looking for a number of variable settings I'm unfamiliar with. I want to install executables into /usr2/bin. What should these be for SCO_SV 3.2v5.0.4?

Run

./configure

and edit the resulted Makefile. Is easier.

Feherke.