Hi Vinay,
if you followed the example then you have to add a sall part (thanks
again to Arvid who pointed me into that direction some week ago):
Object response = context.getExternalContext().getResponse();
if (response instanceof HttpServletResponse) {
HttpServletResponse servletResponse = (HttpServletResponse) response;
servletResponse.setContentType("application/vnd.ms-excel");
servletResponse.setHeader("Content-Disposition", "attachment;
filename=" + attachmentName);
...
}
I think the example is missing the "filename=" part in the header
information.
Hop this helps.
Regards,
Stefan.
Vinay Konanki schrieb:
> Hi Bernd,
> Thank you very much, now im able to export to excel.
> When is open online its opening with MS Excel but when i saves the
> file to hard disk it is saving as "filename.faces" instead
> "filename.xls ", as there is no xls extension the file is not opening
> with MS Excel.
>
> Controller file includes like this
>
> try {
> UIData table = getData();
> FacesContext context = FacesContext.getCurrentInstance ();
> writeWorkbook(table,"OrderHistory",context);
> context.responseComplete();
> }
> catch(Exception e) {
> log.error(e);
> }
>
> which will call writeWorkBook method by passing file name as one of
> the parameters.
>
> What can i include in the controller so that the file will save with
> ".xls" extension.?
>
> Thanks,
> Vinay
>
> On 3/17/07, *Bernd Bohmann * <[EMAIL PROTECTED]
> <mailto:[EMAIL PROTECTED]>> wrote:
>
> You can add a component binding
>
> tc:sheet binding="#{controller.table} ...
>
> table is a UIData instance
>
> Vinay Konanki wrote:
> > Hi Bernd,
> >
> > Thanks for your reply.
> > How can i pass the UIData from jsp to controller as writeWorkBook()
> > requires
> > UIData object as parameter,
> > I added ActionListner method to the controller where im calling
> > writeWorkBook() method and passing required parameters,
> > But my question is how can i pass the UIData Object, i guess i
> need to get
> > from UI where UIData object is nothing but sheet/table
> controller in the
> > UI.
> > correct me if im wrong.
> >
> > Can you send me sample code of jsp how i can pass UIData to
> controller.
> >
> > My requirements are there will be sheet controller in the jsp
> page which
> > contains Customer Details, there will be link called "excel
> export". when
> > we click on the link it has to show a popup which tells "Open /
> Save as"
> > window.
> >
> > Can i achieve the above task (popup window) with your sample
> code which
> > specified in your previous mail?
> > Some thing like this (http://*tobago*.atanion.net/*tobago*
> > -example-demo/faces/best-practice/non-
>
> faces-response.jsp<http://tobago.atanion.net/tobago-example-demo/faces/best-practice/non-faces-response.jsp>)
> >
> > the "second one".
> >
> > Waiting for your reply
> >
> > Thanks,
> > Vinay
> >
> >
> >
> > On 2/25/07, Bernd Bohmann < [EMAIL PROTECTED]
> <mailto:[EMAIL PROTECTED]>> wrote:
> >>
> >> Hello Vinay,
> >>
> >> just added an export excel example to test.
> >>
> >> Please look at
> >>
> >>
> >>
>
> http://svn.apache.org/repos/asf/myfaces/tobago/trunk/example/test/src/main/java/org/apache/myfaces/tobago/example/test/ExportUIDataToWorkbookUtil.java
>
> <http://svn.apache.org/repos/asf/myfaces/tobago/trunk/example/test/src/main/java/org/apache/myfaces/tobago/example/test/ExportUIDataToWorkbookUtil.java>
> >>
> >>
> >> Regards
> >>
> >> Bernd
> >>
> >> Vinay Konanki wrote:
> >> > Hi all,
> >> >
> >> > Please help me in this regard,
> >> >
> >> > Thanks,
> >> > Vinay
> >> >
> >> > ---------- Forwarded message ----------
> >> > From: Vinay Konanki <[EMAIL PROTECTED]
> <mailto:[EMAIL PROTECTED]>>
> >> > Date: Feb 22, 2007 11:40 PM
> >> > Subject: [Tobago] How to export data to excel sheet in Tobago
> >> > To: [email protected] <mailto:[email protected]>
> >> >
> >> > Hi all,
> >> >
> >> > I have very quick question.
> >> > I have data in Sheet(tc:sheet) and i need to export that data
> into
> >> excel
> >> > Sheet,
> >> > im using Tobago1.0.10
> >> >
> >> > Can any one suggest me how i can achieve this.
> >> > is there any tags available in tobago.
> >> >
> >> > Is there any examples available online.
> >> >
> >> >
> >> > Thanks in advance,
> >> >
> >> > Vinay
> >> >
> >>
> >
>
>
