12-14-2012
Perl or PHP are the easy way. Maybe there are other 3rd party tools out there that can do this, but if you want to use pure bash you'd have to build a file following the Excel Binary File Format Specification that can be found
here. Reading und understanding that 48MB pdf-document is not what I call an easy way...
Edit: Phyton seems to be able to handle excel files to.
Last edited by cero; 12-14-2012 at 08:55 AM..
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
Can we convert an xls file into csv format in Unix
Thanks
Suresh (1 Reply)
Discussion started by: sureshg_sampat
1 Replies
3. Shell Programming and Scripting
Hi
Please can someone tell me how i can convert .xls file into .csv on both platforms, windows and unix.
many thanks,
neil (4 Replies)
Discussion started by: neil546
4 Replies
4. Shell Programming and Scripting
how to convert a xls file into .csv file?
is tghere any command in unix for that?
please help
thanks (3 Replies)
Discussion started by: infyanurag
3 Replies
5. 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
6. Shell Programming and Scripting
Hi,
I have problem..How to convert .xls file to .csv..
Plz help me for this problem.. (1 Reply)
Discussion started by: varma457
1 Replies
7. Shell Programming and Scripting
Ok, every morning at my office we send out excel sheets to Economy people with statistics for yesterdays trading.
All the trading run's in Redhat or Solaris environments.
We run a script on a Redhat server whitch generates the stats in CSV format.
After we download we open it in Excel and... (3 Replies)
Discussion started by: chipmunken
3 Replies
8. Shell Programming and Scripting
Hi,
My requirement is to convert the xls to csv file with utf-8 conversion.
Is there any way please suggest me.
Thanks,
Raja (4 Replies)
Discussion started by: cnraja
4 Replies
9. Shell Programming and Scripting
I would like to know if have one way with read table from oracle converter in CSV o TXT and After converter in XLS or spreedsheet
Thanks so much
JAvier (3 Replies)
Discussion started by: javeiregh
3 Replies
10. 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
LEARN ABOUT DEBIAN
excel::template::plus::tt
Excel::Template::Plus::TT(3pm) User Contributed Perl Documentation Excel::Template::Plus::TT(3pm)
NAME
Excel::Template::Plus::TT - Extension of Excel::Template to use TT
SYNOPSIS
use Excel::Template::Plus::TT;
# this is most commonly used through
# the Excel::Template::Plus factory
my $template = Excel::Template::Plus::TT->new(
template => 'greeting.tmpl',
config => { INCLUDE => [ '/templates' ] },
params => { greeting => 'Hello' }
);
$template->param(location => 'World');
$template->write_file('greeting.xls');
DESCRIPTION
This is an engine for Excel::Template::Plus which replaces the standard Excel::Template template features with TT. See the
Excel::Template::Plus docs for more information.
METHODS
Accessors
config
template
template_class
params
Excel::Template compat methods
params ($name | $name = $value)>
This provides access to getting and setting the parameters, it behaves exactly like the standard CGI.pm-style param method.
output
Returns the generated excel file.
write_file ($filename)
Writes the generated excel file to $filename.
Housekeeping
DEMOLISH
This will cleanup any temp files generated in the process.
meta
Returns the metaclass.
BUGS
All complex software has bugs lurking in it, and this module is no exception. If you find a bug please either email me, or add the bug to
cpan-RT.
ACKNOWLEDGEMENTS
This module was inspired by Excel::Template::TT.
AUTHOR
Stevan Little <stevan@iinteractive.com>
COPYRIGHT AND LICENSE
Copyright 2007-2010 by Infinity Interactive, Inc.
<http://www.iinteractive.com>
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.14.2 2012-05-06 Excel::Template::Plus::TT(3pm)