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