04-15-2010
OLE ERROR in perl
Hello All,
I have executed one script where i am getting this error,what may be the reason.....
please help me out.
OLE exception from Microsoft Excel
Win32::OLE(0.1403) error 0x800a03ec
in METHOD/PROPERTYGET "open"
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I am using Win32::OLE to write a perl script which opens an excel file. That excel file is password protected and everytime i run that script dialog box pops up and I have to click on Read-Only then my script executes. Is there any way I can specify the readonly attribute in my code so i dont have... (0 Replies)
Discussion started by: dguy
0 Replies
2. Shell Programming and Scripting
Hi,
I am trying automate couting number of spell and typo errors in MS Word document using perl script.
In perl script, i am using Win32::OLE module of perl to read MS word document.
Can anybody tell me are there any modules available in perl which can be imported into my script to... (0 Replies)
Discussion started by: 123an
0 Replies
3. Shell Programming and Scripting
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... (2 Replies)
Discussion started by: kooshi
2 Replies
4. Shell Programming and Scripting
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;
#... (1 Reply)
Discussion started by: cold_Que
1 Replies
5. Shell Programming and Scripting
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 (1 Reply)
Discussion started by: kavi.mogu
1 Replies
6. Shell Programming and Scripting
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... (0 Replies)
Discussion started by: wakatana
0 Replies
7. Programming
Hi gurus, i am trying to write simple perl script using win32 ole which will iterate over all M$ word paragraphs (any text that ends with a hard return) and print only those paragraphs that matches the specified condition. The problem is that I need to access font size property. It seems to me that... (0 Replies)
Discussion started by: wakatana
0 Replies
8. Shell Programming and Scripting
Hi gurus
I am trying to understand some advanced (for me) perl constructions (syntax) following this tutorial I am trying to parse html:
Using Mojo::DOM | Joel Berger
say "div days:";
say $_->text for $dom->find('div.days')->each;
say "\nspan hours:";
say $_->text for... (1 Reply)
Discussion started by: wakatana
1 Replies
9. AIX
This's my problem
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
LC_ALL = "en_US.UTF-8",
LC__FASTMSG = "true",
LC_MESSAGES = "",
LC_CTYPE = "en_US.UTF-8",
LC_TYPE = "en_US.UTF-8",
LANG = "EN_US"... (1 Reply)
Discussion started by: bobochacha29
1 Replies
LEARN ABOUT DEBIAN
excel::writer::xlsx::package::packager
Excel::Writer::XLSX::Package::Packager(3pm) User Contributed Perl Documentation Excel::Writer::XLSX::Package::Packager(3pm)
NAME
Packager - A class for creating the Excel XLSX package.
SYNOPSIS
See the documentation for Excel::Writer::XLSX.
DESCRIPTION
This module is used in conjunction with Excel::Writer::XLSX to create an Excel XLSX container file.
From Wikipedia: The Open Packaging Conventions (OPC) is a container-file technology initially created by Microsoft to store a combination
of XML and non-XML files that together form a single entity such as an Open XML Paper Specification (OpenXPS) document.
<http://en.wikipedia.org/wiki/Open_Packaging_Conventions>.
At its simplest an Excel XLSX file contains the following elements:
____ [Content_Types].xml
|
|____ docProps
| |____ app.xml
| |____ core.xml
|
|____ xl
| |____ workbook.xml
| |____ worksheets
| | |____ sheet1.xml
| |
| |____ styles.xml
| |
| |____ theme
| | |____ theme1.xml
| |
| |_____rels
| |____ workbook.xml.rels
|
|_____rels
|____ .rels
The "Excel::Writer::XLSX::Package::Packager" class co-ordinates the classes that represent the elements of the package and writes them into
the XLSX file.
AUTHOR
John McNamara jmcnamara@cpan.org
COPYRIGHT
X MM-MMXII, John McNamara.
All Rights Reserved. This module is free software. It may be used, redistributed and/or modified under the same terms as Perl itself.
LICENSE
Either the Perl Artistic Licence <http://dev.perl.org/licenses/artistic.html> or the GPL
<http://www.opensource.org/licenses/gpl-license.php>.
DISCLAIMER OF WARRANTY
See the documentation for Excel::Writer::XLSX.
perl v5.10.1 2012-04-02 Excel::Writer::XLSX::Package::Packager(3pm)