Win32::OLE open excel file as read only

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

win32 ole in deepr details in perl

Hello Gurus, I am begginer in perl. I would like to ask several questions, some related to perl and its syntax but most will be regarding to WIN32 OLE. My main goal is to develop script that will check word document structure (return some information) and make some changes in this document (if it...

2. Shell Programming and Scripting

Details about WIN32::OLE

Hi all, Is win32::OLE module is applicable in linux system??? from my understanding it is not possible..because we have to use some tools for that..for more info refer this website http://oclug.on.ca/archives/oclug/2001-July/008100.html

3. UNIX and Linux Applications

Perl Script to read an excel file into an array and search in the UNIX directories

Hi, I want the Perl script with versions 5.8.2 and 5.8.5 starting with #!/usr/bin/perl The Perl program should read the excel file or text file line by line and taking into an array and search in the UNIX directories for reference file of .jsp or .js or .xsl with path .The Object names...

4. UNIX for Dummies Questions & Answers

Read excel file using shell script

Is it possible to read an excel sheet using shell script ?

5. Shell Programming and Scripting

PERL Win32::OLE Inserting Picture in Excel

I am trying to insert a picture into a worksheet in Excel using Perl the following is the code use Win32::OLE; use Win32::OLE::Const "Microsoft Excel"; use Win32::OLE qw(in with); # Initiate Excel application $Excel = Win32::OLE->new('Excel.Application', 'Quit'); $Excel->{Visible} =1; #...

6. Shell Programming and Scripting

MS Outlook + Win32::OLE

Hey guys, I'm trying to go through my emails in Outlook until I find an email with a certain subject line. I am able to send emails with no problem, but reading emails and their properties (From, Subject, etc.) is my main problem. Basically, I don't know where to start and using search engines...

7. Shell Programming and Scripting

Read Ms-excel file in unix

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...

8. Shell Programming and Scripting

use awk to read randomly located columns in an excel file

Hi, I have an excel file that have a random count of columns/fields and what im trying to do is to only retrieve all the rows under 2 specific field headers. I can use the usually command for awk which is awk 'print{ $1 $2}' > output.txt, but the location of the 2 specific field headers is...

9. UNIX for Dummies Questions & Answers

How do u open a read only file in Unix?

10. Programming

how can i read an excel file using C?

hi.. i have the next question: i need to read an excel file (xls) using a C program. Is that possible? how can i do that? please, any idea thanks

LEARN ABOUT DEBIAN

excel::template::plus::tt

Excel::Template::Plus::TT(3pm)				User Contributed Perl Documentation			    Excel::Template::Plus::TT(3pm)

NAME

       Excel::Template::Plus::TT - Extension of Excel::Template to use TT

SYNOPSIS

	 use Excel::Template::Plus::TT;

	 # this is most commonly used through
	 # the Excel::Template::Plus factory

	 my $template = Excel::Template::Plus::TT->new(
	     template => 'greeting.tmpl',
	     config   => { INCLUDE  => [ '/templates' ] },
	     params   => { greeting => 'Hello' }
	 );

	 $template->param(location => 'World');

	 $template->write_file('greeting.xls');

DESCRIPTION

       This is an engine for Excel::Template::Plus which replaces the standard Excel::Template template features with TT. See the
       Excel::Template::Plus docs for more information.

METHODS

   Accessors
       config
       template
       template_class
       params

   Excel::Template compat methods
       params ($name | $name = $value)>
	   This provides access to getting and setting the parameters, it behaves exactly like the standard CGI.pm-style param method.

       output
	   Returns the generated excel file.

       write_file ($filename)
	   Writes the generated excel file to $filename.

   Housekeeping
       DEMOLISH
	   This will cleanup any temp files generated in the process.

       meta
	   Returns 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 was inspired by Excel::Template::TT.

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::TT(3pm)

Shell Programming and Scripting