从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();
}
}
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();
}
}