Skip to Content
0
Former Member
Oct 12, 2005 at 12:12 AM

Export data from an iView to Excel, get a login screen displayed in Excel

41 Views

Hi

I'm trying to export data from a tableview to excel, I followed the instruction posted by Detlev Beutner, created a class extends AbstractPortalComponent, and overwrote the doOnNodeReady:

HttpServletResponse response = request.getServletResponse(true);

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

response.setHeader("Content-Disposition", "filename=\"text.xls\"");

I did write some test output in doContent:

aResponse.write("Filed11,Filed12,Field13");

aResponse.write("Field21,Field22,Field23");

I was hoping to see the excel to display the content "Field11 Field12...", but I got a portal login screen displayed in Excel.

Does anyone have the same experience and and idea on this?

Thanks

Yutong