10-08-2007
If you "cat" an .xls file, you will notice that unix understand it as binary file, and you won't see relevant content. Instead, you can rely on "
comma separated value format" and alter such file. Otherwise, you can use Excel's macros, thus putting yourself in need of writing on Visual basic.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hello,
Our group is just starting to get into UNIX here. We are former REXX users on a VM Mainframe. Can someone point me to the documentation to read a file and write a file in a Unix Shell Script or does this have to be done in another language?
Thank you in advance...
Dave (3 Replies)
Discussion started by: tracydp
3 Replies
2. Shell Programming and Scripting
Is it possible to read from or write to sockets with ksh?
I use AIX 5.3 (1 Reply)
Discussion started by: rein
1 Replies
3. Shell Programming and Scripting
Hi all
I am new to shell scripting.
I need to write a shell script that reads each row of an USER_ID colume in a excel file.
the excel has around 10000 rows of data.
Can someone gives me some example or advice what's best way to do this
thanks (11 Replies)
Discussion started by: tiger99
11 Replies
4. Programming
Hello everybody,
I'm trying to code a program which makes the following:
It sends an ARP request frame and when it gets the reply, extracts the IP address of source and writes it to a .txt file. This is gonna be done with many hosts (with a for() loop), so, the text file would look like... (2 Replies)
Discussion started by: Zykl0n-B
2 Replies
5. Programming
Hi,
I have a requirement where users will send excel(.xls) file to Linux Platform using ftp/sftp. After that the excel file needs to be read using java on linux and converted into csv.
I am using jxl to parse the excel, but few character like £ are not getting parsed properly. If i open the... (0 Replies)
Discussion started by: joy_bt
0 Replies
6. Shell Programming and Scripting
Hi All,
Here is my requirement. I am grepping through the log files and cutting some fields from the file to generate a csv file. Now I have to check if 2nd field is having some fixed value then with the help of 4th field I have to look in same log and run another grep command to retrieve the... (11 Replies)
Discussion started by: kmajumder
11 Replies
7. Shell Programming and Scripting
There is a perl scriptwhich will read Excel sheet and create one file(.v) .
Excel sheet:::
A B C D
1 cpu_dailog 2 3 4
Perl will create the file(.v) like thsi :::
assert (cpu_dailog_iso ==2) ;
assert (cpu_dailog_reset ==3);
assert (cpu_dailog_idle... (3 Replies)
Discussion started by: naaj_ila
3 Replies
8. Shell Programming and Scripting
I am trying to create a program where user can input data in certain excel cells using user interface on internet....the programming is on perl and server is unix
But when i parse data into excel the formatting of sheets is turned to default and all macro coding removed.
What to do...Please... (7 Replies)
Discussion started by: mud_born
7 Replies
9. Shell Programming and Scripting
Hello,
I'm trying to write a script to export a txt file to excel. The text file is a delimited with commas
Example:
Report Date,12/12/2014
Report By, Person
Issue, Job Failed
I tried exporting as csv and mailed to my id. But if I open the csv file the data is coming in single... (6 Replies)
Discussion started by: annamalaikasi
6 Replies
10. Shell Programming and Scripting
Hi all.
I am working on the below requirement of generating .xml file from .xls file which i have , can someone please help me or in writing the perl script for the same:
The xls file format is as below which has two columns and number of rows are not fixed:
Fixlet Name ... (12 Replies)
Discussion started by: omkar.jadhav
12 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)