day, 18. August 2008 2:40 PM
To: perl-win32-users@listserv.ActiveState.com
Subject: RE: WIN32::OLE help
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Neson Maxmelbin (RBEI/EMT4)
Sent: 18 August 2008 09:40
To: Steve Howard (PFE); perl-win32-users@listserv.ActiveState.com
Subject:
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Neson Maxmelbin (RBEI/EMT4)
Sent: 18 August 2008 09:40
To: Steve Howard (PFE); perl-win32-users@listserv.ActiveState.com
Subject: RE: WIN32::OLE help
> Hello Steve,
>
> It does work and my machine shows the same values for
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Howard
(PFE)
Sent: Friday, 15. August 2008 1:34 AM
To: Neson Maxmelbin (RBEI/EMT4); perl-win32-users@listserv.ActiveState.com
Subject: RE: WIN32::OLE help
I'll type this directly in so I might make a
rather than the
literal values.
See if this helps.
Steve
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Neson Maxmelbin
(RBEI/EMT4)
Sent: Thursday, August 14, 2008 4:30 AM
To: perl-win32-users@listserv.ActiveState.com
Subject: WIN32::OLE help
Hello ,
I am using WIn32::OLE
Hello,
if you just want to read data from an Excel file, you might consider the
Spreadsheet::ParseExcel module. I would think that using the OLE module
always starts an Excel instance (visible or not) whereas the Spreadsheet
module operates directly on the XLS file.
Ekkehard
Hello ,
I am using WIn32::OLE to Read contents of an Excel sheet.
There is no issues on reading, but the problem is that Excel file opens on the
screen, during the time the script processes the file.
I don't need this.
One solution was to make it not visible ($Excel->{'Visible'} = 0;).
But this
Need a little help using a function, Find. How? Here's what I have so
far. How do I collect and test it?
sheets:
foreach my $ws (in $MyWorkbook->Sheets) {
$ws->Find('What:=CL247', 'After:=ActiveCell',
'LookIn:=xlFormulas', 'LookAt:=xlPart', 'SearchOrder:=xlByRows',
'Sear
Hi Perl Gurus
I'm facing a problem. I'm using Win32::OLE and my code goes
something like this
some code here
Win32::OLE->Option(Warn => sub {goto CheckError});
## some other code here
for(;;)
{
### more boring lines of code in between here
CheckError:
{
print LOG
Can I read an excel sheet whise values are changing dynamically using Win32::OLE
perl module
--
Parvez I. Pathan
Jr. Programmer
Infotech Financials Pvt. Ltd.
Mumbai (INDIA)
Phone : +91 22 826 4183/85/87
Fax : +91 22 831 4598
http://www.infofin.com
> $sheetFormat->Borders(xlDiagonalDown)->LineStyle = xlNone;
> # I GET THE ERROR HERE
> $sheetFormat->Borders(xlDiagonalUp)->LineStyle = xlNone;
Untested:
Try using ->{LineStyle} instead of ->LineStyle. You want to assign a value to a
property, the syntax above indicates you want to call a
did you import the constants from excel?
does perl know what the value for "xlNone" is?
check out the Win32::OLE::Const module.
example:
use Win32::OLE::Const 'Microsoft Excel';
---thinc
*** REPLY SEPARATOR ***
On 7/2/2001 at 10:35 AM Ken Brown wrote:
>OLE
OLE Command - Excel
Range("A1:C3").Select
Selection.Borders(xlDiagonalDown).LineStyle = xlNone
Selection.Borders(xlDiagonalUp).LineStyle = xlNone
With Selection.Borders(xlEdgeLeft)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = xlAutomatic
En
us processing with OLE in definitely more art
than science.
HTH,
Ian
To: "'[EMAIL PROTECTED]'"
<[EMAIL PROTECTED]>
cc: (bcc: Ian Stewart/Great Lakes/AirTouch)
bcc: Ian Stewart/Great Lakes/AirTouch
Subject: [OLE] Help running
I wonder if some of the expert OLE users could comment on what problem I'm
having.
I'm trying to write a small server which finds .doc files, opens them, saves
as .rtf, and then closes the file.
Easy enough you'd think!
Anyway, it works one or twice, or even a half dozen times, but eventually it
14 matches
Mail list logo
