I have an Excel file in OfficeML format, MyData.xls Since I upgraded from Office 2003 to Office 2007, so I get the warning message that the file content does not match the file extension. It looks like the extension 'xml' should now be in OfficeML.
I use OleClientSite to display the file in the OleFrame object, if I change the file extension on 'XML' then Excel does not start. If I leave the extension as 'xls' then I get the warning message above.
How can I force the file to open the 'xml' extension in the wetframe using extb? Switching back to 2003 format is the simplest way, which should not require any changes in your application.
. To do this, open your file with the extension set to * .xls. When prompted with a warning ("... do you want to open the file now?"), Proceed to open (this is a warning to make sure that you unknowingly open a macro-enabled file Are not) Once more the file is open in Excel, just save it as * .xls it can be done by going to "Office Buttons / Save As / Excel 97-2003 Workbook".
Now, the hard solution will upgrade your application to deal with the new OfficeML format. I do not know about the component you are using, but it will still work for some of the binary parts in the new standard (most notably VBA projects), but you have to open and start reading XML files .
If you have not already done so, create a new Excel workbook, save it to * .xlsx (2007 format) and Explorer, * expand it at .zip, open it and have a look around keep. For more depth on the files, I will start digesting it
Comments
Post a Comment