Writting to .xlsx files

[wolfjmt]

Hi, I am trying to write to data to a .xlsx file. I can currently write the data to a .xls file. I tried to change the extension of the xls file (to xlsx) but Excel gave the following error:Excel cannot open the file 'Filename.xlsx' because the file format or file extent ion is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.
I know Excel can open the xls file but I would like to save the data to a xlsx file.
Any advice would be greatly appreciated
Thanks

[Stang02GT]

trying taking the x off the end of the file name. I believe that Excel uses xls not xlsx.


Moving to Misc as the software dev forum is not a place for this type of question.

[DonRayner]

xlsx is a excel 2007 extension where xls is pre 2007 excel extension. You can get drivers from Micro$oft to open the xlsx extension with previous versions of excel but I don't believe that you will be able to save in that format.

Try doing a google search for converting xls to xlsx and you will probally find some online conversion tools.

[Stang02GT]

Learn something new everday. I really haven't used or know much about the new office suite. My work still uses previous versions.

[RedSon]

Just for the record, modifying the extension of the file does not change what type of file you have. If I write a book called MyStory.txt and I want to compress it and email it to my friend I don't change the filename to MyStory.zip and send it away. All you are doing is renaming the file.

[wolfjmt]

Thanks for your input guys