I got this working almost immediately. Initially used HTML then XML, which is far nicer and much more concise. Now I have a new problem. I sent someone a link to a .cls that creates a spreadsheet using this method (one that works from a "normal" PC). They clicked on the link in the email on lotus notes on Citrix desktop and after the initial "do you want to open got a bunch off errors to do with being unable to access the file http://cache01/csp/ ...
This is bound to be an MS bug. Anyone come across this one before ? "George James" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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 ? > > > > > > > > > > > > > > > >
