当前位置：文档之家› JAVA导出WORD与EXCEL

JAVA导出WORD与EXCEL

package ais.mytest.web;

/**

* 功能：主要实现数据导出Excel和Word功能* 日期：2008-2-28

import ais.basic.service.BasicUtil;

import https://www.doczj.com/doc/3f10765632.html,mons.file.service.FileService; import ais.framework.web.BaseAction;

import ais.mytest.model.Employeer;

import ais.mytest.service.IemployeerService;

import java.io.File;

import java.io.FileInputStream;

import java.io.FileOutputStream;

import java.text.DecimalFormat;

import jxl.write.NumberFormat;

import java.util.List;

import javax.servlet.ServletOutputStream; import jxl.Cell;

import jxl.Workbook;

import jxl.format.Alignment;

import jxl.format.UnderlineStyle;

import jxl.format.VerticalAlignment;

import jxl.format.Border;

import jxl.format.BorderLineStyle;

import jxl.format.BoldStyle;

import jxl.format.Colour;

import jxl.write.Blank;

import jxl.write.DateFormat;

import jxl.write.DateTime;

import https://www.doczj.com/doc/3f10765632.html,bel;

import jxl.write.WritableCellFormat;

import jxl.write.WritableFont;

import jxl.write.WritableImage;

import jxl.write.WritableSheet;

import jxl.write.WritableWorkbook;

//import com.ibm.icu.text.SimpleDateFormat;

//import com.lowagie.text.Cell;

import com.lowagie.text.Document;

import com.lowagie.text.Font;

import com.lowagie.text.Image;

import com.lowagie.text.PageSize;

import com.lowagie.text.Paragraph;

import com.lowagie.text.Table;

import com.lowagie.text.pdf.BaseFont;

import com.lowagie.text.rtf.RtfWriter2;

import java.awt.Color;

import java.io.InputStream;

import java.io.OutputStream;

import org.apache.struts2.ServletActionContext;

public class ExportAction extends BaseAction{

/**

private static final long serialVersionUID = -3951404867065653031L;

FileService fileService;

BasicUtil basicUtil;

IemployeerService iemployeerService;

Employeer employeer;

String filename=System.currentTimeMillis()+".doc";

public ExportAction() {}

/**

* 功能:将数据库中的数据导出word

* 日期:2008-2-29

* @return

// 复制一份新的RTF文件

public String getNewFilePath() throws Exception {

InputStream ins = ServletActionContext.getServletContext().getResourceAsStream("/empty.doc");

byte[] b = new byte[ins.available()];

ins.read(b);

ins.close();

String newFileName = ServletActionContext.getServletContext().getRealPath("")+ "/"+filename;

OutputStream ous = new FileOutputStream(newFileName);

ous.write(b);

ous.close();

return newFileName;

}

// 将二进制流写到客户端

public void writeNewFile(String newFilePath, String downloadFileName)

throws Exception {

File f = new File(newFilePath);

InputStream ins = new FileInputStream(f);

byte[] b = new byte[ins.available()];

ins.read(b);

ins.close();

/**

* 出现保存与打开对话框application/octet-stream,加上下面第二句是保存时能正确出现文件类型

//getResponse().setContentType("application/octet-stream");

//getResponse().setHeader("Content-Disposition","attachment;filename=\""+ new String((downloadFileName).getBytes(),"ISO-8859-1") + "\";");

/**

* 直接打开word文档

getResponse().setContentType("application/msword");

ServletActionContext.getResponse().getOutputStream().write(b);

//文件删除

if (f != null) {

f.delete();

}

/**

* @param em_name 姓名

* @param em_sex 性别

* @param em_age 年龄

* @param em_duty 职务

* @param em_pay 工资

* @param em_polity 政治面貌

* @param em_address 住址

public void createWord(String eMname,String eMsex,int eMage,String eMduty, Double eMpay, String eMpolity,String eMaddress) throws Exception {

// 创建word文档

Document document = new Document(PageSize.A4);

// 输入word文档

String newFilePath = getNewFilePath();

RtfWriter2.getInstance(document, new FileOutputStream(newFilePath));

document.open();

// 中文字体

BaseFont bfChinese = BaseFont.createFont("STSongStd-Light","UniGB-UCS2-H", BaseFont.NOT_EMBEDDED);

Font fontChinese = new Font(bfChinese, 12, Font.BOLD);

Table table = new Table(4, 4);

Paragraph paragraph = new Paragraph("XX单位员工信息表", fontChinese);

paragraph.setAlignment(Paragraph.ALIGN_CENTER);

document.add(paragraph);

table.setBorderWidth(2);

table.setBorderColor(new Color(0, 0, 0));

table.setPadding(5);

table.setSpacing(0);

table.setAutoFillEmptyCells(true);

com.lowagie.text.Cell cell = new com.lowagie.text.Cell(new Paragraph("姓名", fontChinese));

table.addCell(cell);

cell = new com.lowagie.text.Cell(eMname);

table.addCell(cell);

cell = new com.lowagie.text.Cell(new Paragraph("性别", fontChinese));

table.addCell(cell);

cell = new com.lowagie.text.Cell(eMsex);

table.addCell(cell);

cell = new com.lowagie.text.Cell(new Paragraph("年龄", fontChinese));

table.addCell(cell);

cell = new com.lowagie.text.Cell(Integer.valueOf(eMage).toString());

table.addCell(cell);

cell = new com.lowagie.text.Cell(new Paragraph("政治面貌", fontChinese));

table.addCell(cell);

cell = new com.lowagie.text.Cell(eMpolity);

table.addCell(cell);

cell = new com.lowagie.text.Cell(new Paragraph("职务", fontChinese));

table.addCell(cell);

cell = new com.lowagie.text.Cell(eMduty);

table.addCell(cell);

cell = new com.lowagie.text.Cell(new Paragraph("工资", fontChinese));

table.addCell(cell);

cell = new com.lowagie.text.Cell(Double.valueOf(eMpay).toString());

//cell.setColspan(5);

table.addCell(cell);

cell = new com.lowagie.text.Cell(new Paragraph("住址", fontChinese));

table.addCell(cell);

cell = new com.lowagie.text.Cell(eMaddress);

cell.setColspan(3);

table.addCell(cell);

cell = new com.lowagie.text.Cell(new Paragraph("\n\n\n教育背景:\n\n\n", fontChinese));