It works! import org.apache.poi.ss.usermodel.Cell; import org.apache.poi.ss.usermodel.DateUtil; import org.apache.poi.ss.util.CellReference; import org.apache.poi.xssf.usermodel.XSSFSheet; import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import java.io.FileInputStream; import java.io.IOException; public class POITestRB { public static void main(String[] args) throws IOException { FileInputStream fis = new FileInputStream("C:/Test/1.xlsm"); XSSFWorkbook workbook = new XSSFWorkbook(fis); gettingTheCellContents(workbook, "D5"); fis.close(); workbook.close(); } private static void gettingTheCellContents(XSSFWorkbook workbook, String cellId) { XSSFSheet sheet = workbook.getSheetAt(1); CellReference ref = new CellReference(cellId); int row = ref.getRow(); int col = ref.getCol(); Cell cell = sheet.getRow(row).getCell(col); switch (cell.getCellTypeEnum()) { case STRING: System.out.println(cell.getRichStringCellValue().getString()); break; case NUMERIC: if (DateUtil.isCellDateFormatted(cell)) { System.out.println(cell.getDateCellValue()); } else { System.out.println(cell.getNumericCellValue()); } break; case BOOLEAN: System.out.println(cell.getBooleanCellValue()); break; case FORMULA: System.out.println("Formula is: " + cell.getCellFormula()); switch(cell.getCachedFormulaResultType()) { case Cell.CELL_TYPE_NUMERIC: System.out.println("1. case Cell.CELL_TYPE_NUMERIC --> Last evaluated as: " + cell.getNumericCellValue()); break; case Cell.CELL_TYPE_STRING: System.out.println("2. case Cell.CELL_TYPE_STRING --> Last evaluated as \"" + cell.getRichStringCellValue() + "\""); break; } break; case BLANK: System.out.println(); break; default: System.out.println(); } } } -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Getting-the-cell-contents-tp5728401p5728406.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional commands, e-mail: user-h...@poi.apache.org