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::xmlwritersimple
Excel::Writer::XLSX::Package::XMLwriterSimple(3pm) User Contributed Perl Documentation Excel::Writer::XLSX::Package::XMLwriterSimple(3pm)
NAME
XMLwriterSimple - Light weight re-implementation of XML::Writer.
This module is used internally by Excel::Writer::XLSX.
DESCRIPTION
This module is used by Excel::Writer::XLSX for writing XML documents. It is a light weight re-implementation of XML::Writer.
XMLwriterSimple is approximately twice as fast as XML::Writer. This speed is achieved at the expense of error and correctness checking. In
addition not all of the XML::Writer methods are implemented. As such, XMLwriterSimple is not recommended for use outside of
Excel::Writer::XLSX.
If required XMLwriterSimple can be overridden and XML::Writer can be used in its place by setting an "_EXCEL_WRITER_XLSX_USE_XML_WRITER"
environmental variable:
export _EXCEL_WRITER_XLSX_USE_XML_WRITER=1
perl example.pl
Or for one off programs:
_EXCEL_WRITER_XLSX_USE_XML_WRITER=1 perl example.pl
This technique is used for verifying the test suite with both XMLwriterSimple and XML::Writer:
_EXCEL_WRITER_XLSX_USE_XML_WRITER=1 prove -l -r t
SEE ALSO
XML::Writer.
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::XMLwriterSimple(3pm)