大家好,我想问一个问题。最近感觉好奇,想用Java操纵Excel,我在网上找到了一些源码,但是在Eclipse中运行时有四个包找不到,不知道什么原因,请大家帮忙解决!
    四个包是:org.apache.poi.hssf.usermodel.HSSFWorkbook;
            org.apache.poi.hssf.usermodel.HSSFSheet;
            org.apache.poi.hssf.usermodel.HSSFRow;
            org.apache.poi.hssf.usermodel.HSSFCell;
    想问:1、下载的网站是什么(或者发到:[email protected]
           2、这个包应该放到哪个目录下
           

解决方案 »

  1.   

    apache 的 POI open source project,去apache网站下载,一个jar包,放到lib下
      

  2.   

    下载页面:
    http://apache.justdn.org/jakarta/poi/release/bin/下载地址:
    http://apache.justdn.org/jakarta/poi/release/bin/poi-bin-3.0-FINAL-20070503.zip
      

  3.   

    Eclipse 导入poi-3.2-FINAL;import java.io.*;
    import jxl.*;
    import jxl.write.*;
    import jxl.format.*;
    import java.util.*;
    import java.awt.Color;
    public class Excel{
     public static void writeExcel(OutputStream os) throws Exception{
      jxl.write.WritableWorkbook wwb=Workbook.createWorkbook(os);
      jxl.write.WritableSheet ws=wwb.createSheet("title",0);
      jxl.write.Label labelc=new jxl.write.Label(0,0,"zhongguo");
      jxl.write.Label labelk=new jxl.write.Label(1,1,"kaka");
      ws.addCell(labelc);
      ws.addCell(labelk);
      jxl.write.WritableFont wfc=new jxl.write.WritableFont(WritableFont.ARIAL,20,WritableFont.BOLD,false,
      UnderlineStyle.NO_UNDERLINE,jxl.format.Colour.RED);
      jxl.write.WritableCellFormat wcfFC=new jxl.write.WritableCellFormat(wfc);
      wcfFC.setBackground(jxl.format.Colour.GREEN);
      
      labelc=new jxl.write.Label(6,0,"中国爱我",wcfFC);  
      ws.addCell(labelc);
      wwb.write();
      wwb.close();
      
     }
     public static void main(String[] agrs) throws Exception{
      File f=new File("kk.xls");
      f.createNewFile();   
      writeExcel(new FileOutputStream(f));
     }
    }