blackadder has asked for the wisdom of the Perl Monks concerning the following question:

Hi,

Is there away to make my Excel workbook visible when using this module? similar to the way Win32::OLE module does in $xls->{Visible}=1;

Thanks

Blackadder
  • Comment on Making Spreadsheet::WriteExcel workbook visible

Replies are listed 'Best First'.
Re: Making Spreadsheet::WriteExcel workbook visible
by Errto (Vicar) on Dec 18, 2004 at 17:17 UTC

    Spreadsheet::WriteExcel is used only for writing Excel files. It understands the Excel format but does not have a spreadsheet display engine in it. To actually display a spreadsheet you need Microsoft Excel itself or a compatible application such as Gnumeric or OpenOffice. Each of these has its own API and different Perl bindings for them.

    Update: It appears that OpenOffice does not have an officially supported API binding for Perl, though one is under development here.

      Understood,...Thanks indeed.

      Blackadder