-Original Message-
From: Ajay Chitre [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 29, 2002 3:16 PM
To: Struts Users Mailing List
Subject: RE: Excel Export
I really liked Vic's suggestion regarding SOAP. I am going to explore that
myself. In the mean time here's a quick dirty Test.jsp
jsp forward to forward to this file(data.csv).
From: Chen, Dean (Zhun) [EMAIL PROTECTED]
Reply-To: Struts Users Mailing List [EMAIL PROTECTED]
To: 'Struts Users Mailing List' [EMAIL PROTECTED]
Subject: RE: Excel Export
Date: Fri, 3 May 2002 11:38:19 -0400
I have a simple question regarding
,
Dave
Chen, Dean (Zhun) [EMAIL PROTECTED] on 05/03/2002
11:38:19 AM
Please respond to Struts Users Mailing List
[EMAIL PROTECTED]
To: 'Struts Users Mailing List'
[EMAIL PROTECTED]
cc:(bcc: David Hay/Lex/Lexmark)
Subject: RE: Excel Export
I have a simple question regarding
Subject: Re: Excel Export
From: Vic Cekvenich [EMAIL PROTECTED]
===
We need macros and formulas in Excel, so SOAP works here.
(Nice thing about MVC is that if the presenation layer changes
(currently JSP) you can still use the beans with a ... Excel presenation).
Vic
Galbreath, Mark wrote
I use plain jsp to do this.
response.setHeader(Content-Disposition,attachment;filename=data.csv);
response.setHeader(Content-Type, application/ms-excel);
String result=Whatever you wanna export as csv;
out.write(result);
From: Chen, Dean (Zhun) [EMAIL PROTECTED]
Reply-To: Struts Users Mailing
Subject: Re: Excel Export
From: Vic C [EMAIL PROTECTED]
===
Struts is Java. Excel is VBA. They don't like each other. One good way
is to expose your Java (Form) beans via SOAP.
Then in Excel (using Pocket Soap client for example) write a VBA macro
that gets the SOAP XML data.
You will need
Newsgroup [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 29, 2002 1:40 PM
To: [EMAIL PROTECTED]
Subject: Re: Excel Export
Subject: Re: Excel Export
From: Vic C [EMAIL PROTECTED]
===
Struts is Java. Excel is VBA. They don't like each other. One good way
is to expose your Java (Form) beans via SOAP
.
Mark
-Original Message-
From: Struts Newsgroup [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 29, 2002 1:40 PM
To: [EMAIL PROTECTED]
Subject: Re: Excel Export
Subject: Re: Excel Export
From: Vic C [EMAIL PROTECTED]
===
Struts is Java. Excel is VBA. They don't like each other. One good way
]
Subject: RE: Excel Export
Date: Mon, 29 Apr 2002 13:44:00 -0400
This is way too complicated. All you have to do is set the MIME type in
the
setContentType() declaration in the servlet delivering the output to
application/vnd.msExcel and the browser will automatically display the
output in an Excel
, 2002 1:44 PM
To: 'Struts Users Mailing List'
Subject: RE: Excel Export
Importance: Low
This is way too complicated. All you have to do is set the MIME type in the
setContentType() declaration in the servlet delivering the output to
application/vnd.msExcel and the browser will automatically display
List'
Subject: RE: Excel Export
Is there a way to have the browser actually download the excel file instead
of just rendering the file within the browser? And if so, what about images
displayed within the rendered excel?
jsh
-Original Message-
From: Galbreath, Mark [mailto:[EMAIL
: Galbreath, Mark [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 29, 2002 5:06 PM
To: 'Struts Users Mailing List'
Subject: RE: Excel Export
Anytime you point your browser to http://whatever.file.xls, it will invoke
Excel and display whatever is contained in the file within the browser
window
Dean,
In addition to what has already been said regarding the MIME type, I'd like to
mention a very good tool we're using for one of our projects: Java Excel API, A
Java API to read, write and modify Excel spreadsheets.
It generates files in xls format (not just CSV). Very good product. And
13 matches
Mail list logo