jxl是什么包 有什么用啊????
高手 教教``````````````
高手 教教``````````````
解决方案 »
- 如何实现当用户提交数据后向用户发送短信
- 我有个JSP的网站,向改成可以手机访问的。
- SSH中hibernate查询优化
- java.lang.ClassNotFoundException: org.apache.struts.taglib.bean.CookieTei
- 急:如何在后台上传和下载文件?
- 帮帮我啊. (高分求帮助!)(十亿万火急)
- 一个很怪的问题!!!!急寻各位兄弟帮忙!多谢!
- 初学都请教一个class的问题!!
- 页面保存?
- how to call servlet from browser and transfer parameters?
- 求jspsmartUpload组件包 高分(100)
- 急,使用jxl生成excel文件,设置单元格对象类型的问题!
我引入jxl包了呀,如下:
import java.io.*;
import java.io.File;
import jxl.*;
import java.util.Date;
import jxl.write.*;
下面是我的完整代码,在excel中插入其他类型都行,就是注掉的图片插入不行,请帮帮我!多谢
package smpc.vote;import smpc.department.common.ManageDate;
import smpc.department.common.CommonOperation;
import smpc.common.Sequence;import wfc.service.database.SQL;
import wfc.service.database.ClobHelper;
import wfc.service.database.RecordSet;import java.io.*;
import java.io.File;
import jxl.*;
import java.util.Date;
import jxl.write.*; public class readFile
{ public static void writeExl(String fileName,String noPathFileName)
{
try
{
WritableWorkbook workbook = Workbook.createWorkbook(new File(fileName));
WritableSheet sheet = workbook.createSheet("First Sheet", 0);
//1.添加Label对象
jxl.write.Label labelC = new jxl.write.Label(0, 0, "This is a Label cell");
sheet.addCell(labelC);
//添加带有字型Formatting的对象
jxl.write.WritableFont wf = new jxl.write.WritableFont(WritableFont.TIMES, 18, WritableFont.BOLD, true);
jxl.write.WritableCellFormat wcfF = new jxl.write.WritableCellFormat(wf);
jxl.write.Label labelCF = new jxl.write.Label(1, 0, "This is a Label Cell", wcfF);
sheet.addCell(labelCF);
//2.添加Number对象
jxl.write.Number labelN = new jxl.write.Number(0, 1, 3.1415926);
sheet.addCell(labelN);
//添加带有formatting的Number对象
jxl.write.NumberFormat nf = new jxl.write.NumberFormat("#.##");
jxl.write.WritableCellFormat wcfN = new jxl.write.WritableCellFormat(nf);
jxl.write.Number labelNF = new jxl.write.Number(1, 1, 3.1415926, wcfN);
sheet.addCell(labelNF);
//3.添加Boolean对象
jxl.write.Boolean labelB = new jxl.write.Boolean(0, 2, false);
sheet.addCell(labelB); //4.添加DateTime对象
jxl.write.DateTime labelDT = new jxl.write.DateTime(0, 3, new java.util.Date());
sheet.addCell(labelDT);
//添加带有formatting的DateFormat对象
jxl.write.DateFormat df = new jxl.write.DateFormat("dd MM yyyy hh:mm:ss");
jxl.write.WritableCellFormat wcfDF = new jxl.write.WritableCellFormat(df);
jxl.write.DateTime labelDTF = new jxl.write.DateTime(1, 3, new java.util.Date(), wcfDF);
sheet.addCell(labelDTF);
//图片
//jxl.write.WritableImage wi=new jxl.write.WritableImage(5,5,5,7,new File("applications/rdnw/vote/jsp/excel/m.png"));
//sheet.addImage(wi);
workbook.write();
workbook.close();
}
catch(Exception e)
{
System.out.println(e);
}
}
}
圖片格式要是png才行的。/*
* jxlPic.java
*
* Created on 2005年8月24日, 上午 5:01
*//**
*
* @author tao
*/
public class jxlPic {
/** Creates a new instance of jxlPic */
public jxlPic() {
}
public static void main(String args[]){
try{
jxl.write.WritableWorkbook excel=null;
jxl.write.WritableSheet sheet=null;
java.io.File f = new java.io.File("a.xls");
excel=jxl.Workbook.createWorkbook(f);
sheet=excel.createSheet("aa", 0);
jxl.write.WritableFont wf = new jxl.write.WritableFont(jxl.write.WritableFont.TIMES,
14,jxl.write.WritableFont.BOLD,true);
jxl.write.WritableCellFormat wcf = new jxl.write.WritableCellFormat(wf);
jxl.write.Label label=new jxl.write.Label(0,0,"Test",wcf);
sheet.addCell(label);
java.io.File ff = new java.io.File("lgc202.png");
jxl.write.WritableImage wi=new jxl.write.WritableImage(1,0,1,1,ff);
sheet.addImage(wi);
excel.write();
excel.close();
}catch(Exception e){}
}
}
你看著改你的程序吧。
祝你好運。 ̄