Reading and Writing from Excel using Unix scripting

AshishK · #1 (**permalink**) 10-07-2007

Hi All,

I want to read and write into Excel files.

I want my script to generate the required output directly in the Excel format.

Is it possible through unix scripting or shall I have to use some other language for this purpose?

Waiting for your suggestion.

Thanks in Advance.

AshishK

sysgate · #2 (**permalink**) 10-08-2007

If you "cat" an .xls file, you will notice that unix understand it as binary file, and you won't see relevant content. Instead, you can rely on "comma separated value format" and alter such file. Otherwise, you can use Excel's macros, thus putting yourself in need of writing on Visual basic.

ghostdog74 · #3 (**permalink**) 10-08-2007

Some libraries you can use:
1) if you know Perl, you can look here for some guidance.
2) If you know Python, you can look here

SAV · #4 (**permalink**) 11-09-2007

if you know Java, you can look here

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
How to handle Microsoft Excel in Linux Scripting	envisage	Shell Programming and Scripting	2	02-04-2008 02:17 PM
reading data from excel using shell script	tiger99	Shell Programming and Scripting	11	01-06-2008 01:35 AM
reading/ writing to sockets	rein	Shell Programming and Scripting	1	09-20-2007 09:57 PM
Reading and Writing file on LAN	lucky001	High Level Programming	3	03-30-2007 03:16 PM
Reading and Writing Files ?	tracydp	UNIX for Dummies Questions & Answers	3	08-30-2006 11:24 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by