07-23-2008
I guessing but I think they are wanting to Convert an Excel file to a text/csv type file in a shell script and be able to control the record and row delimiters.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
I'am are working on Unix platform.
It requires for me to present the certain unix files in Microsoft word.
Is conversion of a Unix ".out" file to Microsoft word feasible?????
Kindly Let me know on this...
Thanks in Advance,
Divya (1 Reply)
Discussion started by: divyacl
1 Replies
2. Shell Programming and Scripting
Hi,
I have a text file like
----------------------
aaa|bbb|ccc|ddd|eee
fff|gggg|hhhhhh|kkkk
--------------------
I have a script which will transfer(thourgh FTP) this text file to windows system.
But I want to covert it into excel or CSF then upload into windows system..
thanks (9 Replies)
Discussion started by: srikanthus2002
9 Replies
3. Shell Programming and Scripting
Hi,
I have generated a report that contains many columns and since I need ir in excel format.. I just renamed te file to excel as follows:
cp vijay.txt vijay.xls
I have just attached this spreadsheet in the mail and I am getting it to my mail id. But, in the output excel, the columns that... (10 Replies)
Discussion started by: Vijay06
10 Replies
4. UNIX for Dummies Questions & Answers
I have some files created in Excel that have to be saved as .txt files in order to load them into our accounting system. I can save the files as .txt files through Excel, but I then have to open them in TextPad and do a save as to change the Format from PC to UNIX. Is there a way to skip this step... (2 Replies)
Discussion started by: jroyalty
2 Replies
5. Shell Programming and Scripting
Hi All,
I have created a Unix Shell script whch creates a *.csv file and export it to Excel.
The problem i am facing is that Users wants one of the AMOUNT field in comma separted values. Example :
if the Amount has the value as 3000000 User wants to be in 3,000,000 format.
This Amount format... (2 Replies)
Discussion started by: rawat_me01
2 Replies
6. 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
7. Shell Programming and Scripting
Hi Everyone,
I want your help to write a script which will take text file as input and on the basis of delimiter ":"script will create excel sheet.
Example input:
IpAdress:InstanceName:Port:ServerName
10.255.255.1:abc:2232:xyz_abc
Output should be an excel sheet like below:
Column... (8 Replies)
Discussion started by: akabhinav18
8 Replies
8. UNIX for Beginners Questions & Answers
Hi
i have a problem in my job
i try to convert an excel file (xls extention) to text file (tab delimited), but no result with this comand
cat xxx.xls > xxx.txt
Do you have eny idea?
PS: sorry for my english
Thanks!! (4 Replies)
Discussion started by: frisso
4 Replies
9. Shell Programming and Scripting
I would like to convert YYYYMMDD to MJD format
for eg 20041223 converted to 53362 in MJD format i got logic from javascript to covert it to MJD which is long enough
function YMDtoMJD (year, month, day)
{
var year;
var monthi
var day;
var yr = Math.floor (year);
... (1 Reply)
Discussion started by: mandalmanas24
1 Replies
10. UNIX for Beginners Questions & Answers
How to change the format of an excel from exponential to text through UNIX command
We have a pipe delimited file in which one particular A column is a combination of number+text and while converting into
excel using tr command it is generating a exponential data for the A column.
Kindly... (2 Replies)
Discussion started by: AbiramiRaja
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)