Excel problem in abstract portal component

[Former Member]

Hi All,

I am following this blog to Link: [http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/1390] [original link is broken]; to create an excel file.

However when i try to display this file in the portal I get a random page with the data appearing with random data. I am not sure if any server configurations need to be done for this.

Could somebody please help.

Thanks & Regards,

Malita Ferns

[Former Member · Accepted solution]

Try below code to output Excel.

OutputStream out = response.getOutputStream();
				response.setContentType("application/vnd.ms-excel");
				response.setHeader(
					"Content-disposition",
					"attachment; filename=" + "Report.xls");
				wb.write(out);
				out.flush();
				out.close();

wb is workbook object.

Thanks