欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

Java指定导入Excel表格数据中某行某列的数据

程序员文章站 2022-03-16 22:27:47
import java.io.File; import java.io.FileInputStream; import java.util.ArrayList; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.... ......
import java.io.File;
import java.io.FileInputStream;
import java.util.ArrayList;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;


public class Exceleld{
    public static void main(String[]args){  
        ArrayList<String> columnList = new ArrayList<String>();  
        File file = new File("C:/Users/Admin/Desktop/download-template.xls");  
     try {  
      FileInputStream in = new FileInputStream(file);  
      HSSFWorkbook wb = new HSSFWorkbook(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();  
     }  
     
   }  
}