Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister
 
PerlMonks  

Re: excel pasting

by c-era (Curate)
on Nov 28, 2001 at 22:16 UTC ( #128120=note: print w/replies, xml ) Need Help??


in reply to excel pasting

Two things. First, use Win32::OLE::Const to import the excel constants. Second, PasteSpecial is a method, not a property. The code below should work (yes it has been tested).
use Win32::OLE; use Win32::OLE::Const 'Microsoft Excel'; $excel = Win32::OLE->new ("Excel.Application") || die "CreateObject : +$!\n"; $excel -> {Visible}=1; $excelfile2 = $excel -> Workbooks -> Open("c:\\sheetA.xls"); $excelfile = $excel -> Workbooks -> Open("c:\\sheetB.xls"); $xls4 = $excelfile -> Worksheets(1); $xls5 = $excelfile2 -> Worksheets(1); $xls5 -> Range ("H58:H105") -> Copy; $xls4 -> Cells (9, 15) -> PasteSpecial (xlPasteValues); $xls4 -> Cells (9, 14) -> Select;
If you have any additional questions, feel free to ask.

Replies are listed 'Best First'.
Re: Re: excel pasting
by toni_t_banire@gsk.com (Initiate) on Nov 29, 2001 at 18:06 UTC
    This is to say a really big THANK YOU you to c-era for resolving my excel paste problem.
    Really appreciate the quick response

    Toni

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://128120]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others scrutinizing the Monastery: (1)
As of 2022-01-23 05:03 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    In 2022, my preferred method to securely store passwords is:












    Results (63 votes). Check out past polls.

    Notices?