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.
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
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 ...)?
>
~~~
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.
>
>
>
>
>>
~
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
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
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)
~~
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
8 matches
Mail list logo