java导出excel表格

package ais.daochu.linshi;

import java.io.FileOutputStream;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Collection;
import java.util.List;


import org.apache.poi.hssf.usermodel.*;

import ais.db.DBConnect;
import ais.dboperate.info.InfoStudentManager;
import ais.dboperate.param.ParamDepartmentManager;
import ais.dboperate.param.ParamSpecialManage;
import ais.dboperate.zizhu.ZizhuProjectGradingManager;
import ais.model.data.DataDemocracyEvaluation;
import ais.model.info.InfoStudent;
import ais.model.zizhu.ZizhuProjectGrading;
import ais.model.zizhu.ZizhuTostudent;

public class PoiTest {
 /*
  * 数据导出最简单的方法
  */
   public static void main(String args[])throws Exception {
        
         //数据库
      FileOutputStream fos = new FileOutputStream("d:"+"8.xls");
   HSSFWorkbook wb = new HSSFWorkbook();
   HSSFSheet s = wb.createSheet();
   wb.setSheetName(0, "first sheet");
   //一行
   HSSFRow row = s.createRow(0);
   //10列
  
   HSSFCell cell1 = row.createCell((short) 0);  
      cell1.setCellType(HSSFCell.CELL_TYPE_STRING);       
      cell1.setCellValue("字段1"); 
     
      HSSFCell cell2 = row.createCell((short) 1);  
      cell2.setCellType(HSSFCell.CELL_TYPE_STRING);       
      cell2.setCellValue("字段2"); 
     
      HSSFCell cell3 = row.createCell((short) 2);  
      cell3.setCellType(HSSFCell.CELL_TYPE_STRING);       
      cell3.setCellValue("字段3"); 
     
      HSSFCell cell4 = row.createCell((short) 3);  
      cell4.setCellType(HSSFCell.CELL_TYPE_STRING);       
      cell4.setCellValue("字段4");
     
      HSSFCell cell5 = row.createCell((short) 4);  
      cell5.setCellType(HSSFCell.CELL_TYPE_STRING);       
      cell5.setCellValue("字段5");
     
      HSSFCell cell6 = row.createCell((short) 5);  
      cell6.setCellType(HSSFCell.CELL_TYPE_STRING);       
      cell6.setCellValue("字段6");
     
      HSSFCell cell7 = row.createCell((short) 6);  
      cell7.setCellType(HSSFCell.CELL_TYPE_STRING);       
      cell7.setCellValue("字段7");
     
      HSSFCell cell8 = row.createCell((short) 7);  
      cell8.setCellType(HSSFCell.CELL_TYPE_STRING);       
      cell8.setCellValue("字段8");
     
      HSSFCell cell9 = row.createCell((short) 8);  
      cell9.setCellType(HSSFCell.CELL_TYPE_STRING);       
      cell9.setCellValue("字段9");
     
      HSSFCell cell10 = row.createCell((short) 9);  
      cell10.setCellType(HSSFCell.CELL_TYPE_STRING);       
      cell10.setCellValue("字段10");
   
      
   wb.write(fos);
   fos.close();
   }
}

有4个jar包需要下载

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值