09-23-2012
Expand cells in .xls file created in unix
Hi Guys,
I am creating a comma separated file by quering the table and routing it to a file with an extension .xls.
I am using the mailx command to send the .xls file to windows mail box.
The file is coming as a excel attachment, but the cells are not expanded.
Is there a way by which we can expand the cells in the excel attachment.
Thanks for your help in advance.
Cheers!!!!!!!!!
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I need to write a script which has to list all the files which are created before six months from now.
kindly help on this ... (7 Replies)
Discussion started by: amirthraj_12
7 Replies
2. UNIX for Dummies Questions & Answers
Hi
I am using the unix zip command to zip a file name to name .zip.
I am then ftping the file to my windows Xp desktop and trying to open it using compressed(zipped) folders. Then iam getting an error like 'the compressed(zipped) folder is invalid or corrupted'
Please advice.
regards,... (5 Replies)
Discussion started by: sam99
5 Replies
3. UNIX for Dummies Questions & Answers
I have a .csv file in Unix box i need a UNIX script to convert the.csv files to.xls format.
Its very urgent please help me. (1 Reply)
Discussion started by: moon_friend
1 Replies
4. 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
5. Shell Programming and Scripting
Hi All,
I want to create an xls file using shell script. I mean that I have written one script. It is having sql output. So I want to save that sql output into one xls file and I want to send that file as a attachment to my team MAIL_IDs.
Can You any guy help me in this?
Thanks in... (3 Replies)
Discussion started by: raghu.iv85
3 Replies
6. Shell Programming and Scripting
Hi UNIX Gods!
Is it possible to merge two cells in .csv file using unix commands?
Imagine that this is my present csv file opened via excel:
Gate Reports| |
fatal alerts | 200 |
is is possible to make it look like this using unix?
Gate Reports |
fatal... (1 Reply)
Discussion started by: 4dirk1
1 Replies
7. HP-UX
Hi All
Any one please suggest me...
I have one directory every monday one file will be created in that directory. so if the file is created on monday or not i need check first.
How can write a script??? if the file is not created i want to quit from script.
Thanks
K.Srinivas (5 Replies)
Discussion started by: k_s_rao7
5 Replies
8. UNIX for Dummies Questions & Answers
Hi All,
I am creating an XLS using unix which fetches the data from database.
In the first row i have 2 columns which i want to merge. Is it possible to merge the columns using unix command?
Thanks,
Sashanka (1 Reply)
Discussion started by: Sashanka_545
1 Replies
9. 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
10. Shell Programming and Scripting
Hi All,
I have created a unix script to mail the xls file.This is being done using mailx command
fdate=`tail -1 abc.xls | cut -c1-8`
SUBJECT="CARD GL Exceptions : ${ENV} for ${fdate}"
destname=CARD_GL_Exceptions_$fdate
sed 's/#BUSINESS/BUSINESS/1' abc.xls > abc2.xls
mv abc2.xls abc.xls... (2 Replies)
Discussion started by: karthik adiga
2 Replies
LEARN ABOUT DEBIAN
font::ttf::gdef
Font::TTF::GDEF(3pm) User Contributed Perl Documentation Font::TTF::GDEF(3pm)
NAME
Font::TTF::GDEF - Opentype GDEF table support
DESCRIPTION
The GDEF table contains various global lists of information which are apparantly used in other places in an OpenType renderer. But
precisely where is open to speculation...
INSTANCE VARIABLES
There are 4 tables in the GDEF table, each with their own structure:
GLYPH
This is an Font::TTF::Coverage Class Definition table containing information as to what type each glyph is.
ATTACH
The attach table consists of a coverage table and then attachment points for each glyph in the coverage table:
COVERAGE
This is a coverage table
POINTS This is an array of point elements. Each element is an array of curve points corresponding to the attachment points on that
glyph. The order of the curve points in the array corresponds to the attachment point number specified in the MARKS coverage
table (see below).
LIG This contains the ligature caret positioning information for ligature glyphs
COVERAGE
A coverage table to say which glyphs are ligatures
LIGS An array of elements for each ligature. Each element is an array of information for each caret position in the ligature (there
being number of components - 1 of these, generally)
FMT This is the format of the information and is important to provide the semantics for the value. This value must be
set correctly before output
VAL The value which has meaning according to FMT
DEVICE For FMT = 3, a device table is also referenced which is stored here
MARKS
Due to confusion in the GDEF specification, this field is currently withdrawn until the confusion is resolved. That way, perhaps this
stuff will work!
This class definition table stores the mark attachment point numbers for each attachment mark, to indicate which attachment point the
mark attaches to on its base glyph.
METHODS
$t->read
Reads the table into the data structure
$t->out($fh)
Writes out this table.
perl v5.10.1 2009-01-29 Font::TTF::GDEF(3pm)