poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tahir Akhtar" <ta...@spectrum-tech.com>
Subject RE: Excel Export
Date Fri, 05 May 2006 08:51:56 GMT
Sorry, forgot to mention, you must have web developer extension installed.

 

HYPERLINK
"http://chrispederick.com/work/webdeveloper/"http://chrispederick.com/work/w
ebdeveloper/ 

 

 

-----Original Message-----
From: Tahir Akhtar [mailto:tahir@spectrum-tech.com] 
Sent: Friday, May 05, 2006 1:46 PM
To: 'POI Users List'
Subject: RE: Excel Export

 

You can see response header in firefox by choosing Tools->Web

Developer->Information-> View Response Headers

 

You will get something like below, lookout for Content-Type header

 

Response Headers - http://livehttpheaders.mozdev.org/

 

Date: Fri, 05 May 2006 08:41:28 GMT

Server: Apache/1.3.33 (Unix) mod_gzip/1.3.26.1a PHP/4.3.11

Vary: Host

X-Powered-By: PHP/4.3.11

Content-Type: text/html

Content-Encoding: gzip

Content-Length: 3916

X-Cache: MISS from proxy.your-isp.net

Connection: keep-alive

 

200 OK

 

 

Regards,

Tahir Akhtar

 

-----Original Message-----

From: Tahir Akhtar [mailto:tahir@spectrum-tech.com] 

Sent: Friday, May 05, 2006 1:33 PM

To: 'POI Users List'

Subject: RE: Excel Export

 

Do you see file save/open dialog in browser. If you do, what happens if you

save the downloaded file on local disk and open it? 

 

Also if you are seeing save/open dialog, what happens of you choose open?

Does excel launch in this case or you see garbage within explorer?

 

If excel do not launch, browser is not getting proper headers in http

response. It can be due to mal-functioning proxy among other things. Try

different browsers to see if anyone get its right. 

 

Regards,

Tahir Akhtar

 

-----Original Message-----

From: Prasanna Balaji [mailto:pbalaji@retailexpert.com] 

Sent: Thursday, May 04, 2006 10:14 PM

To: 'POI Users List'

Subject: RE: Excel Export

 

If I write to a file then it works fine but when I send it to client screen

directly using servletoutputstream it get a garbage data. 

 

When I open the written .xls file manually I see all the data properly but

when I open it through weblogic and send it out to the client screen using

ServletOutputStream I get garbage data again.

 

 

-----Original Message-----

From: Tahir Akhtar [mailto:tahir@spectrum-tech.com] 

Sent: Thursday, May 04, 2006 1:00 PM

To: 'POI Users List'

Subject: RE: Excel Export

 

Most probably issue is related to Content Type header. What happens if you

write to a file on weblogic server with xls extension and open from there?

 

If you can get it to work by writing to a file but not through servlet

output stream, you need to check if web

 

-----Original Message-----

From: Prasanna Balaji [mailto:pbalaji@retailexpert.com] 

Sent: Thursday, May 04, 2006 9:47 PM

To: 'POI Users List'

Subject: Excel Export

 

Hi,

 

I used POI to create Excel Report but when I try to do export in WebLogic, I

get some garbage data. It works fine in Tomcat and in WebSphere.

 

response.setContentType("application/vnd.ms-excel");

ServletOutputStream sosStream = response.getOutputStream();

 

//Writing WorkBook to output Stream

      wb.write(sosStream);

 

sosStream.flush();

      sosStream.close();

 

Any input is appreciated on this.

 

Thanks,

 

Prasanna

 

 

 

 

 

---------------------------------------------------------------------

To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org

Mailing List:     http://jakarta.apache.org/site/mail2.html#poi

The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/

 

-- 

No virus found in this incoming message.

Checked by AVG Free Edition.

Version: 7.1.392 / Virus Database: 268.5.3/331 - Release Date: 5/3/2006

 

 

-- 

No virus found in this outgoing message.

Checked by AVG Free Edition.

Version: 7.1.392 / Virus Database: 268.5.3/331 - Release Date: 5/3/2006

 

 

 

 

---------------------------------------------------------------------

To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org

Mailing List:     http://jakarta.apache.org/site/mail2.html#poi

The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/

 

-- 

No virus found in this incoming message.

Checked by AVG Free Edition.

Version: 7.1.392 / Virus Database: 268.5.4/332 - Release Date: 5/4/2006

 

 

-- 

No virus found in this outgoing message.

Checked by AVG Free Edition.

Version: 7.1.392 / Virus Database: 268.5.4/332 - Release Date: 5/4/2006

 

 

 

---------------------------------------------------------------------

To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org

Mailing List:     http://jakarta.apache.org/site/mail2.html#poi

The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/

 

-- 

No virus found in this incoming message.

Checked by AVG Free Edition.

Version: 7.1.392 / Virus Database: 268.5.4/332 - Release Date: 5/4/2006

 

 

-- 

No virus found in this outgoing message.

Checked by AVG Free Edition.

Version: 7.1.392 / Virus Database: 268.5.4/332 - Release Date: 5/4/2006

 

 

 

---------------------------------------------------------------------

To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org

Mailing List:     http://jakarta.apache.org/site/mail2.html#poi

The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/

 

-- 

No virus found in this incoming message.

Checked by AVG Free Edition.

Version: 7.1.392 / Virus Database: 268.5.4/332 - Release Date: 5/4/2006

 


-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.392 / Virus Database: 268.5.4/332 - Release Date: 5/4/2006
 

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message