excel's FIND

Discussion in 'Perl Misc' started by werwer, Sep 21, 2005.

  1. werwer

    werwer Guest

    I've flipped thru cells looking for data. It works well. However,
    I'd like to try excel's FIND function. I've only started and
    already I'm stumped. How do I use this? I have to test for
    success and collect the address of the cell found. Thanks.

    sheets:
    foreach my $ws (in $MyWorkbook->Sheets) {
    $ws->Find('What:=CL247', 'After:=ActiveCell',
    'LookIn:=xlFormulas', 'LookAt:=xlPart',
    'SearchOrder:=xlByRows',
    'SearchDirection:=xlNext', 'MatchCase:=False',
    'SearchFormat:=False');
    } # sheets:
     
    werwer, Sep 21, 2005
    #1
    1. Advertising

  2. werwer

    Guest

    "werwer" <> wrote:
    > I've flipped thru cells looking for data. It works well. However,
    > I'd like to try excel's FIND function. I've only started and
    > already I'm stumped. How do I use this? I have to test for
    > success and collect the address of the cell found. Thanks.
    >
    > sheets:
    > foreach my $ws (in $MyWorkbook->Sheets) {
    > $ws->Find('What:=CL247', 'After:=ActiveCell',
    > 'LookIn:=xlFormulas', 'LookAt:=xlPart',
    > 'SearchOrder:=xlByRows',
    > 'SearchDirection:=xlNext', 'MatchCase:=False',
    > 'SearchFormat:=False');
    > } # sheets:


    There is more than one module which (claims to) work with xls files.
    From the above code, I can't tell which one of them you are using.

    Xho

    --
    -------------------- http://NewsReader.Com/ --------------------
    Usenet Newsgroup Service $9.95/Month 30GB
     
    , Sep 21, 2005
    #2
    1. Advertising

  3. werwer

    werwer Guest

    This is part of the 2003 collection. It "copied" right out
    of a macro.

    wrote:
    > "werwer" <> wrote:
    > > I've flipped thru cells looking for data. It works well. However,
    > > I'd like to try excel's FIND function. I've only started and
    > > already I'm stumped. How do I use this? I have to test for
    > > success and collect the address of the cell found. Thanks.
    > >
    > > sheets:
    > > foreach my $ws (in $MyWorkbook->Sheets) {
    > > $ws->Find('What:=CL247', 'After:=ActiveCell',
    > > 'LookIn:=xlFormulas', 'LookAt:=xlPart',
    > > 'SearchOrder:=xlByRows',
    > > 'SearchDirection:=xlNext', 'MatchCase:=False',
    > > 'SearchFormat:=False');
    > > } # sheets:

    >
    > There is more than one module which (claims to) work with xls files.
    > From the above code, I can't tell which one of them you are using.
    >
    > Xho
    >
    > --
    > -------------------- http://NewsReader.Com/ --------------------
    > Usenet Newsgroup Service $9.95/Month 30GB
     
    werwer, Sep 22, 2005
    #3
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. =?Utf-8?B?SmltIEhlYXZleQ==?=

    Excel _WorkBook vs. Excel.Workbook

    =?Utf-8?B?SmltIEhlYXZleQ==?=, Sep 29, 2004, in forum: ASP .Net
    Replies:
    1
    Views:
    3,660
    Steve C. Orr [MVP, MCSD]
    Sep 29, 2004
  2. =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=

    Problem with Excel reports ::::Excel 2003 Migration To Excel 2007

    =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=, Oct 5, 2007, in forum: ASP .Net
    Replies:
    15
    Views:
    1,548
    =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=
    Oct 24, 2007
  3. Wybo Dekker
    Replies:
    1
    Views:
    379
    Yukihiro Matsumoto
    Nov 15, 2005
  4. vdvorkin
    Replies:
    0
    Views:
    424
    vdvorkin
    Feb 10, 2011
  5. vdvorkin
    Replies:
    3
    Views:
    827
    vdvorkin
    Feb 14, 2011
Loading...

Share This Page