Re: Win32::OLE Find in Table method

If $table stores the table object in Word, then the following code looks for a particular $pattern:

for my $i (1..$table->Rows->Count) {
    for my $j (1..$table->Columns->Count) {
        my $text = $table->Cell($i,$j)->Range->Text;
        print "($i:$j) $text\n" if $text =~ /$pattern/;
    }
}
[download]

Comment on Re: Win32::OLE Find in Table method Select or Download Code

Replies are listed 'Best First'.
Re^2: Win32::OLE Find in Table method by DVCHAL (Novice) on Oct 29, 2013 at 09:27 UTC
Thank you HDB..Its Perfect.	[reply]
Re^2: Win32::OLE Find in Table method by DVCHAL (Novice) on Oct 29, 2013 at 11:02 UTC
It would be very helpful to me if you give the way to find the Methods Available for Table Processing and the way to use it as i will be majorly doing on Table Processing in Perl. Thanks in Advance.	[reply]
Re^3: Win32::OLE Find in Table method by Anonymous Monk on Oct 29, 2013 at 12:05 UTC
See this collection of win32 tutorials/examples , especially Use The Macro Recorder, Luke (Re: Using Win32::OLE and Excel - Tips and Tricks) -- 98% of the docs are on msdn	[reply]
Re^3: Win32::OLE Find in Table method by hdb (Monsignor) on Oct 29, 2013 at 11:30 UTC
That does not exist to my knowledge. What you need to do is to familiarize yourself with the VBA object model (especially the object browser in the MS Office programs is useful) and learn how to translate VBA into Perl. PerlMonks has a lot of material on this. If you search for "Win32::OLE" you will find many helpful posts.	[reply]