Making Spreadsheet::WriteExcel workbook visible

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.	[reply]
Re^2: Making Spreadsheet::WriteExcel workbook visible by blackadder (Hermit) on Dec 18, 2004 at 17:27 UTC
Understood,...Thanks indeed. Blackadder	[reply]

Back to Seekers of Perl Wisdom