jexcelapi写excel文件的抽象类（二）

继承上次的抽象基类，实现一个具体的报表，这个报表没有统计
/**
 * 反馈信息结果
 * @author 
 */
public class ExcelReportShydFkMaker extends AbstractExcelReportMaker {

 public final static String SHYDFK_REP = "shydfk_rep.xls"; // 报表名

 public final static int ROW_NUMS = 33;// 行数

 public ExcelReportShydFkMaker(List data, String fileName, int iRowAmt) {
  super(data, fileName, iRowAmt);
 }

 @Override
 protected void clearReport(WritableSheet ws, int i) throws GeneException {
  reportContentMaker(ws, new ShydFk(), i);
 }

 @Override
 protected Label getLabelCell(WritableSheet ws) {
  return (Label) ws.getWritableCell(1, 9);
 }

 @Override
 protected void reportBottomMaker(WritableSheet ws) throws GeneException {
  String sPeriod = SessionManager.getInstance().getScheduledPeriod();
  setLableValue(ws.getWritableCell(0, 42), "所属期：" + sPeriod.substring(0, 4) + " 年 "
    + sPeriod.substring(4) + " 月");
  
  setLableValue(ws.getWritableCell(7, 42), " 第 " + getPageAmt() + " 页 ");
 }

 @Override
 protected void reportContentMaker(WritableSheet ws, Object obj, int iRow)
   throws GeneException {
  ShydFk shydFk = (ShydFk) obj;
  int iIndex = iRow + 9;
  // 字段1
  setLableValue(ws.getWritableCell(0, iIndex), shydFk.getErrObj());
  //字段2

   setLableValue(ws.getWritableCell(1, iIndex), shydFk.getLdlpNo());
 }

 @Override
 protected void reportHeadMaker(WritableSheet ws) throws GeneException {
  setLableValue(ws.getWritableCell(0, 3), "企业代码：" + sysinf.getCpcode());
  setLableValue(ws.getWritableCell(0, 5), "企业名称（章）：" + sysinf.getCpname());
 }

 @Override
 protected void reportSubtotalMaker(WritableSheet ws) throws GeneException {
  // TODO Auto-generated method stub

 }

 @Override
 protected void reportTotalizeMaker(WritableSheet ws) throws GeneException {
  // TODO Auto-generated method stub
 }
}
程序中调用如下：

new ExcelReportShydFkMaker(list, ExcelReportShydFkMaker.SHYDFK_REP,
    ExcelReportShydFkMaker.ROW_NUMS).report();

实现了JAVA对EXCEL的控制，把写EXCEL的规则放到具体类，把验证规则放到基类。