Hi,
Excel and POI are separate. Your POI-based program simply cannot see
what is shown in Excel until you save the file and then read it back
into your POI program.
You describe the expected behavior.
Good luck,
Dave
On Apr 14, 2009, at 6:56 AM, Suladna wrote:
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
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
