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 ? > > > > >
