Java specifies the data of a column in a row of data imported into an Excel table.

Java specifies the data of a column in a row of data imported into an Excel table.

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); // get 2nd rows cell_a0 = row. getCell (2); // get the row of the 3rd column of the 2 rows = sheet. getRow (2); // get 3rd rows cell_a1 = row. getCell (2); // get the row of the 3rd column of the 3 rows = 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 ();}}}