08-17-2006
I've had a very good experience with the Spreadsheet::WriteExcel per module; documentation is at:
http://search.cpan.org/dist/Spreadsh.../WriteExcel.pm
It seems like what you are trying to do is similar to what I do... connect to a database, run a query, and then export the results to an Excel file. This module works very well with the perl DBI database access interfaces.
Some of the things I can verify that Spreadsheet::WriteExcel supports:
- Multiple tabs in a workbook
- Formulas
- Text attributes (font, color, etc.)
- Easy row / column navigation
Hope this helps,
- John
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hi all,
I want to open an Excel file in Unix(ABC.xls) and copy one column of the file onto another text file (xyz.txt) .Please let me know if there is a way of going about to perform this operation.
Thanks in Advance,
bubeshj (5 Replies)
Discussion started by: bubeshj
5 Replies
2. Shell Programming and Scripting
Hi friends...
I am sending a file say xyz.xls to a mail through unix.
The .xls file is more than 65 thousand in size so I want to spilt the file size into 40 thousand and 25 thousand.
So can anyone provide any inputs.... (1 Reply)
Discussion started by: Soumya Dash
1 Replies
3. UNIX for Advanced & Expert Users
Hi, My client uploads an Excel file on to Unix server by using web application with more than 20 columns and more than 60000 records in it. I have to check the data in each cell when the file arrived. Is is possible to check the data in cells by running unix script? or Is there any way to convert... (2 Replies)
Discussion started by: sireeshp
2 Replies
4. Shell Programming and Scripting
Hi,
I have generated an excel sheet using a shell script. i have converted the output text file to an excel and got the desired output. However, in a particular column in the excel the values of the numbers start with 0.
e.g. 078393343, 00342442, etc.
But, in the resulting excel I get as... (2 Replies)
Discussion started by: Vijay06
2 Replies
5. Shell Programming and Scripting
Hi,
I have the Ms Excel file(test.xls) in my UNIX box. I would like to read the excel file and create files for each column.
Please find an example.
My excel file like this data:
Num Data
1 a1
2 b2
3 c3
4 d4
5 e5
6 f6
7 h7
My output:
I want create 2 files(num.log and... (3 Replies)
Discussion started by: koti_rama
3 Replies
6. UNIX for Dummies Questions & Answers
Hello
I have an excel file , it has 4 tabs , each having specific details
for example it has a customer tab , it has a payments tab and it has an address tab
Question is
How do I seperate each of these tabs and load them into 3 different excel files Using Unix
That is the... (2 Replies)
Discussion started by: arnab1978
2 Replies
7. Shell Programming and Scripting
Hi Guys,
I like to create a excel sheet with four tabs.
Is it possible to create it. Acutually i want to apply formulas in fourth tab which uses the three different tabs.
Is it possible to create such a script?
Thanks & regards,
Magesh (3 Replies)
Discussion started by: mac4rfree
3 Replies
8. 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
9. Windows & DOS: Issues & Discussions
How to run scripts from Excel and bring results back to excel? (10 Replies)
Discussion started by: santoshdrkr
10 Replies
10. UNIX for Beginners Questions & Answers
Hi,
I would like to extract the data from particular date,
1. may i know which command i need to use?
2. Extract from unix command (those extracted above) to excel?
Please assist.
Thanks (2 Replies)
Discussion started by: Peru
2 Replies
LEARN ABOUT DEBIAN
excel::template::plus
Excel::Template::Plus(3pm) User Contributed Perl Documentation Excel::Template::Plus(3pm)
NAME
Excel::Template::Plus - An extension to the Excel::Template module
SYNOPSIS
use Excel::Template::Plus;
my $template = Excel::Template::Plus->new(
engine => 'TT',
template => 'greeting.tmpl',
config => { INCLUDE => [ '/templates' ] },
params => { greeting => 'Hello' }
);
$template->param(location => 'World');
$template->write_file('greeting.xls');
DISCLAIMER
This is the very first release of this module, it is an idea that I and Rob Kinyon (the author of Excel::Template) had discussed many
times, but never got around to doing. This is the first attempt at bring this to reality, it may change radically as it evolves, so be
warned.
DESCRIPTION
This module is an extension of the Excel::Template module, which allows the user to use various "engines" from which you can create Excel
files through Excel::Template.
The idea is to use the existing (and very solid) excel file generation code in Excel::Template, but to extend its more templatey bits with
more powerful options.
The only engine currently provided is the Template Toolkit engine, which replaces Excel::Template's built in template features (the LOOP,
and IF constructs) with the full power of TT. This is similar to the module Excel::Template::TT, but expands on that even further to try
and create a more extensive system.
You can use this module to create Excel::Template-compatible XML files using one of the supported engines. For example, with the TT engine
you could create a Excel::Template XML file like:
<workbook>
<worksheet name="[% worksheet_name %]">
[% my_cols = get_list_of_columns %]
<row>
[% FOR col = my_cols %]
<bold><cell>[% col %]</cell></bold>
[% END %]
</row>
[% FOR my_row = get_list_of_objects %]
<row>
[% FOR col = my_cols %]
<cell>[% my_row.$col %]</cell>
[% END %]
</row>
[% END %]
</worksheet>
</workbook>
Your TT template thus creates a XML file suitable to handing over to Excel::Template for processing. Excel::Template::Plus simplifies the
template-creation and handing-over process.
Future engine/plans include:
Pure Perl
This would allow you to write you Excel::Template files using Perl itself which would then output the XML for Excel::Template to
consume. This would be modeled after the recently released Template::Declare module perhaps.
TT Plugins/Macros/Wrappers
This is basically anything which will make the TT engine easier to write templates for. I have experimented with some of these things,
but I was not happy with any of them enough to release them yet.
HTML::Template
Excel::Template's templating features are based on HTML::Template, but the HTML::Template plugins and other goodies are not compatible.
This engine would bring those things to Excel::Template.
METHODS
new (%options)
This method basically serves as a factory for creating new engine instances (for which Excel::Template::Plus::TT is the only one
currently). The only parameter that it requires is engine, all other parameters are passed onto the engine's constructor (see the
individual docs for more details on what is required).
meta
Access to 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 came out of several discussions I had with Rob Kinyon.
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(3pm)