jxl对Excel的操作

public static void transExceltoSQL(String filePath) throws Exception{
		StringBuffer sql = null;	
		StringBuffer sb = null;
		Workbook workbook = null; 
		try { 
			workbook = Workbook.getWorkbook(new File(filePath));//拿到Excel
		} catch (Exception e){ 
			throw new Exception(); 
		} 
		FileWriter fw = new FileWriter("D:/Test.sql");  
		Sheet sheet = workbook.getSheet(0); //获取Excel的第一个sheet
		Cell cell = null; 
		for(int i=0; i<sheet.getRows(); i++){
			sql = new StringBuffer("insert into t_detal_sv_factor values (");
			sql.append(sheet.getCell(0, i).getContents());
			sql.append(",");
			sql.append(sheet.getCell(1, i).getContents());
			sql.append(",");
			sql.append(sheet.getCell(2, i).getContents());
			sql.append(",");
			sql.append(sheet.getCell(3, i).getContents());
			sql.append(",");			
			
			for(int j=4; j<sheet.getColumns(); j++){
				cell = sheet.getCell(j, i); //获取每个单元格
				if(cell.getContents()==null||"".equals(cell.getContents()))
					continue;				
				sb = new StringBuffer(sql);
				sb.append(j-3);
				sb.append(",");
				sb.append(cell.getContents());
				sb.append(");\r\n");
		        fw.write(sb.toString(),0,sb.toString().length());    		 
		        fw.flush();    
			}	
		}
	}