Is an Excel file a true Excel file?
Here's a little history on the issue:
I hired contractor 1 to push data from a MSSQL SELECT stored procedure into an Excel 2003 spreadsheet using my ASP.NET interface. The sneaky little #%!# tried to fake it. He pushed my SELECT stored procedure data into an HTML table and assigned an XLS file extension to the file. Sure enough, Excel opened the file, but it wasn't a true Excel file.
Contractor 1 is gone. Enter contractor 2. I hired him to do the same thing. I'm reasonably sure that his work is genuine. I've attached it. Are there clues I can look for in the metadata to assure it is a "true" Excel file?
Sample.xls
I hired contractor 1 to push data from a MSSQL SELECT stored procedure into an Excel 2003 spreadsheet using my ASP.NET interface. The sneaky little #%!# tried to fake it. He pushed my SELECT stored procedure data into an HTML table and assigned an XLS file extension to the file. Sure enough, Excel opened the file, but it wasn't a true Excel file.
Contractor 1 is gone. Enter contractor 2. I hired him to do the same thing. I'm reasonably sure that his work is genuine. I've attached it. Are there clues I can look for in the metadata to assure it is a "true" Excel file?
Sample.xls
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
redmondb
Edit: Apologies all - incorrect post removed.
ASKER
Great answers guys.
KyleSW - Your suggestion that an HTML format may be acceptable is a good one.
KyleSW - Your suggestion that an HTML format may be acceptable is a good one.