xpages从Excel中导入数据

从Excel中导入数据主要思路是先把要导入的Excel文档上传到一个文档中，然后在Java代码中得到这个文档，取出这个附件，得到InputStream，把InputStream交给apache的POI,就可以读到数据，得到数据之后，就可以创建文档了。示例代码如下：
public void importExcel() {


FacesContext context = FacesContext.getCurrentInstance();
Session session = (Session) context.getApplication()
.getVariableResolver().resolveVariable(context, "session");


// The Faces Context global object provides access to the servlet
// environment via the external content
ExternalContext extCont = context.getExternalContext();
// The servlet's response object provides control to the response object
HttpServletResponse pageResponse = (HttpServletResponse) extCont
.getResponse();


HttpServletRequest request = (HttpServletRequest) extCont.getRequest();





try {
Database database = session.getCurrentDatabase();


View view = database.getView("importtestv");


Document doc = view.getFirstDocument();

RichTextItem body = null;
body = (RichTextItem) doc.getFirstItem("ddddd");

// String path = jhFile.getBody().getAbsolutePath();
//
//body.getEmbeddedObject("").getInputStream();
EmbeddedObject e = (EmbeddedObject)body.getEmbeddedObjects().get(0);

InputStream is = e.getInputStream();

byte[] buf = IOUtils.toByteArray(is);
ByteArrayInputStream byteArrayInputStream = new ByteArrayInputStream(buf);


POIFSFileSystem fs;
HSSFWorkbook wb;
HSSFSheet sheet;
HSSFRow row;


fs = new POIFSFileSystem(byteArrayInputStream);
wb = new HSSFWorkbook(fs);


sheet = wb.getSheetAt(0);
row = sheet.getRow(0);
System.out.println(row.getCell(0).getStringCellValue());
} catch (Exception e) {
e.printStackTrace();
}
}