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.");
}
How to make center align child div
How to make center align child div? Suppose you have 2 Div tag. And want the make inner tag center <div id="d1"> ...
Posts
