Displaying an Excel file in a CF page, period.

I've been tearing my hair out all day with this. I have an Excel file that will be uploaded each day by one user who logs in and uploads it via a form. The Excel file has multiple worksheets. The names of the worksheets and even the columns will change and I won't be privy to these changes.

Re: Displaying an Excel file in a CF page, period.

Thanks. I found that earlier today and actually tried it out but numerous errors frustrated me. I'm dealing with MX 6.1 and even though I found and applied a fix to the CFC for 6.1, I just got a different error down the line. I am really hoping to just be able to display the Excel file within t

Re: Displaying an Excel file in a CF page, period.

Is there a sample out there somewhere? I messed with it but couldn't get it to work. > Is there a reason you cannot just read in the file as binary. Then > display it inline with cfcontent and correct mime header (assuming the > user's browser settings allow ...)? > ~~~

Re: Displaying an Excel file in a CF page, period.

I'll take a whack at it, thanks much! >Something like: > > > > >file="#expandpath('../../../path/to/excel/file/stored/outside/web/root/excel.xls')#" >variable="myvar"> > > > > >Note: if you need to do this "in" a page that has other stuff on it, you >could use a frame or an iframe. > > > > >> ~

Re: Displaying an Excel file in a CF page, period.

Well it appears that MX 6.1 doesn't support the "variable" attribute of cfcontent. I may have access to CF9 tomorrow, but in the meantime is there any way to get this file delivered with MX 6.1? ~| Order the Adobe Coldfusion

Re: Displaying an Excel file in a CF page, period.

Thanks! I've got it prompted to download the file with: ...but it's still a no-go on displaying inline. Presumably the downloader can still edit the file if they want to. >Try: > >file="#expandpath('../../../path/to/excel/file/stored/outside/web/root/excel.xls')#" >type="application/mse

Re: Displaying an Excel file in a CF page, period.

Thank you both. In IE it opens in the browser window (prompts first), in Firefox it prompts for download. This may be as good as I can get without reading the file and writing tables..? Currently using (if i add the cfoutput code it does the same thing) ~~

Re: Displaying an Excel file in a CF page, period.

Will this do something different than what i'm doing in 6.1 now? If so I'll try it tomorrow when I'll hopefully access to CF9. > Put the file outside a web accessible directory and serve it up as > binary using not . ~| Ord