JEXCEL to JSP

[Chinni Bujji]

I am trying to send output to the JSP by using the JEXCEL technique
but i am not able to do it please help

I wrote the following code and after that what do i need to do in the JSP to view this excel sheet

is it the right way i am creating the workbook
that is is it the right parameter that i am passing in the createworkbook method

please help

    

			
			
			String contentType ="application/vnd.ms-excel";
	    	String fileExtension = ".txt";//".xls";
	    	String fileName = "tracing_details_" + System.currentTimeMillis() + fileExtension;
			
			
			ByteArrayOutputStream bos = new ByteArrayOutputStream();
			String disHeader = "Attachment; Filename = \"" + fileName;
              res.setHeader("Content-Disposition", disHeader);
        	
       

        res.setContentType(contentType);
        OutputStream out = null;


        WritableWorkbook workbook = Workbook.createWorkbook([color=darkred]res.getOutputStream()[/color]);
        WritableSheet sheet = workbook.createSheet("Contact Records", 0);
        WritableFont boldFont = new WritableFont(WritableFont.TAHOMA, 10,
                WritableFont.BOLD);
        sheet.addCell(new Label(0, 0, "Trace ID", new WritableCellFormat(
                boldFont)));
        sheet.addCell(new Label(1, 0, "Host Name", new WritableCellFormat(
                boldFont)));
        sheet.addCell(new Label(2, 0, "Trace Details", new WritableCellFormat(
                boldFont)));
        sheet.addCell(new Label(3, 0, "Create Date", new WritableCellFormat(
                boldFont)));
       int rowCnt = 1;
        WritableCellFormat wrapText = new WritableCellFormat();
        wrapText.setWrap(true);
         if (outList != null && outList.size() > 0) {
        	 for(int i=0; i<outList.size(); i++){
        		 TraceVO tc = (TraceVO) outList.get(i);
        		 
        		 sheet.addCell(new Label(0, rowCnt, getTraceID(), wrapText));
        		 sheet.addCell(new Label(1, rowCnt, getHostName()));
        		 sheet.addCell(new Label(2, rowCnt, getTraceLine()));
        		 sheet.addCell(new Label(3, rowCnt, getCreateDate));

                 rowCnt++;
        	 }
        	  
        }
        workbook.write();
        workbook.close();
        if(out !=null){
        	out.close();
        }

			res.setContentType(contentType);

		

>

[Ulf Dittmer]

If this is part of a JSP, then you need to convert that into a servlet; JSPs can't stream binary content (like XLS files). The "Simple Stream" example in http://faq.javaranch.com/java/CodeBarnServlets shows how to stream binary content from a servlet to the browser.