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

2018-06-18 03:04:23来源:未知 阅读 ()

新老客户大回馈,云服务器低至5折

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();  
     }  
     
   }  
}

 

标签:

版权申明:本站文章部分自网络,如有侵权,请联系:west999com@outlook.com
特别注意:本站所有转载文章言论不代表本站观点,本站所提供的摄影照片,插画,设计作品,如需使用,请与原作者联系,版权归原作者所有

上一篇:Leetcode Add Two Numbers (java)

下一篇:Tomcat热部署,Web工程中线程没有终止