利用java反射处理excel数据导入示例

public class ExcelImportUtils{

	private static final Logger log = Logger.getLogger(ExcelImportUtils.class);

	public static <T> Object handlerExcel(String pathname,String classpath,
			int row,int cloNum) throws ClassNotFoundException,
			InstantiationException,IllegalAccessException{
		Class model = Class.forName(classpath);
		T mobject = (T)model.newInstance();
		try{
			Workbook book = Workbook.getWorkbook(new File(Global.UPLOAD_FOLDER
					+ File.separator + pathname));
			Sheet sheet = book.getSheet(0);
			int rows = sheet.getRows();
			for (int j = row;j < rows;j++){
				// Cell[] cell = sheet.getRow(j);
				// for (int i = 0;i < cell.length;j++){
				// getCell(列，行)
				/**
				 * @author wzx 利用java反射机制获取传入对象，以及所有属性，setter/getter方法 进行赋值
				 */
				Field[] field = model.getDeclaredFields(); // 获取实体类的所有属性，返回Field数组
				// Method[] method