Posted on 2005-08-18 17:45:27-07 by arnavkd
writing into a file
Hi Guys, I am very new to perl. I really like this modeule. could some one please help to write the output of as_xls into an Excel file? Thanks in advance
Direct Responses: 914 | Write a response
Posted on 2005-08-19 01:20:50-07 by jmcnamara in response to 912
Re: writing into a file

You can use something like the following:

# Spreadsheet::WriteExcel::FromDB code. ... open FH, '>test.xls' or die "Couldn't open excel file: $!\n"; binmode FH; print FH $ss->as_xls; close FH;

See the perlopentut manpage, and the print() and open() functions in the perlfunc manpage (or the equivalent Windows docs).


John.
--
Direct Responses: 915 | Write a response
Posted on 2005-08-19 13:41:35-07 by arnavkd in response to 914
Re: writing into a file
Worked. Thanks you so much.
Direct Responses: Write a response
Perl Weekly newsletter
A free weekly newsletter for people who are busy to read all the blogs. click here to check it out.