03-16-2011
Read excel file using shell script
Is it possible to read an excel sheet using shell script ?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I am having a business file in excel having charts based on data already present on it. I would like to add new rows after the existing data and refesh the chart on it using shell script.
For example--
In excel file in "sheet1", There is some data in first 10 rows ( from column A to F).... (0 Replies)
Discussion started by: sanjay1979
0 Replies
2. Shell Programming and Scripting
Hi,
Can any one tell me how to put data using shell script to a excel file from text file to other columns of excel file,leaving first column unaffected i.e it should not overwrite data in first column.
Say my text file data is:
15-dec-2008 15-dec-2009
16-dec-2008 16-dec-2009
say my first... (1 Reply)
Discussion started by: siri_886
1 Replies
3. UNIX for Advanced & Expert Users
Hi.
I wish to add data in a specific excel file on daily basis.However the currect dat's data should always come on top i.e for example should always occupy cell A7,B7,C7 ..
and the data of day before which was earlier on 7th row of each coloumn should move to 8th row..data on 8th row should... (1 Reply)
Discussion started by: kanus
1 Replies
4. Shell Programming and Scripting
Hi All,
Following is my requirement. I have searched the site and found some threads which has same queries, but non of them have any answer. I thought of posting it once more.
We are generating different reports through shell script after we finish our data load. Currently there are 7 such... (5 Replies)
Discussion started by: ace_friends22
5 Replies
5. UNIX and Linux Applications
Hi,
I want the Perl script with versions 5.8.2 and 5.8.5 starting with
#!/usr/bin/perl
The Perl program should read the excel file or text file line by line and taking into an array and search in the UNIX directories for reference file of .jsp or .js or .xsl with path .The Object names... (2 Replies)
Discussion started by: pasam
2 Replies
6. Shell Programming and Scripting
Hi I have a dat file which has "n" number of columns. The file is delimited. The number of columns keep varying as the file is generated out of DB queries. Could you please help me in writing a script which will generate a XLS or CSV file out of the dat file. (5 Replies)
Discussion started by: Vee
5 Replies
7. Shell Programming and Scripting
Hi All,
Is it possible to convert the excel file to PDF file(Without loosing any format) using unix shell scripting ??? If yes
Kindly help me on the code
Thanks in advance!!! (5 Replies)
Discussion started by: Balasankar
5 Replies
8. UNIX for Dummies Questions & Answers
Hi,
i have shell script which compiles n number of test cases and execute them one by one. i want to create report in excel through script in which two columns namely "test id" and "release".second column have two subcolumns namely compiles and excutes. so i want first column should display test... (15 Replies)
Discussion started by: RamMore123
15 Replies
9. Shell Programming and Scripting
Hi Everyone,
I want your help to write a script which will take text file as input and on the basis of delimiter ":"script will create excel sheet.
Example input:
IpAdress:InstanceName:Port:ServerName
10.255.255.1:abc:2232:xyz_abc
Output should be an excel sheet like below:
Column... (8 Replies)
Discussion started by: akabhinav18
8 Replies
10. Shell Programming and Scripting
Hi All,
I am new to shell scripting.
I have made a script that can convert an excel file from cvs file.
This excel file contains hundreds of records and i would like the reader to be able to filter.
Is it possible to create an excel file with filters? or that functionality has not been... (3 Replies)
Discussion started by: Marvin159875321
3 Replies
SHCOMP(1) Korn shell utilities SHCOMP(1)
NAME
shcomp - compile a shell script
SYNOPSIS
shcomp [ options ] [infile [outfile]]
DESCRIPTION
Unless -D is specified, shcomp takes a shell script, infile, and creates a binary format file, outfile, that ksh can read and execute with
the same effect as the original script.
Since aliases are processed as the script is read, alias definitions whose value requires variable expansion will not work correctly.
If -D is specified, all double quoted strings that are preceded by $ are output. These are the messages that need to be translated to
locale specific versions for internationalization.
If outfile is omitted, then the results will be written to standard output. If infile is also omitted, the shell script will be read from
standard input.
OPTIONS
[D dictionary] Generate a list of strings that need to be placed in a message catalog for internationalization. [n noexec] Displays warn-
ing messages for obsolete or non-conforming constructs. [v verbose] Displays input from infile onto standard error as it reads it.
EXIT STATUS
0
Successful completion.
>0
An error occurred.
SEE ALSO
ksh(1)
IMPLEMENTATION
version
shcomp (AT&T Research) 2003-03-02
author
David Korn <dgk@research.att.com>
copyright
Copyright (c) 1982-2010 AT&T Intellectual Property
license
http://www.opensource.org/licenses/cpl1.0.txt
2003-03-02 SHCOMP(1)