I am creating an Excel spreadsheet using XML, I've written the XML via Coldfusion, but I don't think it matters which language is used.
Problem 1) When opening the file, I get the warning message "You are trying to open 'myFile.xls' in a different format than specified by the file extension. Verify that it is not corrupted and from a trusted source before opening the file" I've tried many different content types, etc. How do I get rid of this message?
Problem 2) When I save the file to my desktop it wants to save it as an .XML file and I have to change the type manually. I can't ask my users to do this. I need to generate the file and have it act like an Excel file.
For content types, I have used every variation of Excel such as..
Thanks for any help!