Reading and Writing from Excel using Unix scripting

Linux and Unix-Like UNIX and Linux Applications
1

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

2

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.

3

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

4

if you know Java, you can look here