excelrptmgr.java

本文论述了一个前台笔记本销售系统的开发过程

package com.set.utils;

import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;

import jxl.write.Label;
import jxl.write.Number;
import jxl.write.WritableCell;
import jxl.write.WritableSheet;

import com.set.appframe.data.GenericValueObject;

/**
 * <p>
 * Title: 代码生成框架
 * </p>
 * <p>
 * Description:
 * </p>
 * <p>
 * Copyright: Copyright (c) 2005
 * </p>
 * <p>
 * Company:
 * </p>
 * 
 * @author zhifeng
 * @version 1.0
 */

public class ExcelRptMgr {
	public static void fillFields(ArrayList fields, List gvos,
			WritableSheet sheet) throws Exception {
		int len = fields.size();
		if (len < 1 || null == gvos)
			throw new Exception("error.arguments");

		ExcelField first = (ExcelField) fields.get(0);
		ExcelField last = (ExcelField) fields.get(len - 1);
		int columnBegin = Integer.parseInt(first.getColumn());
		int columnEnd = Integer.parseInt(last.getColumn());
		int row = Integer.parseInt(first.getRow());

		Iterator voit = gvos.iterator();
		Iterator fieldit = null;
		GenericValueObject gvo;
		Label labelCF;
		Number numberCF;
		WritableCell cell = null;
		for (; voit.hasNext();) {
			gvo = (GenericValueObject) voit.next();
			fieldit = fields.iterator();
			for (; fieldit.hasNext();) {
				ExcelField tmpField = (ExcelField) fieldit.next();
				int i = Integer.parseInt(tmpField.getColumn());
				Object obj = gvo.getItem(tmpField.getValue());
				if (null != obj) {
					if (obj instanceof Integer || obj instanceof Float) {
						cell = new Number(i, row, Double.parseDouble(gvo
								.getItemString(tmpField.getValue())));
					} else {
						cell = new Label(i, row, gvo.getItemString(tmpField
								.getValue()));
					}
					sheet.addCell(cell);
				}
			}
			row++;
			if (voit.hasNext()) {
				sheet.insertRow(row);
			}
		}

	}

}