
halis
Novice
Feb 1, 2011, 2:21 PM
Post #1 of 2
(11892 views)
|
Creating Excel File in Perl
|
Can't Post
|
|
I have managed to write a script that logs in to a website using HTTP::Cookies. I then open a link to a php script which starts an excel download. I have figured out how to get the PHP script to run and to give me the Excel data via LWP. Now that I have all the excel data, it is easy for me to output the data to a file such as, "abc.xls". Which I have done. When I open that xls file it says that, "The file you are trying to open "abc.xls", is in a different format than specified by the file extension." I click Yes to open it and it opens fine. Now my questions: 1) How can I save this data the proper way to an Excel file, so it does not give me this message? 2) How can I take the data and save it as a new Worksheet in an already existing Excel file?
|