Writing xlsx document to servlet response

[renisha suny]

I have the following servlet code which sends request to generate excel file in xlsx format:

urlParameters = "operation=getReports®ionName="
					+ regionName;
			System.getProperties().setProperty("http.keepAlive", "true");
			connection = HTTPUtils.getConnection(PropertyFile.host);
			OutputStreamWriter wr = new OutputStreamWriter(connection
					.getOutputStream());
			wr.write(urlParameters);
			wr.flush();
			wr.close();
			
					
			response.reset();
			response.setStatus(HttpServletResponse.SC_OK);
			response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
			response.setHeader("Content-Transfer-Encoding", "7bit");
			response.setHeader("Content-Disposition","inline; filename=test.xlsx");

And in the middleware server

the final code which generates the excel doc in zip format is :

public void flushDataIntoWorkbook(OutputStream responseBody) throws ZipException, IOException {

		ZipFile zip = new ZipFile(new File("template.xlsx"));
		ZipOutputStream zos = new ZipOutputStream(responseBody);

		@SuppressWarnings("unchecked")
		Enumeration en = (Enumeration) zip.entries();
		while (en.hasMoreElements()) {
			ZipEntry ze = (ZipEntry) en.nextElement();
			Iterator sheetIter = this.sheetData.keySet().iterator();
			boolean entryMatches = false;
			while (sheetIter.hasNext()) {
				String entry = (String) sheetIter.next();
				entryMatches = ze.getName().equals(entry);
				if (entryMatches == true)
					break;
			}
			if (!entryMatches) {
				zos.putNextEntry(new ZipEntry(ze.getName()));
				InputStream is = zip.getInputStream(ze);
				copyStream(is, zos);
				is.close();
			}
		}

		// add all sheets
		Iterator sheetIter = this.sheetData.keySet().iterator();
		// InputStream is = null;
		while (sheetIter.hasNext()) {
			String key = (String) sheetIter.next();
			logger.info("Writing sheet: " + key);
			zos.putNextEntry(new ZipEntry(key));
			System.out.println("this.sheetData.get(key)"+this.sheetData.get(key));
			InputStream is = new FileInputStream((File)this.sheetData
					.get(key));
			copyStream(is, zos);
			is.close();
			zos.closeEntry();
		}
		zos.close();
			
	}

But I am not able to retrieve the excel in the frontend .
Could anyone please point out if I am missing some thing here ?

[Ulf Dittmer]

That code looks nasty. Are you trying to recreate the file format by zipping a collection of XML files? Why? Why not use Apache POI?

[renisha suny]

Please find attached the full source code where I am generating the Excel document

[renisha suny]

The following is the code snippet from where I iniitiate the request

ExcelWorkBookWriter ew = new ExcelWorkBookWriter();
LinkedHashMap sheets = new LinkedHashMap();
sheets.put("sheet1", null);
sheets.put("sheet2", null);
sheets.put("sheet3", null);
sheets.put("sheet4", null);
sheets.put("sheet5",null);
try {
ew.init("myxls.xlsx", sheets, null);
} catch (Exception e) {
logger.error("Exception handler " + e.getMessage(), e);
}
ew.importViewData(results);
ew.flushDataIntoWorkbook(exchange.getResponseBody());

[Greg Charles]

Welcome to JavaRanch! I added some code tags to your post, which make it easier to read. What happens at the front end now? I'm confused by your mixing of Excel and zip files. Also, you set your content type to something that looks like it should be Excel, but then write a zip file?

My advice is to start small and build up. Can you write a working Excel file locally? Maybe start with just one sheet and not zipped. Can you use a servlet to download a simple text file? Once you get the pieces working, you can tie them all together.

[Ulf Dittmer]

renisha suny wrote:ExcelWorkBookWriter

What is that? Are you sure you're using it right?