How to Terminate JSP Process
use:
out.close();
use:
out.close();
Saturday, December 21, 2013
How to generate .XLS file in Java using Apache POI
How to generate .XLS file in Java using Apache POI
String contextName = request.getContextPath().
HttpSession hs = request.getSession();
String path = hs.getServletContext().
char pathSep = new File(path).separatorChar;
path = path.substring(0, path.lastIndexOf(pathSep + contextName));
path = path + pathSep;
//String filename =
"c:\\Send\\text.xls";
String filename = path+"text.xls";
HSSFWorkbook hwb = new HSSFWorkbook();
HSSFSheet sheet = hwb.createSheet("new sheet");
int width = 30;
sheet.setAutobreaks(true);
sheet.setDefaultColumnWidth(
HSSFRow rowhead = sheet.createRow((short) 0);
rowhead.createCell((int) 0).setCellValue("SR No.");
rowhead.createCell((int) 1).setCellValue("Name");
rowhead.createCell((int) 2).setCellValue("Code");
rowhead.createCell((int) 3).setCellValue("Salary");
rowhead.createCell((int) 4).setCellValue("City");
rowhead.createCell((int) 5).setCellValue("State");
int i = 0,index=0;
for(i=0;i<6;i++) {
index++;
HSSFRow row =
sheet.createRow((short) index);
row.createCell((int)
0).setCellValue(index);
row.createCell((int)
1).setCellValue("Name -- "+index);
row.createCell((int)
2).setCellValue("12345 -- "+index);
row.createCell((int)
3).setCellValue("4500"+index);
row.createCell((int)
4).setCellValue("City -- "+index);
row.createCell((int)
5).setCellValue("State -- "+index);
}
FileOutputStream fileOut = new FileOutputStream(filename);
hwb.write(fileOut);
fileOut.close();
String disHeader = "Attachment;Filename=\"Report.
response.setHeader("Content-
File desktopFile = new File(filename);
PrintWriter pw = response.getWriter();
FileInputStream fileInputStream = new FileInputStream(desktopFile);
int j;
//pw.flush();
while ((j = fileInputStream.read()) != -1) {
pw.write(j);
}
fileInputStream.close();
response.flushBuffer();
pw.flush();
pw.close();
How to generate .XLSX file in Java using Apache POI
How to generate .XLSX file in Java using Apache POI
First you need to download from
apache site:
Extract zip file and copy listed below file in you Libraries folder
under NetBeans.
1)
poi-3.9-20121203.jar
2)
poi-examples-3.9-20121203.jar
3)
poi-excelant-3.9-20121203.jar
4)
poi-ooxml-3.9-20121203.jar
5)
poi-ooxml-schemas-3.9-
6)
poi-scratchpad-3.9-20121203.
7)
xmlbeans-2.3.0.jar
8)
dom4j-1.6.1.jar
Create “excel.jsp” as listed
below file:
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta
http-equiv="Content-Type" content="text/html;
charset=UTF-8">
<title>Excel
Page</title>
</head>
<body>
<h1>Excel!</h1>
<form
name="excelform" id="excelform" action="/MyTest/TestExcel" method="post">
<input
type="submit" value="submit"/>
</form>
</body>
</html>
Create a servlet “TestExcel.java”
as listed below file:
import java.io.*;
import javax.servlet.
import javax.servlet.http.
import javax.servlet.http.
import javax.servlet.http.
import javax.servlet.http.
import org.apache.poi.xssf.usermodel.
import org.apache.poi.xssf.usermodel.
import org.apache.poi.xssf.usermodel.
import org.apache.poi.xssf.usermodel.
public class TestExcel extends HttpServlet {
//Processes requests for both
HTTP
protected void
processRequest(
throws
ServletException, IOException {
PrintWriter out =
response.getWriter();
String contextName =
request.getContextPath().
HttpSession hs =
request.getSession();
String path =
hs.getServletContext().
char pathSep = new File(path).separatorChar;
path = path.substring(0,
path.lastIndexOf(pathSep + contextName));
path = path + pathSep;
//String filename =
"c:\\Send\\text.xlsx";
String filename =
path+"text.xlsx";
String sheetName =
"Sheet1";
XSSFWorkbook wb= new
XSSFWorkbook();
XSSFSheet sheet =
wb.createSheet(sheetName) ;
int width = 30;
sheet.setAutobreaks(true);
sheet.setDefaultColumnWidth(
XSSFRow rowHead =
sheet.createRow((short) 0);
rowHead.createCell((int)
0).setCellValue("SR No.");
rowHead.createCell((int)
1).setCellValue("Name");
rowHead.createCell((int)
2).setCellValue("Code");
rowHead.createCell((int)
3).setCellValue("Salary");
rowHead.createCell((int)
4).setCellValue("City");
rowHead.createCell((int)
5).setCellValue("State");
int i = 0,index=0;
for(i=0;i<6;i++) {
index++;
XSSFRow row =
sheet.createRow((short) index);
row.createCell((int)
0).setCellValue(index);
row.createCell((int)
1).setCellValue("Name -- "+index);
row.createCell((int)
2).setCellValue("12345 -- "+index);
row.createCell((int)
3).setCellValue("4500"+index);
row.createCell((int)
4).setCellValue("City -- "+index);
row.createCell((int)
5).setCellValue("State -- "+index);
}
FileOutputStream fileOut
= new FileOutputStream(filename);
wb.write(fileOut);
fileOut.close();
String disHeader =
"Attachment;Filename=\"Report.
response.setHeader("Content-
File desktopFile = new
File(filename);
PrintWriter pw = response.getWriter();
FileInputStream
fileInputStream = new FileInputStream(desktopFile);
int j;
//pw.flush();
while ((j =
fileInputStream.read()) != -1) {
pw.write(j);
}
fileInputStream.close();
response.flushBuffer();
pw.flush();
pw.close();
}
@Override
protected void
doGet(HttpServletRequest request, HttpServletResponse response)
throws
ServletException, IOException {
processRequest(request,
response);
}
@Override
protected void
doPost(HttpServletRequest request, HttpServletResponse response)
throws
ServletException, IOException {
processRequest(request,
response);
}
@Override
public String
getServletInfo() {
return "Short
description";
}
}
Html to pdf in java struts.
Html to pdf in java struts.
import com.lowagie.text.Document;
import com.lowagie.text.Element;
import com.lowagie.text.PageSize;
import com.lowagie.text.html.
import com.lowagie.text.html.
import com.lowagie.text.pdf.
import com.lowagie.text.pdf.codec.
import java.util.ArrayList;
import java.io.*;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import javax.servlet.http.
import javax.servlet.http.
import javax.servlet.http.
import java.sql.*;
import java.text.SimpleDateFormat;
import java.util.*;
import javax.servlet.http.
import org.apache.struts.action.
import org.apache.struts.action.
import org.apache.struts.action.
import org.apache.struts.validator.
import org.hibernate.
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;
import plugins.
String contextName = request.getContextPath().
HttpSession hs = request.getSession();
String path = hs.getServletContext().
char pathSep = new File(path).separatorChar;
path = path.substring(0, path.lastIndexOf(pathSep + contextName));
path = path + pathSep + "MyForms";
Document pdfDoc = new Document(PageSize.A4, 50, 50, 1, 50);
Reader htmlReader = new BufferedReader(new InputStreamReader(new FileInputStream(path+"\\
ByteArrayOutputStream byteAOS = new ByteArrayOutputStream();
PdfWriter.getInstance(pdfDoc, byteAOS);
pdfDoc.open();
StyleSheet stylez = new StyleSheet();
stylez.loadTagStyle("body", "font", "Tahoma");
ArrayList arrayElementList = HTMLWorker.parseToList(
for (int i = 0; i < arrayElementList.size(); ++i) {
Element e = (Element) arrayElementList.get(i);
pdfDoc.add(e);
}
pdfDoc.close();
DateFormat dff = new SimpleDateFormat("dd_MMMM_
DateFormat tf = new SimpleDateFormat("hhmmss");
String dateString = dff.format(new java.util.Date());
String timeString = tf.format(new java.util.Date());
String pdfStoredFileName = "\\newRegistrn_" + dateString + timeString + "__" + ".pdf";
byte[] byt = byteAOS.toByteArray();
String pdfBase64 = Base64.encodeBytes(byt);
File pdfFile = new File(path+pdfStoredFileName);
FileOutputStream out = new FileOutputStream(pdfFile);
out.write(byt);
out.close();
htmlReader.close();
String fileToDownload =pdfStoredFileName;
String disHeader = "Attachment;Filename=" + fileToDownload;
response.setHeader("Content-
File desktopFile = new File(path+pdfStoredFileName);
PrintWriter pw = response.getWriter();
FileInputStream fileInputStream = new FileInputStream(desktopFile);
int j;
pw.flush();
while ((j = fileInputStream.read()) != -1) {
pw.write(j);
}
fileInputStream.close();
response.flushBuffer();
pw.flush();
pw.close();
File fileToDel = new File(path+pdfStoredFileName);
if(fileToDel.delete()){
System.out.println("\n "+fileToDel.getName() + " is deleted!");
} else {
System.out.println("\n Delete operation is failed.");
}
import com.lowagie.text.Document;
import com.lowagie.text.Element;
import com.lowagie.text.PageSize;
import com.lowagie.text.html.
import com.lowagie.text.html.
import com.lowagie.text.pdf.
import com.lowagie.text.pdf.codec.
import java.util.ArrayList;
import java.io.*;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import javax.servlet.http.
import javax.servlet.http.
import javax.servlet.http.
import java.sql.*;
import java.text.SimpleDateFormat;
import java.util.*;
import javax.servlet.http.
import org.apache.struts.action.
import org.apache.struts.action.
import org.apache.struts.action.
import org.apache.struts.validator.
import org.hibernate.
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;
import plugins.
String contextName = request.getContextPath().
HttpSession hs = request.getSession();
String path = hs.getServletContext().
char pathSep = new File(path).separatorChar;
path = path.substring(0, path.lastIndexOf(pathSep + contextName));
path = path + pathSep + "MyForms";
Document pdfDoc = new Document(PageSize.A4, 50, 50, 1, 50);
Reader htmlReader = new BufferedReader(new InputStreamReader(new FileInputStream(path+"\\
ByteArrayOutputStream byteAOS = new ByteArrayOutputStream();
PdfWriter.getInstance(pdfDoc, byteAOS);
pdfDoc.open();
StyleSheet stylez = new StyleSheet();
stylez.loadTagStyle("body", "font", "Tahoma");
ArrayList arrayElementList = HTMLWorker.parseToList(
for (int i = 0; i < arrayElementList.size(); ++i) {
Element e = (Element) arrayElementList.get(i);
pdfDoc.add(e);
}
pdfDoc.close();
DateFormat dff = new SimpleDateFormat("dd_MMMM_
DateFormat tf = new SimpleDateFormat("hhmmss");
String dateString = dff.format(new java.util.Date());
String timeString = tf.format(new java.util.Date());
String pdfStoredFileName = "\\newRegistrn_" + dateString + timeString + "__" + ".pdf";
byte[] byt = byteAOS.toByteArray();
String pdfBase64 = Base64.encodeBytes(byt);
File pdfFile = new File(path+pdfStoredFileName);
FileOutputStream out = new FileOutputStream(pdfFile);
out.write(byt);
out.close();
htmlReader.close();
String fileToDownload =pdfStoredFileName;
String disHeader = "Attachment;Filename=" + fileToDownload;
response.setHeader("Content-
File desktopFile = new File(path+pdfStoredFileName);
PrintWriter pw = response.getWriter();
FileInputStream fileInputStream = new FileInputStream(desktopFile);
int j;
pw.flush();
while ((j = fileInputStream.read()) != -1) {
pw.write(j);
}
fileInputStream.close();
response.flushBuffer();
pw.flush();
pw.close();
File fileToDel = new File(path+pdfStoredFileName);
if(fileToDel.delete()){
System.out.println("\n "+fileToDel.getName() + " is deleted!");
} else {
System.out.println("\n Delete operation is failed.");
}
Featured Post
Core Web Vitals Assessment showing LCP 10.6s while google pagespeed report showing LCP 3.5s why?
Core Web Vitals Assessment showing LCP 10.6s while google pagespeed report showing LCP 3.5s why? So, you can face this situation while...
Posts
