Mark Yes, the user would be able to save the xml file locally if they wish.
The first thing you have to do is let IE know that what is being served is, in-fact, a spreadsheet. You do this by setting the content-type in the http header to "application/vnd.ms-excel". In CSP you do this with the following tag: <csp:content type="application/vnd.ms-excel" /> (You may also have to set the expiry to overcome a bug in Excel). Thereafter all of your output can be expressed in the form of standard html tables. Excel will interpret the html and render the spreadsheet appropriately. For more advanced features like Autofilters you may have to use the Excel's XML format rather than html. Regards George George James Software VC/m - The force of change www.georgejames.com +44-1932-252568 > -----Original Message----- > From: Mark Hales [mailto:[EMAIL PROTECTED] > Posted At: 10 August 2004 10:29 > Posted To: Cach� Newsgroup > Conversation: How do I populate Excel by Row > Subject: Re: How do I populate Excel by Row > > > Thanks George, this could be an option, provided the user > could then elect to save the spreadsheet as a normal xls > file. Could you point me in the right direction - I'm not > sure how to use HTML to get IE to start Excel, or how I would > e.g. turn on Autofilter, change colors, bold rows etc. > > Thanks again, > > Mark. > "George James" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > Mark > > Did you consider turning the problem around? > > > > Instead of having Cach� create a spreadsheet via COM, you > could serve > > up the data via CSP and have IE launch Excel when it > receives a page > > with the appropriate content type. > > > > There are at least a couple of benefits to doing it this way: > > - You have the option to run the Cach� server on a non-Windows > > platform > > - The content you generate can be just an html table, which > downgrades > > nicely if Excel isn't installed on the client > > > > Of course, it all depends on what you intend should happen when the > > spreadsheet has been created... > > > > Regards > > George > > > > George James Software > > VC/m - The force of change > > www.georgejames.com > > +44-1932-252568 > > > > > > > > > > > -----Original Message----- > > > From: Mark Hales [mailto:[EMAIL PROTECTED] > > > Posted At: 10 August 2004 07:03 > > > Posted To: Cach� Newsgroup > > > Conversation: How do I populate Excel by Row > > > Subject: How do I populate Excel by Row > > > > > > > > > My last question was obviously too stupid to answer and > rightfully > > > so. Since then I've figured out how to create a spreadsheet using > > > the Generic COM interface. Got it looking exactly like a > bought one. > > > Only problem it takes ages to run. I think that this is > because I'm > > > populating one cell at a time. If I do it by row I think it will > > > speed things up, but I can't figure out how to do it. All > attempts > > > have failed with type mismatch or populated every row > with the same > > > value. > > > > > > I assume I'll need to do > > > > > > range.SetProperty("Value",x) > > > > > > and that x has to be a variant. I've done this in Delphi > in the dim > > > dark past by using an array of variant. Does anyone know how I do > > > this in Cache ? > > > > > > > > > >
