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