Apparently, you can embed xml into the html <object> tag or something and this will describe the spreadsheet. I found this out by going to OfficeXP and saving a sheet as a web page. Good luck finding documentation on this anywhere...
Ryan Ackley ----- Original Message ----- From: "Bates, Alex" <[EMAIL PROTECTED]> To: "POI Users List" <[EMAIL PROTECTED]> Sent: Friday, October 03, 2003 5:16 PM Subject: RE: OWC as viewer, POI as generator > > All our clients have a site license for Excel. They've paid for it and want > to use it, including pivot table, charting, printing, email attachment, etc. > I will check out your sheet viewer applet, but in this case they definitely > want to use MS Excel. > > So, has nobody out there has attempted this (use OWC to point to POI > servlet)? It seems like there has to be a way, given that you can point OWC > to a file data source. > > Alex > > > -----Original Message----- > From: Ryan Ackley [mailto:[EMAIL PROTECTED] > Sent: Friday, October 03, 2003 1:40 PM > To: POI Users List > Subject: Re: OWC as viewer, POI as generator > > > I'm on Windows. We looked at OWC (Office Web Components) for our product at > work. I personally think it sucks because it requires Excel to be installed > on the client. On the other hand, the sheet viewer applet like Andy > recommended has no such requirement. It only requires the JRE (completely > free btw, if you don't count the time it takes for the download). > > ----- Original Message ----- > From: "Bates, Alex" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, October 03, 2003 12:44 PM > Subject: OWC as viewer, POI as generator > > > > Hi All, > > > > As we all know, when viewing XLS content in the browser, the developer > > has no control over whether the XLS is launched in a new window, and > > whether > the > > user is prompted. This is because these are desktop settings > > controlled > via > > the folder options -> file types -> xls -> advanced tab in Windows > Explorer. > > > > The nice thing about Microsoft's OWC browser control is it works > > around > this > > issue. Usign OWC, it overrides this setting and forces the XLS to be > > displayed in the browser. But even better, it has a button "Export to > > Excel" that will actually lauch MS Excel with the contents of the XLS. > > Without this option, the user would have to copy the contents of the > > XLS frame and paste into Excel, not good. > > > > What I want to do is take advantage of POI's excellent XLS generation > > capabilities, and OWC's usability features. POI is capable of > > pointing to > a > > file data source (instead of ODBC). So what I want to do is point to > > a > URL > > data source, which is the POI servlet that generates the XLS. > > > > Q: how to set the OWC DataSource to point to the url of the POI > > servlet that generates the XLS? > > > > So, I have a JSP page that has an <OBJECT....> with the embedded OWC > object. > > One of the properties of this object is the connection string. I've > > found documentation on how to point to a file data source, using > > > > Provider=Microsoft.Jet.OLEDB.4.0;Data Source=<filename>;Extended > > Properties=Excel 10.0;' > > > > I've tried setting <filename> to the url of the servlet, but it > > doesn't > seem > > to work. > > > > Any one else out there tried this? > > > > Alex > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
