cffunction build to download the .xsl file. when user tries to open .xsl file in msoffice2007 environment the function gives an error and do not allow to open.
I think my question was not clear, let me give describe it more.
I am using coldfusion 7 version and in my machine I have msoffice2007
with the earliar version of msoffice i.e. '2003' the code was working fine without any error.
I have used this code to let the user open or download excel sheet.
<cffunction access="public" name="ExcelDownload" output="true" returntype="void"> <cfargument name="header" type="string" required="no"> <cfargument name="Filename" type="string" required="yes"> <cfset var CRLF=chr(13)&chr(10)> <cfcontent type="application/vnd.msexcel"> <cfheader name="Content-Disposition" value="attachment; filename=#Filename#"> <cfif isDefined('header')> <cfoutput>#header##CRLF##CRLF#</cfoutput> </cfif> </cffunction>
when I try to download an excel file from the above cfm module it opens an excel sheet with an error message popped up which says:
"C:\<path>\Filename.xls" could not be found. Check the spelling of the file name, and verify that the file location is correct. If you are trying to open the file from your most recently used files, make sure that the file has not been renamed, moved or deleted.
hope this will help in understanding the problem.