Hi, I did use jexcelapi to extract the contents out of excel file, however, I couldn't get the content when I sysout. Below are the codes that I wrote, perhaps you can point out where I have done wrong. Thanks.
Workbook excelDoc = Workbook.getWorkbook(new FileInputStream(file)); String content = ""; for(int i = 0; i < excelDoc.getNumberOfSheets(); i++) { Sheet sheet = excelDoc.getSheet(i); Cell[] row = null; for(int j = 0; j < sheet.getRows(); j++) { row = sheet.getRow(i); System.err.println("row is ::: " +row.length); if(row.length > 0) { content = row[i].getContents(); System.err.println("content inside loop is ::: " +content); } } } System.err.println("content is ::: " +content); doc.add(new Field(DsConstant.idxFileContent, content, Field.Store.YES, Field.Index.TOKENIZED)); doc.add(new Field(DsConstant.idxFileName, file.getName(), Field.Store.YES, Field.Index.UN_TOKENIZED)); doc.add(new Field(DsConstant.idxPath, file.getPath(), Field.Store.YES, Field.Index.UN_TOKENIZED)); excelDoc.close(); regards, Wooi Meng -- View this message in context: http://www.nabble.com/Index-Excel-File-tf2817920.html#a7866165 Sent from the Lucene - Java Users mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]