Hello monks,
i've a problem ungrouping the textboxes in Excel sheets(using OLE module) can anyone give my the expression to do so. waiting for the answer..
as an eg: consider a sheet consisting of many textboxes and some of them are grouped,i want to read the contents of this textboxes. But unless i ungroup these textboxes i cant read.
As an example, im just writing the piece of code for printing all the textboxes:
my $text_box_num = $ws->TextBoxes->Count()
foreach my $number (1..$text_box_num)
{
my $text_box_name = $ws->TextBoxes($number)->{Name};
my $extract = $ws->TextBoxes($number)->{'text'};
print "$text_box_name---$extract\n\n";
}
-regards
aravind