generateexceldoc.java

人力资源管理系统

package org.HumResManSys.util; 

import java.awt.FileDialog;
import java.awt.Frame;
import java.io.File;
import java.io.FileOutputStream;
import java.io.FilterOutputStream;
import java.io.OutputStream;
import java.util.List;

import org.HumResManSys.service.impl.JxdServiceImpl;
import org.HumResManSys.vo.Salary_info;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

public class GenerateExcelDoc extends Frame{ 
	private Log log=LogFactory.getLog(JxdServiceImpl.class);
	
	public boolean generateAllEmployeesSalaryExcel(List<Salary_info> list,String outputfile){
		log.info("generating excel");
	  try{ 
	   HSSFWorkbook workbook = new HSSFWorkbook(); 
	   HSSFSheet sheet = workbook.createSheet("Salary");  

	   HSSFRow row = sheet.createRow((short)0); 
	   HSSFCell cell0 = row.createCell((short)0);
	   cell0.setEncoding(HSSFCell.ENCODING_UTF_16);
	   cell0.setCellType(HSSFCell.CELL_TYPE_STRING);
	   cell0.setCellValue("姓名");
	   HSSFCell cell1 = row.createCell((short)1);
	   cell1.setEncoding(HSSFCell.ENCODING_UTF_16);
	   cell1.setCellType(HSSFCell.CELL_TYPE_STRING);
	   cell1.setCellValue("时间");
	   HSSFCell cell2 = row.createCell((short)2);
	   cell2.setEncoding(HSSFCell.ENCODING_UTF_16);
	   cell2.setCellType(HSSFCell.CELL_TYPE_STRING);
	   cell2.setCellValue("基本工资");
	   HSSFCell cell3 = row.createCell((short)3);
	   cell3.setEncoding(HSSFCell.ENCODING_UTF_16);
	   cell3.setCellType(HSSFCell.CELL_TYPE_STRING);
	   cell3.setCellValue("津贴");
	   HSSFCell cell4 = row.createCell((short)4);
	   cell4.setEncoding(HSSFCell.ENCODING_UTF_16);
	   cell4.setCellType(HSSFCell.CELL_TYPE_STRING);
	   cell4.setCellValue("奖金");
	   HSSFCell cell5 = row.createCell((short)5);
	   cell5.setEncoding(HSSFCell.ENCODING_UTF_16);
	   cell5.setCellType(HSSFCell.CELL_TYPE_STRING);
	   cell5.setCellValue("税率");
	   HSSFCell cell6 = row.createCell((short)6);
	   cell6.setEncoding(HSSFCell.ENCODING_UTF_16);
	   cell6.setCellType(HSSFCell.CELL_TYPE_STRING);
	   cell6.setCellValue("总工资");

	   for(int j=0;j<list.size();j++){
		   HSSFRow rowItem = sheet.createRow((short)j+1);
		   //姓名
		   cell0 = rowItem.createCell((short)0);
		   cell0.setEncoding(HSSFCell.ENCODING_UTF_16);
		   cell0.setCellType(HSSFCell.CELL_TYPE_STRING);
		   cell0.setCellValue(list.get(j).getEmp_name());
		   //时间
		   cell1 = rowItem.createCell((short)1);
		   cell1.setEncoding(HSSFCell.ENCODING_UTF_16);
		   cell1.setCellType(HSSFCell.CELL_TYPE_STRING);
		   cell1.setCellValue(list.get(j).getMonth());
		   //进本工资
		   cell2 = rowItem.createCell((short)2);
		   cell2.setCellType(HSSFCell.CELL_TYPE_STRING);
		   cell2.setCellValue(list.get(j).getBasic_sal());
		   //津贴
		   cell3 = rowItem.createCell((short)3);
		   cell3.setCellType(HSSFCell.CELL_TYPE_STRING);
		   cell3.setCellValue(list.get(j).getJintie());
		   //奖金
		   cell4 = rowItem.createCell((short)4);
		   cell4.setCellType(HSSFCell.CELL_TYPE_STRING);
		   cell4.setCellValue(list.get(j).getBonus());
		   //税率
		   cell5 = rowItem.createCell((short)5);
		   cell5.setCellType(HSSFCell.CELL_TYPE_STRING);
		   cell5.setCellValue(list.get(j).getTax_rate());
		   //总工资
		   cell6 = rowItem.createCell((short)6);
		   cell6.setCellType(HSSFCell.CELL_TYPE_STRING);
		   cell6.setCellValue(list.get(j).getSum_sal());
	   }
	   try{
	   FileDialog sv;
       sv=new FileDialog(this,"save",FileDialog.SAVE);
       sv.setVisible(true);
       sv.setLocation(800, 1000);
       File fl=new File(sv.getDirectory(),sv.getFile());
       outputfile=String.valueOf(sv.getDirectory());
	   System.out.println(outputfile);
	   OutputStream os=new FileOutputStream(outputfile+"salary.xls");
	   FilterOutputStream fout = new FilterOutputStream(os); 
	   workbook.write(fout); 
	   fout.flush();  
	   fout.close(); 
	   System.out.println("文件生成..."); 
	   
	  }catch(Exception e) { 
         e.printStackTrace(); 
         log.error("generate excel error");
         return false;
	  } 
	  
	}catch(Exception e){
		e.printStackTrace();
	}
	return true;
} }