10 More Discussions You Might Find Interesting
1. UNIX for Beginners Questions & Answers
I'm trying to find out what happened to the rogue game that apt-get told me it installed, so I thought I would find the file. I went to the root and entered:
find -name "rog*.*"
I get a large number of lines saying my access is denied in various directories. I figure I'll practice my Unix... (14 Replies)
Discussion started by: arghvark
14 Replies
2. UNIX for Beginners Questions & Answers
Hi, I have a shell script which analyses the log folder for a specific string and throws me the output. I have used for loop since it does this in multiple servers. Now I want to save the output in a excel in the below format. Can someone please help?
The output which I get
Server1 : count... (1 Reply)
Discussion started by: srilaxman
1 Replies
3. Shell Programming and Scripting
Hi ,
i am generating some data by firing sql query with connecting to the database by my solaris box.
The below one should be the header line of my excel ,here its coming in separate row.
TO_CHAR(C. CURR_EMP_NO
---------- ---------------
LST_NM... (6 Replies)
Discussion started by: dani1234
6 Replies
4. Shell Programming and Scripting
I have a file example.txt as follows :SomeTextGoesHere
$$TODAY_DT=20140818
$$TODAY_DT=20140818
$$TODAY_DT=20140818I need to automatically update the date (20140818) in the above file, by getting the new date as argument, using a shell script.
(It would even be better if I could pass... (5 Replies)
Discussion started by: SriRamKrish
5 Replies
5. UNIX for Dummies Questions & Answers
Hi guys - I have a file and output like this below:
File: myfile.dat
File has content like this: ABCD, 34, 456, 2324
I would like excel to have this:
Name (ABCD) Quantity (34), Type (456), Status (2324)
(Name, Quantity, Type and Status are columns)
I would like to export... (4 Replies)
Discussion started by: DallasT
4 Replies
6. Shell Programming and Scripting
Please if You can help me debug why nothing is found by this command?
# echo "Zeus Robot" >> /home/vps/190/test
# cat /home/vps/190/test
Zeus Robot
# find /home/vps -type f -mtime 2 -size -1000k -exec grep -l "Zeus Robot" {} \; >> out
# cat out
# cat /home/vps/190/test
Zeus Robot
Why... (6 Replies)
Discussion started by: postcd
6 Replies
7. Shell Programming and Scripting
Hi Team,
The content of the file is as follows.
asdf
234
asdf
asdf
dsfg
gh
67
78
The file is in DOS format (not in Unix Format). The file is transferred to Unix. I need a unix command to check the number of blank lines in a input (comming from Windows). If it is greater than... (4 Replies)
Discussion started by: kmanivan82
4 Replies
8. Shell Programming and Scripting
Hi,
Could anyone please guide me to get the output of the PL/SQL procedure in a Excel file or Text File...
Thanks (1 Reply)
Discussion started by: funonnet
1 Replies
9. Windows & DOS: Issues & Discussions
Hi
I have some data in my Excel File.However all the data is in one single column.I want to split it into two columns.
Current Data:
1,Hi Everyone,I am
7,New To Dos,And
17,VB Script,i could
110,have tried this thing
1800,in UNIX
Desired Output
CELL1|CELL 2
1 |Hi... (3 Replies)
Discussion started by: dashing201
3 Replies
10. Shell Programming and Scripting
Hi All,
I have seen many examples of spooling query output in csv file.
But I want to spool the query results in proper excel file.
Can you guys help me on this? (4 Replies)
Discussion started by: yabhi_22
4 Replies
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)