I downloaded a file with a
.xls extension. I thought it was a regular excel spreadsheet file so I opened it using Excel 2007.
However, it tells me that the file I'm trying to open is in a different format than specified by the extension.
I ignored the warning and opened it anyways, and it opened fine. Looked just like any other spreadsheet. I opened the file in a regular text editor and it was an HTML file using some custom XML namespace
<html xmlns:o='urn:schemas-microsoft-com:office:office' xmlns:x='urn:schemas-microsoft-com:office:excel' xmlns='http://www.w3.org/TR/REC-html40'> <head> <meta http-equiv='Content-Type' content='text/html; charset=windows-1252'/> <meta name='ProgId' content='Excel.Sheet'/> <meta name='Generator' content='Microsoft Excel 11'/> <link rel='File-List' href='Book1_files/filelist.xml'/> <link rel='Edit-Time-Data' href='Book1_files/editdata.mso'/> <link rel='OLE-Object-Data' href='Book1_files/oledata.mso'/>
I looked up what it was and came across these
It seems like these types of files are called "dynamic excel files" because it's easy to generate.
Anyways I was wondering if there was a proper way to name the files so that excel doesn't complain that the file format is different from the file extension?