Forum:

Getting Error While Exporting Excel

Arunkumar Chinnadurai

Ranch Hand

Posts: 56

I like...

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi,

As a developer i got another chance to learn something from following error

i have called the exporting to excel from my servlet code... i got this following error

i think this error for more then once if i call response.getOutputStream();

Plase any one can help me...

Regards,
Arunkumar C

Bear Bibeault

Sheriff

Posts: 67754

173

I like...

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Where's your code? Please be sure to UseCodeTags when posting the code.

And surely you are using a servlet for this, and not a JSP? :shock:

[Asking smart questions] [About Bear] [Books by Bear]

HTML 5 (verified skill)
Skill verified by Jeanne Boyarsky

CSS 3 (verified skill)
Skill verified by Jeanne Boyarsky

JavaScript (verified skill)
Skill verified by Jeanne Boyarsky

Arunkumar Chinnadurai

Ranch Hand

Posts: 56

I like...

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi Friends...

I got the answer.....

Actually i have called two times in writer option

one is PrintWriter
Secound one is getOutputStream..

so now i get clear....

Report.jsp

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<%@page import="java.util.ResourceBundle"%>
<%@page import="java.util.Enumeration"%>
<%@page import="java.io.FileInputStream"%>
<%@page import="com.tekno.db.DBConnection"%>
<%@page import="com.tekno.utility.LeaveDetailReportUtility"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.util.ArrayList"%>
<%@page import="java.util.Iterator"%>
<%@page import="com.tekno.model.WorkingDays"%><html>
	<head>
	<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
	<meta http-equiv="content-type" content="text/html; charset=utf-8" />	
	<link rel="stylesheet" type="text/css" href="css/style_reports.css" />
	<link rel="stylesheet" type="text/css" href="css/jquery.autocomplete.css" />
	<title>Admin Proces - www.teknoturf.com</title>
	
	<script src="js/script.js"></script>
	<script src="js/CalendarControl.js" language="javascript"></script>
	<script src="js/jquery-1.3.2-vsdoc2.js" language="javascript"></script>
	<script src="js/jquery.autocomplete.js"></script>  
	<style>
		input {
			font-size: 120%;
		}
		
	</style>
</head>

<ul id="css3menu1" class="topmenu">
		<li class="topfirst"><a href="#" style="height:18px;line-height:18px;"><span>AdminProcess</span></a>
			<ul>
				
				 <li><a href="#">Leave Details</a></li>
			</ul></li>
		<li class="topmenu"><a href="#" style="height:18px;line-height:18px;"><span>Reports</span></a>		
			<ul>
				<li><a href="LeaveDetailsYearlyReport.jsp">Yearly Report</a></li>
				<li><a href="LeaveDetailsMonthlyReport.jsp">Monthly Report</a></li>
				<li><a href="TimeSheetReport.jsp">Time Sheet Report</a></li>
			</ul>
		</li>		
		<li class="topmenu"><a href="#" style="height:18px;line-height:18px;width:750px"></a> </li>
		<li class="toplast"><a href="leavedetailshome.jsp" style="height:18px;line-height:18px;">Home</a></li>
	</ul>
	
    <form name="frmLeaveDetailsHome" action="LeaveDetailsReportController" method="get">
    
    		<%
    			LeaveDetailReportUtility ru=new LeaveDetailReportUtility();
    			ResourceBundle rb=ResourceBundle.getBundle("resource.LeaveDetailsYearlyReport_Property");   			
    			
    			String str=request.getParameter("Year");
    			int year=0;
    			if(str!=null)
    			{
    					year=Integer.parseInt(str);    					
    			}
    			
	   		%>
	   		
	    	<table border="2" align="center" id="tabLeaveDetailsYearlyReport">	    		
	    		<caption><font face="verdana" color="yellow" size="4"><%=rb.getString("ReportHeading") %></font></caption>	    		
	    		<tr>   			
	    			<td rowspan="2">
	    				<%=rb.getString("FirstRowField1") %>
	    				<select name="selYear" onchange="call_LeaveDetailsYearlyReport(this.value);">
	    					<%
	    					if(year!=0)
	    					{	    						
	    					%>
	    					<option value="<%=year %>" selected="selected"><%=year %></option>
	    					<%
	    					}
	    					else
	    					{
	    					%>
	    					<option value="YYYY" selected="selected">YYYY</option>
	    					<%
	    					}
	    					%>
	    					<%
	    						int[] intYear=ru.getLeaveDetailYears();
	    						for(int j=0;j<intYear.length;j++)
	    						{	    							
	    					%>
	    						<option value="<%=intYear[j] %>"><%=intYear[j] %></option>
	    					<%
	    						}
	    					%>
	    				</select>
	    			</td>
	    			<td rowspan="2"><%=rb.getString("FirstRowField2") %></td>
	    			<td rowspan="2"><%=rb.getString("FirstRowField3") %></td>
	    			<td colspan="12"><%=rb.getString("FirstRowField4") %></td>    			
	    		</tr>
	    		
	    		<tr>		    			
	    			<td><%=rb.getString("Mon1") %></td>
	    			<td><%=rb.getString("Mon2") %></td>
	    			<td><%=rb.getString("Mon3") %></td>
	    			<td><%=rb.getString("Mon4") %></td>
	    			<td><%=rb.getString("Mon5") %></td>
	    			<td><%=rb.getString("Mon6") %></td>
	    			<td><%=rb.getString("Mon7") %></td>
	    			<td><%=rb.getString("Mon8") %></td>
	    			<td><%=rb.getString("Mon9") %></td>
	    			<td><%=rb.getString("Mon10") %></td>
	    			<td><%=rb.getString("Mon11") %></td>
	    			<td><%=rb.getString("Mon12") %></td>    			   			
	    			<td><%=rb.getString("LastColumn") %></td>
	    		</tr>

<%    			
	    			
	    				    			
	    			if(year!=0)
	    			{
		    			ArrayList al=ru.getLeaveDetails_YearlyReport(year);
		    			WorkingDays w=new WorkingDays();
		    			Iterator i=al.iterator();
		    			
		    			while(i.hasNext())
		    			{
		    				w=(WorkingDays)i.next();    				
	    			
	    		%>
	    		
			    		<tr>
			    			<td><%=w.getWorkingYear() %></td>
			    			<td><%=w.getEmpID() %></td>
			    			<td><%=w.getEmpName() %></td>
			    			<td><%=w.getJan() %></td>
			    			<td><%=w.getFeb() %></td>
			    			<td><%=w.getMar() %></td>
			    			<td><%=w.getApr() %></td>
			    			<td><%=w.getMay() %></td>
			    			<td><%=w.getJun() %></td>
			    			<td><%=w.getJul() %></td>
			    			<td><%=w.getAug() %></td>
			    			<td><%=w.getSep() %></td>
			    			<td><%=w.getOct() %></td>
			    			<td><%=w.getNov() %></td>    		
			    			<td><%=w.getDec() %></td>
			    			<td><%=w.getTotalWorkingDays() %></td>
			    		</tr>
			    		<%
			    			}
		    			%>
		    			<tr>			    			
			    			<td colspan="16" align="center"><input type="submit" name="btnLeaveDetailsYearlyReportExport" value="Export"  ></td>
			    		</tr>
		    			<%
		    			HttpSession ses=request.getSession();		    			
		    			ses.setAttribute("rptObject",al);
		    			ses.setAttribute("Year",str);
	    			}
			    %>
			    		
			 </table>

</form>   
</body>
</html>

private static final long serialVersionUID = 1L;
	LeaveDetailsUtility ldu=null;
	HttpSession ses=null;
	
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException 
	{
		ses=request.getSession();
		ldu=new LeaveDetailsUtility();		
		
		if(request.getParameter("btnLeaveDetailsYearlyReportExport")!=null)
		{	
			if(request.getParameter("btnLeaveDetailsYearlyReportExport").equals("Export"))
			{				
				System.out.println("Inside of Export Button.....!!!"+ses.getAttribute("rptObject")+"\t Year : "+ses.getAttribute("Year"));
				ArrayList<WorkingDays> al=(ArrayList<WorkingDays>)ses.getAttribute("rptObject");
				
				WorkingDays w=new WorkingDays();
    			Iterator i=al.iterator();
    		    		    			
                ResourceBundle rb=ResourceBundle.getBundle("resource.LeaveDetailsYearlyReport_Property");               
                
				HSSFWorkbook hwb=new HSSFWorkbook();
				HSSFSheet sheet =  hwb.createSheet("LeaveDetailsYearlyReport");
					
				HSSFRow heading=   sheet.createRow((short)0);
				heading.createCell((short) 0).setCellValue(rb.getString("ReportHeading")+" - "+ses.getAttribute("Year"));
				
				HSSFRow hRow1=   sheet.createRow((short)1);		
				hRow1.createCell((short) 2).setCellValue(rb.getString("FirstRowField4"));
				
				HSSFRow rowhead=   sheet.createRow((short)2);
				rowhead.createCell((short) 0).setCellValue(rb.getString("FirstRowField2"));
				rowhead.createCell((short) 1).setCellValue(rb.getString("FirstRowField3"));				
				rowhead.createCell((short) 2).setCellValue(rb.getString("Mon1"));
				rowhead.createCell((short) 3).setCellValue(rb.getString("Mon2"));
				rowhead.createCell((short) 4).setCellValue(rb.getString("Mon3"));
				rowhead.createCell((short) 5).setCellValue(rb.getString("Mon4"));
				rowhead.createCell((short) 6).setCellValue(rb.getString("Mon5"));
				rowhead.createCell((short) 7).setCellValue(rb.getString("Mon6"));
				rowhead.createCell((short) 8).setCellValue(rb.getString("Mon7"));
				rowhead.createCell((short) 9).setCellValue(rb.getString("Mon8"));
				rowhead.createCell((short) 10).setCellValue(rb.getString("Mon9"));
				rowhead.createCell((short) 11).setCellValue(rb.getString("Mon10"));
				rowhead.createCell((short) 12).setCellValue(rb.getString("Mon11"));
				rowhead.createCell((short) 13).setCellValue(rb.getString("Mon12"));
				rowhead.createCell((short) 14).setCellValue(rb.getString("LastColumn"));
				
					
				int rowCount=3;
				
    			while(i.hasNext())
    			{
    				w=(WorkingDays)i.next(); 
    				HSSFRow row=   sheet.createRow((short)rowCount);    				
    				//row.createCell((short) 0).setCellValue(w.getWorkingYear());
    				row.createCell((short) 0).setCellValue(w.getEmpID());
    				row.createCell((short) 1).setCellValue(w.getEmpName());
    				row.createCell((short) 2).setCellValue(w.getJan());
    				row.createCell((short) 3).setCellValue(w.getFeb());
    				row.createCell((short) 4).setCellValue(w.getMar());
    				row.createCell((short) 5).setCellValue(w.getApr());
    				row.createCell((short) 6).setCellValue(w.getMay());
    				row.createCell((short) 7).setCellValue(w.getJun());
    				row.createCell((short) 8).setCellValue(w.getJul());
    				row.createCell((short) 9).setCellValue(w.getAug());
    				row.createCell((short) 10).setCellValue(w.getSep());
    				row.createCell((short) 11).setCellValue(w.getOct());
    				row.createCell((short) 12).setCellValue(w.getNov());
    				row.createCell((short) 13).setCellValue(w.getDec());
    				row.createCell((short) 14).setCellValue(w.getTotalWorkingDays());
    				rowCount=rowCount+1;
    				System.out.println("Get Values : "+w.getWorkingYear()+"\t Emp Id : "+w.getEmpID()+"\t Row Count : "+rowCount);
    			}

String filename="LeaveDetailsYearlyReport.xls";
    			//callExport(hwb,filename, request, response);
    			
    			try
    			{
    				File f=new File(filename);
    				if(!f.exists())
    				{
    					  f.createNewFile();
    				}
    				FileOutputStream fileOut =  new FileOutputStream(f);
    				hwb.write(fileOut);
    				fileOut.close();	
    		
    				ServletOutputStream op=response.getOutputStream();
    				int length= 0;
    				response.setContentType("application/vnd.ms-excel");
    				response.setHeader("Content-Disposition","attachment;filename=" + filename );
    				byte[] bbuf = new byte[1024];
    			    DataInputStream in = new DataInputStream(new FileInputStream(f));
    			    
    			    while ((in != null) && ((length = in.read(bbuf)) != -1))
    			    {
    			    	op.write(bbuf,0,length);
    			    }
    		        in.close();
    		        op.flush();
    		        op.close();   
    			}catch(Exception ex)
    			{
    				ex.printStackTrace();
    			}    			
			}						
		}
}

Consider Paul's rocket mass heater.