02-14-2014
Script for converting to xls and to mail the same
i have installed CENTOS in VMware. I want the linux command to run in CENTOS.
The command is to select data's from Event table(our table name) convert into .xls and mail every 2hrs. Can you please help me in writing this script.
Thanks,
Shobana
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
Can anyone tell the option to change the file type in unix.
i.e. if a file is in csv(Comma Separating Values) format, it should be changed to xls(ordinary MS-Excel) format. But renaming command is not changing to correct file format.
Thanks in advance,
Milton. (1 Reply)
Discussion started by: miltony
1 Replies
2. Shell Programming and Scripting
I need to convert an excel file into a text file
and an excel file into a CSV file..
any code to do that is appreciated
thanks (6 Replies)
Discussion started by: bandar007
6 Replies
3. UNIX for Dummies Questions & Answers
I think I know the answer to this :rolleyes: but thought I'd ask anyway. You never know.
Does anyone know of a program or utility that will run on any unix platform and convert Microsoft Excel files to ascii/plain text files that unix can understand ?
Thanks in advance.
Floyd (3 Replies)
Discussion started by: fwellers
3 Replies
4. Shell Programming and Scripting
Hi All,
Please give me the solution to the following ASAP.
1) Converting the .xls into .csv
Script i tried,
mv hello.xls hello.csv
The above given script converting the .xls file into .csv successfully. But after i run the below unix command I am no able to open the .csv file, its giving... (4 Replies)
Discussion started by: velava
4 Replies
5. Shell Programming and Scripting
Hello,
I have one csv file(";" separated). I would like to mail it as an attachment in xls format.
I tried it using below command but its coming in one column. I wan to have different columns as per delimiter ";".
unix2dos FILENAME | uuencode FILENAME FILENAME.xls | mailx -s "Hi" mailid... (1 Reply)
Discussion started by: skhichi
1 Replies
6. UNIX for Advanced & Expert Users
Hello,
I have one csv file(";" separated). I would like to mail it as an attachment in xls format.
I tried it using below command but its coming in one column. I wan to have different columns as per delimiter ";".
unix2dos FILENAME | uuencode FILENAME FILENAME.xls | mailx -s "Hi" mailid... (3 Replies)
Discussion started by: skhichi
3 Replies
7. Shell Programming and Scripting
hello
I have browsed for the similar requirement i found this
https://www.unix.com/shell-programming-scripting/40163-xls-csv-conversion.html
but my problem is i have multiple tabs in xls file having same metadata
I want to convert it into single csv file
any ways to do it pls... (5 Replies)
Discussion started by: joshiamit
5 Replies
8. Shell Programming and Scripting
Dear Friends,
I am in urgent need for awk/sed/sh script for converting a specific data format (.txt) to .xls.
The input is as follows:
>gi|1234|ref|
Query = 1 - 65, Target = 1677 - 1733
Score = 8.38, E = 0.6529, P = 0.0001513, GC = 46
fd sdfsdfsdfsdf
fsdfdsfdfdfdfdfdf... (6 Replies)
Discussion started by: Amit1
6 Replies
9. UNIX for Dummies Questions & Answers
Hi
I have a mail attachment coming from a mail id and evreytime with the same name in .xls format.I have to download the .xls file into a location and convert it itno .csv format and copy the .csv file to another location. (1 Reply)
Discussion started by: bikky6
1 Replies
10. UNIX for Advanced & Expert Users
Hi All,
Am needing advise on how to convert xls file to xlsx format on Solaris unix command line or scripting. I tried searching online but it looks like I need to either use Perl packages of Excel or Python packages or some other 3rd party tool. Problem is to install any of these will require... (2 Replies)
Discussion started by: arvindshukla81
2 Replies
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)