Hi!
I'm using the below program to bring the text in cell A1 to Java:
XSSFWorkbook wb = new XSSFWorkbook("C:/myDocument.xlsm");
XSSFSheet sheet = wb.getSheet("Sheet1");
Row firstRow = sheet.getRow(0);
System.out.println(firstRow.getCell(0).getRichStringCellValue().getString())
It works fine, but when I change the text in A1, my program doesn't notice this
until I save the Excel-document. If I re-run the program without saving the
Excel document, the old text in A1 appears in my Java console. Is it possible
to come around this?
/Sul Adna