大家好,我想问一个问题。最近感觉好奇,想用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、这个包应该放到哪个目录下
四个包是: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、这个包应该放到哪个目录下
http://apache.justdn.org/jakarta/poi/release/bin/下载地址:
http://apache.justdn.org/jakarta/poi/release/bin/poi-bin-3.0-FINAL-20070503.zip
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));
}
}