Visit Our UNIX and Linux User Community


Reading and Writing from Excel using Unix scripting

 
Thread Tools Search this Thread
Special Forums UNIX and Linux Applications Reading and Writing from Excel using Unix scripting
# 1  
Old 10-07-2007
Reading and Writing from Excel using Unix scripting

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  
Old 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.
# 3  
Old 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
# 4  
Old 11-09-2007
if you know Java, you can look here

Previous Thread | Next Thread
Test Your Knowledge in Computers #301
Difficulty: Easy
Slackware was originally derived from the Software Linux System (SLS).
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Writing xml from excel sheet .xls using perl script

Hi all. I am working on the below requirement of generating .xml file from .xls file which i have , can someone please help me or in writing the perl script for the same: The xls file format is as below which has two columns and number of rows are not fixed: Fixlet Name ... (12 Replies)
Discussion started by: omkar.jadhav
12 Replies

2. Shell Programming and Scripting

Writing in excel sheet using ksh

Hello, I'm trying to write a script to export a txt file to excel. The text file is a delimited with commas Example: Report Date,12/12/2014 Report By, Person Issue, Job Failed I tried exporting as csv and mailed to my id. But if I open the csv file the data is coming in single... (6 Replies)
Discussion started by: annamalaikasi
6 Replies

3. Shell Programming and Scripting

Writing excel file using perl : Excel file formatting changed

I am trying to create a program where user can input data in certain excel cells using user interface on internet....the programming is on perl and server is unix But when i parse data into excel the formatting of sheets is turned to default and all macro coding removed. What to do...Please... (7 Replies)
Discussion started by: mud_born
7 Replies

4. Shell Programming and Scripting

Perl Reading Excel sheet isssue

There is a perl scriptwhich will read Excel sheet and create one file(.v) . Excel sheet::: A B C D 1 cpu_dailog 2 3 4 Perl will create the file(.v) like thsi ::: assert (cpu_dailog_iso ==2) ; assert (cpu_dailog_reset ==3); assert (cpu_dailog_idle... (3 Replies)
Discussion started by: naaj_ila
3 Replies

5. Shell Programming and Scripting

Reading and writing in same file

Hi All, Here is my requirement. I am grepping through the log files and cutting some fields from the file to generate a csv file. Now I have to check if 2nd field is having some fixed value then with the help of 4th field I have to look in same log and run another grep command to retrieve the... (11 Replies)
Discussion started by: kmajumder
11 Replies

6. Programming

Excel reading on Linux using Java

Hi, I have a requirement where users will send excel(.xls) file to Linux Platform using ftp/sftp. After that the excel file needs to be read using java on linux and converted into csv. I am using jxl to parse the excel, but few character like are not getting parsed properly. If i open the... (0 Replies)
Discussion started by: joy_bt
0 Replies

7. Programming

I need help with file reading/writing in C

Hello everybody, I'm trying to code a program which makes the following: It sends an ARP request frame and when it gets the reply, extracts the IP address of source and writes it to a .txt file. This is gonna be done with many hosts (with a for() loop), so, the text file would look like... (2 Replies)
Discussion started by: Zykl0n-B
2 Replies

8. Shell Programming and Scripting

reading data from excel using shell script

Hi all I am new to shell scripting. I need to write a shell script that reads each row of an USER_ID colume in a excel file. the excel has around 10000 rows of data. Can someone gives me some example or advice what's best way to do this thanks (11 Replies)
Discussion started by: tiger99
11 Replies

9. Shell Programming and Scripting

reading/ writing to sockets

Is it possible to read from or write to sockets with ksh? I use AIX 5.3 (1 Reply)
Discussion started by: rein
1 Replies

10. UNIX for Dummies Questions & Answers

Reading and Writing Files ?

Hello, Our group is just starting to get into UNIX here. We are former REXX users on a VM Mainframe. Can someone point me to the documentation to read a file and write a file in a Unix Shell Script or does this have to be done in another language? Thank you in advance... Dave (3 Replies)
Discussion started by: tracydp
3 Replies

Featured Tech Videos