poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bates, Alex" <AB210...@teradata-ncr.com>
Subject RE: OWC as viewer, POI as generator
Date Fri, 03 Oct 2003 21:50:25 GMT

Thanks Ryan...this was actually the exact approach I was using - actually to
generate the default, I used FrontPage, dropped OWC on the html form, and
viewed the page as text.  It created an OBJECT tag which contained an
attribute called XMLData, which had lots of information including the
ConnectionString.  The ConnectionString stored the Provider and DataSource
properties that I was using to test.

In addition to manipulating the XMLData text directly, I also tried going
through FrontPage's wizards for configuring the OWC data source, but
couldn't get the url version working.

Alex


-----Original Message-----
From: Ryan Ackley [mailto:sackley@cfl.rr.com] 
Sent: Friday, October 03, 2003 2:42 PM
To: POI Users List
Subject: Re: OWC as viewer, POI as generator


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" <AB210009@teradata-ncr.com>
To: "POI Users List" <poi-user@jakarta.apache.org>
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:sackley@cfl.rr.com]
> 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" <AB210009@teradata-ncr.com>
> To: <poi-user@jakarta.apache.org>
> 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: poi-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: poi-user-help@jakarta.apache.org
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
>


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org


Mime
View raw message