Feb 1, 2011, 2:21 PM
Post #1 of 2
I have managed to write a script that logs in to a website using HTTP::Cookies.
Creating Excel File in Perl
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?