将java输出到excel中

java将数据输出到Excel中 .
分类： It 2009-05-21 10:27 1121人阅读 评论(0) 收藏 举报 
 

import java.io.FileOutputStream;

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;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.util.HSSFColor;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.hssf.usermodel.HSSFPalette;

public class Excel {
         public static void main(String argv[]){ 
         try{
             HSSFWorkbook wb=new HSSFWorkbook();
             HSSFSheet sheet=wb.createSheet();
                
             //第一个样式和输出(边框)
             HSSFCellStyle style=wb.createCellStyle();
             style.setBorderBottom(HSSFCellStyle.BORDER_THIN);    //设置底线和颜色
             style.setBottomBorderColor(HSSFColor.BLACK.index);
             style.setBorderLeft(HSSFCellStyle.BORDER_THIN);   //设置左边线和颜色
             style.setLeftBorderColor(HSSFColor.BLACK.index);
             style.setBorderRight(HSSFCellStyle.BORDER_THIN);   //设置右边线和颜色
             style.setRightBorderColor(HSSFColor.BLACK.index);
             style.setBorderTop(HSSFCellStyle.BORDER_THIN);   //设置上面线和颜色