Results 1 to 3 of 3
Thread: How to read from excel?
- 03-30-2012, 12:16 AM #1
Member
- Join Date
- Mar 2012
- Posts
- 7
- Rep Power
- 0
How to read from excel?
1. I have edit my excel cell content by
InputStream inp = new FileInputStream("exceltoopl.xls");
org.apache.poi.ss.usermodel.Workbook wb;
wb = org.apache.poi.ss.usermodel.WorkbookFactory.create (inp);
org.apache.poi.ss.usermodel.Sheet sheet = wb.getSheetAt(0);
org.apache.poi.ss.usermodel.Row row = sheet.getRow(4);
org.apache.poi.ss.usermodel.Cell cell = row.getCell(1);
cell.setCellValue(date);
2.After I edited my excel cell, another cell in my sheet is changing
3.But after I try to read the another cell that is changing by this
workbook = jxl.Workbook.getWorkbook(new File("exceltoopl.xls"));
jxl.Sheet sheet1 = workbook.getSheet(0);
pass = sheet1.getCell(3,4).getContents();
System.out.print(pass);
4. I got the result that the same as before editing cell content
How can I get the new result of another cell
Thank you
- 03-30-2012, 03:09 AM #2
Re: How to read from excel?
Moved from Advanced Java.
dbWhy do they call it rush hour when nothing moves? - Robin Williams
- 04-02-2012, 10:50 AM #3
Moderator
- Join Date
- Apr 2009
- Posts
- 10,448
- Rep Power
- 16
Similar Threads
-
How to read Excel file in java
By nagaraj in forum New To JavaReplies: 7Last Post: 03-18-2011, 05:09 AM -
JXL read excel documents
By ironicending in forum Java AppletsReplies: 1Last Post: 09-08-2010, 12:42 AM -
How to read EXCEL Sheet using XML
By raju.i in forum New To JavaReplies: 1Last Post: 04-19-2010, 12:39 AM -
How to Read Excel file??
By spalax in forum New To JavaReplies: 3Last Post: 08-15-2009, 05:06 AM -
How to read Excel file with java
By chetan-24 in forum New To JavaReplies: 5Last Post: 04-22-2009, 05:11 PM


LinkBack URL
About LinkBacks
Reply With Quote
Bookmarks