opening the excel sheet from servlet

[Moieen Khatri]

Hi,

I have created a report on my local.I am trying to open this xls file inside my servlet:

String filepath = "d:\\excel\\dbreport.xls";
FileOutputStream  fileOut = new FileOutputStream(filepath);
wb.write(fileOut);
res.reset();
res.setContentType ("application/xls");
//set the header and also the Name by which user will be prompted to save
res.addHeader ("Content-Disposition", "attachment;filename="+filepath+";"); 

This opens the file without some unknown name.

What am I doing wrong here?

Thanks

[Sumit Patil]

The unknown name you are getting must be related to the URL pattern you are using for your servlet.
Use Java to break the filepath to get the file name and then pass the file name to setHeader method.

[Moieen Khatri]

Thanks for the reply. I can now open the file with the name that I pass.However the file is empty.It does not have the data which the file created at the local drive has.Am I missing something?

The code is pasted below:
String filePath ="d:\\excel\\dbreport.xls";

res.setContentType("application/vnd.ms-excel");
PrintWriter output = res.getWriter();

res.setHeader("Content-Disposition", "attachment; filename=\"dbreport.xls\" ");

FileOutputStream fileOut = new FileOutputStream(filePath);
wb.write(fileOut);
fileOut.close();
output.close();

The file in the d drive location shows the correct data whereas the open which opens is empty.

Please advice

Thanks

[Sumit Patil]

Moieen Khatri wrote:


String filePath ="d:\\excel\\dbreport.xls";

res.setContentType("application/vnd.ms-excel");
PrintWriter output = res.getWriter();

res.setHeader("Content-Disposition", "attachment; filename=\"dbreport.xls\" ");

FileOutputStream fileOut = new FileOutputStream(filePath);
wb.write(fileOut);
fileOut.close();
output.close();

Please tell what is "wb"?

[Moieen Khatri]

Hi Sumit,

wb is the the workbook object.Code is pasted below:

HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet("new sheet");
HSSFRow headerLine = sheet.createRow((short) 0);
HSSFCell cell = headerLine.createCell((short) 0);
cell.setCellValue("cabinet name");
cell = headerLine.createCell((short) 1);
cell.setCellValue("date of saving");
cell = headerLine.createCell((short) 2);
cell.setCellValue("number of files");
cell = headerLine.createCell((short) 3);
cell.setCellValue("size(mb)");
System.out.println(omc.infoVec1.size());
for(int j=omc.infoVec1.size()-2;j<omc.infoVec1.size();j++)
 {
Vector infoVec = (Vector) omc.infoVec1.elementAt(j);
HSSFRow row = sheet.createRow((short) 1+j);
HSSFCell cellValue = row.createCell((short) 0);
cellValue.setCellValue(dmmc.cabinet);
for(int k =0; k ><3;k++){
 cellValue = row.createCell((short) ((short) k+1));
cellValue.setCellValue(infoVec.get(k).toString());
		}
}

Thanks

[David Newton]

I'm confused: are you trying to write a file to the browser? You neither read a file nor write to the browser.

[Moieen Khatri]

I am trying to write the contents of the workbook object to the xls file and trying to open the file:

HSSFWorkbook wb = new HSSFWorkbook();
						HSSFSheet sheet = wb.createSheet("new sheet");
						HSSFRow headerLine = sheet.createRow((short) 0);
						
						HSSFCell cell = headerLine.createCell((short) 0);
						cell.setCellValue("cabinet name");
						cell = headerLine.createCell((short) 1);
						cell.setCellValue("date of saving");
						cell = headerLine.createCell((short) 2);
						cell.setCellValue("number of files");
						cell = headerLine.createCell((short) 3);
						cell.setCellValue("size(mb)");
						System.out.println(omc.infoVec1.size());
						
						
						for(int j=omc.infoVec1.size()-2;j<omc.infoVec1.size();j++)
						 {
							
							Vector infoVec = (Vector) omc.infoVec1.elementAt(j);
						HSSFRow row = sheet.createRow((short) 1+j);
						HSSFCell cellValue = row.createCell((short) 0);
						cellValue.setCellValue(dmmc.cabinet);
						
						for(int k =0; k ><3;k++){
						 cellValue = row.createCell((short) ((short) k+1));
						cellValue.setCellValue(infoVec.get(k).toString());
						 
						 
						
						}
						
						}
						

						String filePath ="d:\\excel\\dbreport.xls";
						
						
						res.setContentType("application/vnd.ms-excel");
						PrintWriter output = res.getWriter();
		
						res.setHeader("Content-Disposition", "attachment; filename=\"dbreport.xls\" ");   
						
						FileOutputStream fileOut = new FileOutputStream(filePath);
						wb.write(fileOut);
						fileOut.close(); 
						output.close();

Thanks

[David Newton]

Again--you never open a file for reading.

If wb.write(fileOut) writes the XLS file you still need to *open it* if you want to return the data to the browser. Or perhaps you could wb.write(...) directly to the response--depends on what you're doing.

But you never open a file for reading here, nor do you send anything to the browser.

[Moieen Khatri]

Thanks for the help! I resolved this issue!

[prriya pratheep]

Hi, I am facing the same problem. Opening a empty file .Please anybody help me to open it as mentioned by Moieen Khatri.Below is my code

 response.reset();
				response.setBufferSize(DEFAULT_BUFFER_SIZE);
				response.setHeader("Content-Type", "application/vnd.ms-excel");
				
				response.setHeader("Content-Disposition", "[b]attachment[/b]; filename="+f1.getName());
				
				response.setHeader("Content-Length", String.valueOf(f1.length()));
			//	response.setHeader("Content-Disposition", "attachment; filename=\"" + f1.getName() + "\"");
				BufferedInputStream input = null;
				BufferedOutputStream output = null;
				HSSFWorkbook wb = new HSSFWorkbook();
				HSSFSheet sheet = wb.createSheet("new sheet");

			

				FileOutputStream fileOut = new FileOutputStream(f1);
				wb.write(fileOut);
				fileOut.close();

Thanks and Regards

[Rob Spoor]

Are you writing anything to the servlet's output stream?

[Ram Narayan.M]

As Rob asked, to get the excel content sent by Servlet, it should be written to Servlet OutputStream, then only it reaches the client(browser) to open the excel file.