Win32::OLE - Excelo files hidden after SaveAs

[Woland99]

Hi, I use Win32::OLE to read in and manipulate data from
Excel files. When I try to SaveAs modified file and then
reopen it I always have to Unhide it.
For example:
$wbook = ....

in a loop....
{
.....
$wsheet->Cells($row_num,$col_num)->{Value} = "$cell_value";
.....
}

and then:
$wbook->SaveAs($fullname_output_file);

makes $fullname_output_file hidden.
I do not see any property I can set on $wbook to Unhide it
(same way as from Windows menu in Excel).

Thanks for any pointers,

JT

 

[Henry Law]

Hi, I use Win32::OLE to read in and manipulate data from
Excel files. When I try to SaveAs modified file and then
reopen it I always have to Unhide it.

I do not see any property I can set on $wbook to Unhide it
(same way as from Windows menu in Excel).

This is almost certainly an Excel COM problem rather than a Perl one,
which means that you will probably get better help in a Microsoft COM
group rather than here (but you may need to hide the fact that you're
programming the COM object in such a sensible language as Perl!)

But if you Google in the groups for a post entitled "Win32::OLE hiding
Excel sheets" (dated April 2003) you'll see some suggestions.

 

[Woland99]

foreach $window (in $wbook->{Windows})
{$window->{Visible} = 1;}
and then:
$wbook->SaveAs($fullname_output_file);
does the trick.

JT