sheet已经获取到
在如下两个方法中实现读取黄色部分的值然后写入到另一个模板的同样位置
//获取DVP里的数据
public static boolean bompass(XSSFSheet sheet) {
boolean is_ok=true;
//List result=new ArrayList();
XLSWriter xl=new XLSWriter();
for (int rownum = 0; rownum < sheet.getLastRowNum(); rownum++) {
XSSFRow row = sheet.getRow(2);
String ss = row.toString();
System.out.println(ss);
if (row!=null) {
XSSFCell cell = row.getCell(1);
String cc = xl.getStringCellValue(cell);
System.out.println(cc);
/*String DVR_NO = sheet.getCellComment(4, 1).toString();
System.out.println(DVR_NO);
String PARTS_NAME=sheet.getCellComment(5, 2).toString();
System.out.println(PARTS_NAME);
String PARTS_FIGURE_NO=sheet.getCellComment(5, 4).toString();
System.out.println(PARTS_FIGURE_NO);*/
String[] readline = xl.readline(rownum, 1, 4);
System.out.println(readline);
/*String stringCellValue = xl.getStringCellValue(cell);
//String stringCellValue = row.getCell(2).getStringCellValue();
System.out.println(stringCellValue);
result.add(stringCellValue);*/
}
}
return is_ok;
}
//将数据写入到com/jmh/core/excel/DVR.xls中
public static void resetBOMSequence(XSSFWorkbook wb) {
}