Thanks so much for the script. It works like a charm.
Would you please give me some explanation about this script? How does it works so fast. Since you use unformatted print inside awk, so the bond title and bond distance are not aligned with each other if there are hundreds of bond.
for instance, there are 19 bond titles and 24 distances
All,
I want to run a non-root script as the root user with non-root environment variables with crontab. The non-root user would have environment variables for database access such as Oracle or Sybase. The root user does not have the Oracle or Sybase enviroment variables. I thought you could do... (2 Replies)
Hi I just stumbled on to these forums today, and I relatively new to unix. I am trying to figure out how to find the square root of a number using a shell script. I am using bash and I have searched and searched but cannot figure out square roots. Hopefully someone can point me in the right... (3 Replies)
I am just starting out with bash scripting. I tried a simple script to find the area of a square and it didnt run.
#!/bin/bash
#script to find area of a square based on user input
if
then
echo " Usage -$0 x "
echo " where x is the dimension of the square "
exit 1
n1=$1
... (2 Replies)
Hello,
I'm trying to create a shell script (#!/bin/sh) which should tell me the age of a file in minutes...
I have a process, which delivers me all 15 minutes a new file and I want to have a monitoring script, which sends me an email, if the present file is older than 20 minutes.
To do... (10 Replies)
Hi All,
I have a text file which looks like this:
computer programming
systems engineering
I want to get rid of these square brackets and also the text that is inside these brackets. So that my final text file looks like this:
computer programming
systems engineering
I am using... (3 Replies)
I have a file with say 50 columns, each containing a whole lot of data.
Each column contains data from a separate simulation, but each simulation is related to the data in the last (REFERENCE) column $50
I need to calculate the RMS deviation for each data line, i.e. column 1 relative to... (12 Replies)
Hi All
After downloading ZFS documentation from oracle site, I am able to successfully migrate UFS root FS without zones to ZFS root FS. But in case of UFS root file system with zones , I am successfully able to migrate global zone to zfs root file system but zone are still in UFS root file... (2 Replies)
Hi all, (mainly Neo)...
I keep noticing that the SQRT code I wrote recently for a POSIX shell keeps appearing, (the green colour sticks out like a sore thumb).
So I decided to take a look on Google.
Guess what?
UNIX.COM comes first in Google's listing just from two words, see image... (2 Replies)
Discussion started by: wisecracker
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)