jxl excel图片问题

Question

每天数据都有图片但是导出大量的数据时，图片位置就会串，而且如果我某一条数据没有图片，那么图片就会上传一行，请问要怎么解决呢？ 请各位帮忙！
package Tool;

import java.io.File;
import java.io.OutputStream;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;

import jxl.Workbook;
import jxl.format.Colour;
import jxl.write.Label;
import jxl.write.WritableCellFormat;
import jxl.write.WritableFont;
import jxl.write.WritableImage;

public class LedgerDataPort {
// 导出数据
public void export(OutputStream os,Connection con)
throws Exception {
Statement stmt = con.createStatement();
Statement smt = con.createStatement();
ResultSet rs = null;
try {
String sql;

        sql = "select id as '序列', photo as '图片',produces as '生产厂家',nuclideName as '核素名',outActivite as '出厂活度',outDate as '日期',classes as '类别',code as '国家编码',status as '状态',saveAdd as '保存地址', remark as '备注',ratify as '审批状态'"
                + "from LedgerMessage where ratify ='1'";
        rs = stmt.executeQuery(sql);

    // 用JXL向新建的文件中添加内容
    jxl.write.WritableWorkbook wwb = Workbook.createWorkbook(os);
    jxl.write.WritableSheet ws = wwb.createSheet("台帐信息表", 0);
    WritableFont wfobj=new WritableFont(WritableFont.ARIAL, 12, WritableFont.BOLD);     
    WritableCellFormat cfobj=new WritableCellFormat(wfobj);     
    cfobj.setBackground(Colour.PINK);               
    cfobj.setWrap(true);

    int i = 0;

//// // int j = 0;
jxl.write.Label labelC = new jxl.write.Label(0, 0, "序列");
Label lblImage=new Label(1,0,"Image", cfobj);
ws.addCell(lblImage);

WritableImage imgobj=new WritableImage(0, 0, 3, 5, new File("D:/sunset.png"));
ws.addImage(imgobj);
ws.addCell(labelC);
for (int k = 1; k < rs.getMetaData().getColumnCount(); k++) {
labelC = new jxl.write.Label(k, 0, rs.getMetaData()
.getColumnName(k + 1));
ws.addCell(labelC);
}

    while (rs.next()) {
        labelC = new jxl.write.Label(0, i + 1, i + 1 + ""); // 为序列赋值
        ws.addCell(labelC);
        for (int k = 1; k < rs.getMetaData().getColumnCount(); k++) {
//          System.out.println("rs.getString(k + 1) --> "+rs.getString(k + 1) + " k --> "+k);
            labelC = new jxl.write.Label(k, i + 1, rs.getString(k + 1));
            ws.addCell(labelC);
        }
        ResultSet rst = smt
                .executeQuery("select * from LedgerMessage where ratify ='1'");

        rst.close();
        i++;
    }
    wwb.write();
    wwb.close();
} catch (Exception e) {
    System.out.print(e);
    e.printStackTrace();
} finally {
    rs.close();
    smt.close();
    stmt.close();
    con.close();
}

}

}

Answer 1

当某一行数据没有图片的时候，只是放置图片的额单元格，数据排版不是预想的结果，当没有该条记录没有图片，你进行判断，'图片'这个字段没有数据，你就addCell(new Label(col,ros,""));添加一个空格，站位，防止数据乱了。