A third option posts HTML Table formatted data (in a new browser window) to a server-side script (ColdFusion in my case but ASP/JSP/PHP should work as well) which then reflects it to the browser with the MIME type set to one of the myriad Excel versions. Then the browser handles it as needed (save file, ask user, open in Excel, etc.).
On Tue, Dec 2, 2008 at 3:01 PM, jim.abbott45 <[EMAIL PROTECTED]> wrote: > I've successfully implemented two different approaches. > > The first approach just puts the data for Excel _on the clipboard_. It > also uses Microsoft's uber-funky XML schemas to control the formatting > of the resulting spread-sheet. This approach works nicely for both FF > and IE, in my experience (and, in theory, it should work in any > browser that supports the Flash VM, including clipboard access). > > The second approach uses the ExternalInterface API to call a JS > function which uses ActiveX to invoke the Excel COM object. If the JS > function is able to load the Excel object, it then calls the object's > COM interface directly (via JS functions) in order to create a > Workbook and then to load data into its cells. Unfortunately, this > approach only works with IE, but it is slick if you can use it. But, > having the first approach as a fall-back is a good idea even then, in > my opinion. > > Let me know if you have any specific questions about implementing > either of these. > > Regards, > Jim > > > ------------------------------------ > > -- > Flexcoders Mailing List > FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt > Alternative FAQ location: > https://share.acrobat.com/adc/document.do?docid=942dbdc8-e469-446f-b4cf-1e62079f6847 > Search Archives: > http://www.mail-archive.com/flexcoders%40yahoogroups.comYahoo! Groups > Links > > > > -- Howard Fore, [EMAIL PROTECTED] "The universe tends toward maximum irony. Don't push it." - Jeff Atwood
