Hi All,
Am trying to write a shell script which will get values from an excel and do some calculations.
Can any one pls help me out in the commands used to get the values from ms-excel.
Thanks!!!:) (2 Replies)
I have requirement where i have to export the data extracted from a flat file to a microsoft excel sheet. If the awk returns multiple records then all these records should go in into different rows of same column in excel.
Eg. say data returned by excel is A,B,C,D then these 4 records should go... (1 Reply)
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)
i have both linux and windos installed on my pc . i want to take 1st column of excel as in input for my shell script .can anyone tell me how can i achive that. (1 Reply)
Hi All,
Currently i am using below script to attach excel and email from a Unix script.
uuencode ASC.xls|mailx -m -s "ABCD_subject`TZ=CST+24 date +%d-%b-%y`" email@email.com
Can anyone give me or help me in zipping excel and sending that email as the excel is very heavy.
Thanks, (14 Replies)
Hi Expert,
We have some shell scripts which Internally uses Perl Script to Unzip the source zip files which comes to inbound directory. So now our requirement is to avoid the dependency on Perl Script and us Shell Script to unzip the files. I have the Perl script with me attached can some one... (3 Replies)
Hi ,
I have one excel file in zipped format which contains data with size 157 MB. It's original size is 2.6 GB so to send to user I zipped the file.
Now user is saying unable to open the file at once because of huge size and want to split the excel file into 3 files randaonly and zip them.... (1 Reply)
Hi all,
I am calling Temp.sh and it is has simple line
$gpath=`which gzip`
$gpath $FilePath/My_temp.log
if I run this script, logging to server then its works fine. But when I send this script over the SSH it does not work at it. gzip is command is not execute.
I am using
gzip 1.6... (2 Replies)
I am trying to combine zip and ftp upload in one script but for some reason I can't get it to work. It zips properly but does not ftp, seems like it just ignores ftp. Any help would be greatly appreciated. Thanks!
#!/bin/sh
cd /home/user/test
zip -r test.zip *
FOLDER='/home/user/test'... (2 Replies)
Discussion started by: shimabuku
2 Replies
LEARN ABOUT DEBIAN
gsf
GSF(1) GNOME GSF(1)NAME
gsf - archiving utility using the G Structured File library
SYNOPSIS
gsf [OPTION...] SUBCOMMAND ARCHIVE...
DESCRIPTION
This manual page briefly documents the gsf command.
gsf is a simple archive utility, somewhat similar to tar(1). It operates on files following one of the structured file formats understood
by the G Structured File library, for example, Microsoft Excel(TM) files.
OPTIONS
Options
-?, --help
Show help options
-v, --version
Display gsf's version
Subcommands
cat Output one or more files in archive
dump Dump one or more files in archive as formatted hexadecimal
help List subcommands
list List files in archive
props Archive list of property names
EXAMPLES
To list the content structure of a Microsoft Excel(TM) file arrays.xls:
gsf list arrays.xls
To dump Workbook, an individual data stream in arrays.xls:
gsf dump arrays.xls Workbook
AUTHORS
gsf's primary authors are Morten Welinder <terra@gnome.org> and Jody Goldberg <jody@gnome.org>.
The initial version of this manpage was written by J.H.M. Dassen (Ray) <jdassen@debian.org>.
SEE ALSO gnumeric(1)
The Gnumeric homepage <http://www.gnome.org/projects/gnumeric/>
The GNOME project page <http://www.gnome.org/>
gsf 29 November 2009 GSF(1)