java excel 的某一行_Java指定导入Excel表格数据中某行某列的数据

importjava.io.File;importjava.io.FileInputStream;importjava.util.ArrayList;importorg.apache.poi.hssf.usermodel.HSSFWorkbook;importorg.apache.poi.ss.usermodel.Cell;importorg.apache.poi.ss.usermodel.Row;importorg.apache.poi.ss.usermodel.Sheet;public classExceleld{public static voidmain(String[]args){

ArrayList columnList = new ArrayList();

File file= new File("C:/Users/Admin/Desktop/download-template.xls");try{

FileInputStream in= newFileInputStream(file);

HSSFWorkbook wb= newHSSFWorkbook(in);int tabIndex =0;

Sheet sheet=wb.getSheetAt(tabIndex);int firstRowNum =sheet.getFirstRowNum();int lastRowNum =sheet.getLastRowNum();

Row row= null;

Cell cell_a0= null;

Cell cell_a1= null;

Cell cell_a2= null;

Cell cell_a3= null;

Cell cell_a4= null;

Cell cell_a5= null;

Cell cell_a6= null;

Cell cell_a7= null;

Cell cell_a8= null;

Cell cell_a9= null;

Cell cell_b= null;

row= sheet.getRow(1); //取得第2行

cell_a0 = row.getCell(2); //取得2行的第3列

row = sheet.getRow(2); //取得第3行

cell_a1 = row.getCell(2); //取得3行的第3列

row = sheet.getRow(3);

cell_a2= row.getCell(2);

row= sheet.getRow(4);

cell_a3= row.getCell(2);

row= sheet.getRow(5);

cell_a4= row.getCell(2);

row= sheet.getRow(7);

cell_a5= row.getCell(2);

row= sheet.getRow(9);

cell_a6= row.getCell(2);

row= sheet.getRow(10);

cell_a7= row.getCell(2);

String cellValue0=cell_a0.getStringCellValue().trim();

String cellValue1=cell_a1.getStringCellValue().trim();

String cellValue2=cell_a2.getStringCellValue().trim();

String cellValue3=cell_a3.getStringCellValue().trim();

String cellValue4=cell_a4.getStringCellValue().trim();

String cellValue5=cell_a5.getStringCellValue().trim();

String cellValue6=cell_a6.getStringCellValue().trim();

String cellValue7=cell_a7.getStringCellValue().trim();

System.out.println(cellValue0+","+cellValue1+","+cellValue2+","+cellValue3+","+cellValue4+","+cellValue5+","+cellValue6+","+cellValue7);

columnList.add(cellValue0);

columnList.add(cellValue1);

columnList.add(cellValue2);

columnList.add(cellValue3);

columnList.add(cellValue4);

columnList.add(cellValue5);

columnList.add(cellValue6);

columnList.add(cellValue7);}catch(Exception e) {

e.printStackTrace();

}

}

}