jxl.write.WritableWorkbook wwb = Workbook.createWorkbook(“D:\1.xls”); jxl.write.WritableSheet ws = wwb.createSheet("TestSheet1",0); File file = new File("D:\\2.png"); jxl.write.WritableImage f = new jxl.write.WritableImage(1,2,2,2,file); ws.addImage(f); //写入Exel工作表 wwb.write(); //关闭Excel工作薄对象 wwb.close();
WritableImage public WritableImage(double x, double y, double width, double height, java.io.File image)Constructor Parameters: x - the column number at which to position the image y - the row number at which to position the image width - the number of columns cells which the image spans height - the number of rows which the image spans image - the source image file
根据bxh2dai(希望明天会有些改变)的提示写的,还是报错import java.io.*; import jxl.*; import jxl.write.*; public class Exam { public static void main(String args[]) { try { Workbook wb=Workbook.getWorkbook(new File("D:\\1.xls")); jxl.write.WritableWorkbook wwb = Workbook.createWorkbook(new File("D:\\1.xls"),wb); jxl.write.WritableSheet ws = wwb.createSheet("TestSheet1",0); File file = new File("D:\\2.png"); jxl.write.WritableImage f = new jxl.write.WritableImage(1,2,2,2,file); ws.addImage(f); //写入Exel工作表 wwb.write(); //关闭Excel工作薄对象 wwb.close();}catch(Exception e) { System.out.println(e); } } } 提示信息如下: java.lang.NullPointerExecption
jxl.write.WritableSheet ws = wwb.createSheet("TestSheet1",0);
File file = new File("D:\\2.png");
jxl.write.WritableImage f = new jxl.write.WritableImage(1,2,2,2,file);
ws.addImage(f);
//写入Exel工作表
wwb.write();
//关闭Excel工作薄对象
wwb.close();
public WritableImage(double x,
double y,
double width,
double height,
java.io.File image)Constructor Parameters:
x - the column number at which to position the image
y - the row number at which to position the image
width - the number of columns cells which the image spans
height - the number of rows which the image spans
image - the source image file
import jxl.*;
import jxl.write.*; public class Exam
{
public static void main(String args[])
{
try
{
Workbook wb=Workbook.getWorkbook(new File("D:\\1.xls"));
jxl.write.WritableWorkbook wwb = Workbook.createWorkbook(new File("D:\\1.xls"),wb);
jxl.write.WritableSheet ws = wwb.createSheet("TestSheet1",0);
File file = new File("D:\\2.png");
jxl.write.WritableImage f = new jxl.write.WritableImage(1,2,2,2,file);
ws.addImage(f);
//写入Exel工作表
wwb.write();
//关闭Excel工作薄对象
wwb.close();}catch(Exception e)
{
System.out.println(e);
}
}
}
提示信息如下:
java.lang.NullPointerExecption
import java.io.FileOutputStream;
import java.io.FileInputStream;
import java.io.OutputStream;
import jxl.Workbook;
import jxl.format.UnderlineStyle;
import jxl.write.WritableFont;
import jxl.write.WritableImage;
import java.lang.Byte;public class testjexcelapi {
final boolean production = true;
public static void writeExcel(OutputStream os) throws Exception {
jxl.write.WritableWorkbook wwb = Workbook.createWorkbook(os);
jxl.write.WritableSheet ws = wwb.createSheet("软件所", 0);
jxl.write.Label labelC = new jxl.write.Label(0, 0, "北航");
ws.addCell(labelC);
File image = new File("d:\\22.gif");
byte[] imageContent =new byte[1000000];
FileInputStream imagestream =new FileInputStream(image);
imagestream.read(imageContent);
WritableImage wimage = new WritableImage(0, 1, 0.8, 0.8,imageContent);
//WritableImage wimage = new WritableImage(4, 4, 1, 1,image);
ws.addImage(wimage); jxl.write.WritableFont wfc = new jxl.write.WritableFont(
WritableFont.ARIAL, 20, WritableFont.BOLD,
false, UnderlineStyle.NO_UNDERLINE, jxl.format.Colour.GREEN); jxl.write.WritableCellFormat wcfFC = new jxl.write.WritableCellFormat(wfc); wcfFC.setBackground(jxl.format.Colour.RED);
labelC = new jxl.write.Label(6, 0, "北航", wcfFC);
ws.addCell(labelC);
// 写入Exel工作表
wwb.write();
// 关闭Excel工作薄对象
wwb.close(); } public static void main(String[] args)
{
//testjexcelapi dd = new testjexcelapi();
try{ File f = new File("d:\\testjexcelapi.xls");
//File image = new File("d:\\22.gif");
//WritableImage wimage = new WritableImage(4, 4, 1, 1,image);
//byte[] imageContent = new FileInputStream(image);
//WritableImage wimage = new WritableImage(4, 4, 1, 1,(new FileInputStream(image)));
testjexcelapi.writeExcel(new FileOutputStream(f));
} catch(Exception e)
{
e.printStackTrace();
}
}
}
感谢你的关注,我运行了你给的代码,javac * 和 java * 都没报错,但是打开testjexcelapi.xls文件的时候说 不能读取文件,点击确认后打开,testjexcelapi sheet 是建立了,但是里面是空的
我给你的代码不行了,好的这次要看清楚了,我下面的代码可是测试通过的啊,呵呵
成功了记得把分都给我啊,哈哈public class test {
public static void writeImageExcel(OutputStream os) throws Exception {
//一定要流的形式创建这个对象
jxl.write.WritableWorkbook wwb = Workbook.createWorkbook(os);
jxl.write.WritableSheet ws = wwb.createSheet("写入图片", 0);
File image = new File("d:\\2.png");
WritableImage wimage = new WritableImage(0, 1,2,2,image);
ws.addImage(wimage);// 写入Exel工作表
wwb.write();
// 关闭Excel工作薄对象
wwb.close(); } public static void main (String args[]) throws Exception{
try{ File f = new File("d:\\image.xls");
//这里要以流的形式,不要以文件的形式
test.writeExcel(new FileOutputStream(f));
} catch(Exception e)
{
e.printStackTrace();
} }
}
其中有一段:
test.writeExcel(new FileOutputStream(f));
很明显不对阿,是不是贴错了?
bxh2dai(希望明天会有些改变) 老实说你给的代码质量不高哈,希望下次再见时可以向你的名字一样“会有些改变”。呵呵开个玩笑罢了,不要当真!
没有错误!自动转型嘛!