Re:Sorry, Geeks, Microsoft Excel is Everywhere
by encoderer on Thursday February 14, 2013 @03:29PM
(#5221961)
The last time I've done this I just have a link that sets the content type header to something like text/excel (that's not it exactly i don't think, google for it) and on Windows at least it always worked to open the page in Excel. And if you use an HTML table, excel will just open it as a spreadsheet, including any CSS text formatting you use.
Is that what you meant, or did I answer a different question?
Re:Sorry, Geeks, Microsoft Excel is Everywhere
by jackalope on Thursday February 14, 2013 @04:03PM
(#5222252)
Unfortunately, Excel can't cope with some of the more modern authentication systems being deployed on the web, so it's no longer as easy as providing a URL that spits out an HTML table, if you have to protect sensitive data behind a login (I think it can handle HTTP-Basic, but not anything requiring redirects; this may have changed in recent versions).
Re:Sorry, Geeks, Microsoft Excel is Everywhere
by stan_rogers on Thursday February 14, 2013 @06:52PM
(#5223449)
It's "application/vnd.ms-excel" for recent versions.
Re:Sorry, Geeks, Microsoft Excel is Everywhere
by flomo on Thursday February 14, 2013 @06:27PM
(#5223313)
Yep. Believe you also need to set something like this:
Content-Disposition: attachment; filename="foo.xls"
Re:Sorry, Geeks, Microsoft Excel is Everywhere
by doppenhe on Thursday February 14, 2013 @03:16PM
(#5221879)
www.excelmashup.com
Re:Sorry, Geeks, Microsoft Excel is Everywhere
by bcoates on Thursday February 14, 2013 @04:12PM
(#5222313)
... Yeah, that's what I was thinking of. Thanks!
ps. you should make the generated script tag do src="//r.office.microsoft.com/r/rlidExcelButton?v=1&kip=1" so the http/https issue in your FAQ goes away
One thing I haven't figured out how to do is have a link on my page that triggers an Excel HTML import operation on the current page.