List of usage examples for org.apache.poi.hssf.usermodel HSSFWorkbook getNumberOfSheets
@Override public int getNumberOfSheets()
From source file:com.dexter.fuelcard.mbean.UserMBean.java
public void offloadCards() { FacesContext curContext = FacesContextImpl.getCurrentInstance(); if (getUploadItem() != null) { try {//from ww w . j a v a 2s . c o m HSSFWorkbook workbook = new HSSFWorkbook(getUploadItem().getInputstream()); int sheetCount = workbook.getNumberOfSheets(); if (sheetCount >= 1) { String password = getRandomDigitPassword(); HSSFSheet sheet = workbook.getSheetAt(0); // first sheet should be the main sheet sheet.protectSheet(password); ByteArrayOutputStream byout = new ByteArrayOutputStream(); workbook.write(byout); byout.close(); CardRequest cr = new CardRequest(); cr.setRequestRefNum(getActiveUser().getPartner().getCode() + "-" + password); cr.setAdditionalComment(getRequestComment()); cr.setCrt_dt(new Date()); cr.setExcelFile(byout.toByteArray()); cr.setPartner(getActiveUser().getPartner()); cr.setRequest_dt(new Date()); cr.setRequestedBy(getActiveUser()); cr.setRequestType("OFFLOAD-CARDS"); cr.setStatus("PENDING"); GeneralDAO gDAO = new GeneralDAO(); gDAO.startTransaction(); boolean ret = gDAO.save(cr); if (ret) { gDAO.commit(); setRequestComment(null); setMyPendingCardCancelRequests(null); curContext.addMessage(null, new FacesMessage(FacesMessage.SEVERITY_INFO, "Success", "Request submitted successfully!")); // Send email to user that submitted that their request is been treated String body = "<html><body><p>Dear " + getActiveUser().getFullname() + ",</p><p>Your request to offload cards has been recieved and will be treated as soon as possible. You will be notified of every progress.</p><p>Regards<br/>Fuel Card Platform</p></body></html>"; Emailer.sendEmail("fuelcard@sattrakservices.com", new String[] { getActiveUser().getEmail() }, "Card OffLoad Request - " + cr.getRequestRefNum() + " Received", body); // Send email to sattrak that request is submitted byte[] doc = cr.getExcelFile(); String body2 = "<html><body><p>Hello,</p><p>A request to offload cards has been submitted. The document is attached.</p><p>Regards<br/>Fuel Card Platform</p></body></html>"; if (getSattrakPartner() != null && getSattrakPartner().getContactEmails() != null && getSattrakPartner().getContactEmails().trim().length() > 0) { String[] to = getSattrakPartner().getContactEmails().split(","); Emailer.sendEmail("fuelcard@sattrakservices.com", to, "Card OffLoad Request - " + cr.getRequestRefNum() + " Submitted", body2, doc, cr.getRequestRefNum() + ".xls", "application/vnd.ms-excel"); } } else { gDAO.rollback(); curContext.addMessage(null, new FacesMessage(FacesMessage.SEVERITY_ERROR, "Error", gDAO.getMessage())); } gDAO.destroy(); } else { curContext.addMessage(null, new FacesMessage(FacesMessage.SEVERITY_ERROR, "Failed", "Excel document is not valid!")); } } catch (Exception ex) { curContext.addMessage(null, new FacesMessage(FacesMessage.SEVERITY_ERROR, "Severe", "Please upload an excel document! Error: " + ex.getMessage())); } } else { curContext.addMessage(null, new FacesMessage(FacesMessage.SEVERITY_ERROR, "Failed", "Please upload an excel document!")); } }
From source file:com.dexter.fuelcard.mbean.UserMBean.java
public void loadCards() { FacesContext curContext = FacesContextImpl.getCurrentInstance(); if (getUploadItem() != null) { try {//from w ww . ja va2 s .co m HSSFWorkbook workbook = new HSSFWorkbook(getUploadItem().getInputstream()); int sheetCount = workbook.getNumberOfSheets(); if (sheetCount >= 1) { String password = getRandomDigitPassword(); HSSFSheet sheet = workbook.getSheetAt(0); // first sheet should be the main sheet sheet.protectSheet(password); ByteArrayOutputStream byout = new ByteArrayOutputStream(); workbook.write(byout); byout.close(); CardRequest cr = new CardRequest(); cr.setRequestRefNum(getActiveUser().getPartner().getCode() + "-" + password); cr.setAdditionalComment(getRequestComment()); cr.setCrt_dt(new Date()); cr.setExcelFile(byout.toByteArray()); cr.setPartner(getActiveUser().getPartner()); cr.setRequest_dt(new Date()); cr.setRequestedBy(getActiveUser()); cr.setRequestType("LOAD-CARDS"); cr.setStatus("PENDING"); GeneralDAO gDAO = new GeneralDAO(); gDAO.startTransaction(); boolean ret = gDAO.save(cr); if (ret) { gDAO.commit(); setRequestComment(null); setMyPendingCardCancelRequests(null); curContext.addMessage(null, new FacesMessage(FacesMessage.SEVERITY_INFO, "Success", "Request submitted successfully!")); // Send email to user that submitted that their request is been treated String body = "<html><body><p>Dear " + getActiveUser().getFullname() + ",</p><p>Your request to load cards has been recieved and will be treated as soon as possible. You will be notified of every progress.</p><p>Regards<br/>Fuel Card Platform</p></body></html>"; Emailer.sendEmail("fuelcard@sattrakservices.com", new String[] { getActiveUser().getEmail() }, "Card Load Request - " + cr.getRequestRefNum() + " Received", body); // Send email to sattrak that request is submitted byte[] doc = cr.getExcelFile(); String body2 = "<html><body><p>Hello,</p><p>A request to load cards has been submitted. The document is attached.</p><p>Regards<br/>Fuel Card Platform</p></body></html>"; if (getSattrakPartner() != null && getSattrakPartner().getContactEmails() != null && getSattrakPartner().getContactEmails().trim().length() > 0) { String[] to = getSattrakPartner().getContactEmails().split(","); Emailer.sendEmail("fuelcard@sattrakservices.com", to, "Card Load Request - " + cr.getRequestRefNum() + " Submitted", body2, doc, cr.getRequestRefNum() + ".xls", "application/vnd.ms-excel"); } } else { gDAO.rollback(); curContext.addMessage(null, new FacesMessage(FacesMessage.SEVERITY_ERROR, "Error", gDAO.getMessage())); } gDAO.destroy(); } else { curContext.addMessage(null, new FacesMessage(FacesMessage.SEVERITY_ERROR, "Failed", "Excel document is not valid!")); } } catch (Exception ex) { curContext.addMessage(null, new FacesMessage(FacesMessage.SEVERITY_ERROR, "Severe", "Please upload an excel document! Error: " + ex.getMessage())); } } else { curContext.addMessage(null, new FacesMessage(FacesMessage.SEVERITY_ERROR, "Failed", "Please upload an excel document!")); } }
From source file:com.dexter.fuelcard.mbean.UserMBean.java
public void cancelCards() { FacesContext curContext = FacesContextImpl.getCurrentInstance(); if (getUploadItem() != null) { try {//from w w w . jav a 2 s. com HSSFWorkbook workbook = new HSSFWorkbook(getUploadItem().getInputstream()); int sheetCount = workbook.getNumberOfSheets(); if (sheetCount >= 1) { String password = getRandomDigitPassword(); HSSFSheet sheet = workbook.getSheetAt(0); // first sheet should be the main sheet sheet.protectSheet(password); ByteArrayOutputStream byout = new ByteArrayOutputStream(); workbook.write(byout); byout.close(); CardRequest cr = new CardRequest(); cr.setRequestRefNum(getActiveUser().getPartner().getCode() + "-" + password); cr.setAdditionalComment(getRequestComment()); cr.setCrt_dt(new Date()); cr.setExcelFile(byout.toByteArray()); cr.setPartner(getActiveUser().getPartner()); cr.setRequest_dt(new Date()); cr.setRequestedBy(getActiveUser()); cr.setRequestType("CANCEL-CARDS"); cr.setStatus("PENDING"); GeneralDAO gDAO = new GeneralDAO(); gDAO.startTransaction(); boolean ret = gDAO.save(cr); if (ret) { gDAO.commit(); setRequestComment(null); setMyPendingCardCancelRequests(null); curContext.addMessage(null, new FacesMessage(FacesMessage.SEVERITY_INFO, "Success", "Request submitted successfully!")); // Send email to user that submitted that their request is been treated String body = "<html><body><p>Dear " + getActiveUser().getFullname() + ",</p><p>Your request to decommission cards has been recieved and will be treated as soon as possible. You will be notified of every progress.</p><p>Regards<br/>Fuel Card Platform</p></body></html>"; Emailer.sendEmail("fuelcard@sattrakservices.com", new String[] { getActiveUser().getEmail() }, "Card Decommission Request - " + cr.getRequestRefNum() + " Received", body); // Send email to sattrak that request is submitted byte[] doc = cr.getExcelFile(); String body2 = "<html><body><p>Hello,</p><p>A request to decommission cards has been submitted. The document is attached.</p><p>Regards<br/>Fuel Card Platform</p></body></html>"; if (getSattrakPartner() != null && getSattrakPartner().getContactEmails() != null && getSattrakPartner().getContactEmails().trim().length() > 0) { String[] to = getSattrakPartner().getContactEmails().split(","); Emailer.sendEmail("fuelcard@sattrakservices.com", to, "Card Decommission Request - " + cr.getRequestRefNum() + " Submitted", body2, doc, cr.getRequestRefNum() + ".xls", "application/vnd.ms-excel"); } } else { gDAO.rollback(); curContext.addMessage(null, new FacesMessage(FacesMessage.SEVERITY_ERROR, "Error", gDAO.getMessage())); } gDAO.destroy(); } else { curContext.addMessage(null, new FacesMessage(FacesMessage.SEVERITY_ERROR, "Failed", "Excel document is not valid!")); } } catch (Exception ex) { curContext.addMessage(null, new FacesMessage(FacesMessage.SEVERITY_ERROR, "Severe", "Please upload an excel document! Error: " + ex.getMessage())); } } else { curContext.addMessage(null, new FacesMessage(FacesMessage.SEVERITY_ERROR, "Failed", "Please upload an excel document!")); } }
From source file:com.dexter.fuelcard.mbean.UserMBean.java
public void orderCards() { FacesContext curContext = FacesContextImpl.getCurrentInstance(); if (getUploadItem() != null) { try {//from w ww .j a v a2 s . co m HSSFWorkbook workbook = new HSSFWorkbook(getUploadItem().getInputstream()); int sheetCount = workbook.getNumberOfSheets(); if (sheetCount >= 2) { String password = getRandomDigitPassword(); HSSFSheet sheet = workbook.getSheetAt(0); // first sheet should be the main sheet sheet.protectSheet(password); ByteArrayOutputStream byout = new ByteArrayOutputStream(); workbook.write(byout); byout.close(); CardRequest cr = new CardRequest(); cr.setRequestRefNum(getActiveUser().getPartner().getCode() + "-" + password); cr.setAdditionalComment(getRequestComment()); cr.setCrt_dt(new Date()); cr.setExcelFile(byout.toByteArray()); cr.setPartner(getActiveUser().getPartner()); cr.setRequest_dt(new Date()); cr.setRequestedBy(getActiveUser()); cr.setRequestType("ORDER-CARDS"); cr.setStatus("PENDING"); GeneralDAO gDAO = new GeneralDAO(); gDAO.startTransaction(); boolean ret = gDAO.save(cr); if (ret) { gDAO.commit(); setRequestComment(null); setMyPendingCardOrderRequests(null); curContext.addMessage(null, new FacesMessage(FacesMessage.SEVERITY_INFO, "Success", "Request submitted successfully!")); // Send email to user that submitted that their request is been treated String body = "<html><body><p>Dear " + getActiveUser().getFullname() + ",</p><p>Your request to order cards has been recieved and will be treated as soon as possible. You will be notified of every progress.</p><p>Regards<br/>Fuel Card Platform</p></body></html>"; Emailer.sendEmail("fuelcard@sattrakservices.com", new String[] { getActiveUser().getEmail() }, "Card Order Request - " + cr.getRequestRefNum() + " Received", body); // Send email to sattrak that request is submitted byte[] doc = cr.getExcelFile(); String body2 = "<html><body><p>Hello,</p><p>A request to order cards has been submitted. The document is attached.</p><p>Regards<br/>Fuel Card Platform</p></body></html>"; if (getSattrakPartner() != null && getSattrakPartner().getContactEmails() != null && getSattrakPartner().getContactEmails().trim().length() > 0) { String[] to = getSattrakPartner().getContactEmails().split(","); Emailer.sendEmail("fuelcard@sattrakservices.com", to, "Card Order Request - " + cr.getRequestRefNum() + " Submitted", body2, doc, cr.getRequestRefNum() + ".xls", "application/vnd.ms-excel"); } } else { gDAO.rollback(); curContext.addMessage(null, new FacesMessage(FacesMessage.SEVERITY_ERROR, "Error", gDAO.getMessage())); } gDAO.destroy(); } else { curContext.addMessage(null, new FacesMessage(FacesMessage.SEVERITY_ERROR, "Failed", "Excel document is not valid!")); } } catch (Exception ex) { curContext.addMessage(null, new FacesMessage(FacesMessage.SEVERITY_ERROR, "Severe", "Please upload an excel document! Error: " + ex.getMessage())); } } else { curContext.addMessage(null, new FacesMessage(FacesMessage.SEVERITY_ERROR, "Failed", "Please upload an excel document!")); } }
From source file:com.dexter.fuelcard.mbean.UserMBean.java
@SuppressWarnings("unchecked") public void buckLoadVehicles() { AuditTrail audit = new AuditTrail(); audit.setPartner(getActiveUser().getPartner()); audit.setAuditTime(new java.util.Date()); audit.setActionPerformed("Batch loading vehicles..."); audit.setEntity("CAR"); audit.setUsername(getActiveUser().getUsername()); Vector<Car> loadedCars = new Vector<Car>(); try {/*from w w w .j a v a 2 s . c om*/ //Get the workbook instance for XLS file HSSFWorkbook workbook = new HSSFWorkbook(getVehiclesFile().getInputstream()); for (int i = 0; i < workbook.getNumberOfSheets(); i++) { //Get current sheet from the workbook HSSFSheet sheet = workbook.getSheetAt(i); //Get iterator to all the rows in current sheet starting from row 2 Iterator<Row> rowIterator = sheet.iterator(); int pos = 1; // reading the contents // column 1 - zonControlId, 2 - regNumber, 3 - fuelType, 4 - username, 5 - cardPan, 6 - region, 7 - dept, 8 - make, 9 - type, 10 - model, 11 - year, 12 - kmpl, 13 - vehicleCapacity, 14 - calibratedCapacity while (rowIterator.hasNext()) { Row row = rowIterator.next(); String zonControlId = "", regNumber = "", fuelType = "", username = ""; String cardPan = "", region = "", dept = "", make = "", type = ""; String model = "", year = "", kmpl = "", vehicleCapacity = "", calibratedCapacity = ""; if (pos > 1) // skip the first row, should be headers { //Get iterator to all cells of current row Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); String val = ""; switch (cell.getCellType()) { case Cell.CELL_TYPE_BLANK: val = ""; break; case Cell.CELL_TYPE_BOOLEAN: val = "" + cell.getBooleanCellValue(); break; case Cell.CELL_TYPE_ERROR: val = ""; break; case Cell.CELL_TYPE_NUMERIC: val = "" + cell.getNumericCellValue(); break; case Cell.CELL_TYPE_STRING: val = cell.getStringCellValue(); break; default: { try { val = cell.getStringCellValue(); } catch (Exception ex) { } break; } } switch (cell.getColumnIndex()) { case 0: zonControlId = val; break; case 1: regNumber = val; break; case 2: fuelType = val; break; case 3: username = val; break; case 4: cardPan = val; break; case 5: region = val; break; case 6: dept = val; break; case 7: make = val; break; case 8: type = val; break; case 9: model = val; break; case 10: year = val; break; case 11: kmpl = val; break; case 12: vehicleCapacity = val; break; case 13: calibratedCapacity = val; break; } } try { Car e = new Car(); e.setCalibratedCapacity( (calibratedCapacity != null) ? Double.parseDouble(calibratedCapacity) : 0); e.setCardPan(cardPan); e.setFuelType(fuelType); e.setPartner(getActiveUser().getPartner()); e.setRegNumber(regNumber); try { e.setVehicleCapacity( (vehicleCapacity != null) ? Double.parseDouble(vehicleCapacity) : 0); } catch (Exception ex) { } try { e.setZonControlId((zonControlId != null) ? Integer.parseInt(zonControlId) : 0); } catch (Exception ex) { } if (username != null) { User u = new UserDAO().getUserByUsername(username, getActiveUser().getPartner().getCode()); if (u != null) { e.setAssigned(true); e.setAssignedUser(u); } } if (region != null) { RegionDAO regDAO = new RegionDAO(); Region reg = regDAO.getRegionByName(region); if (reg == null) { reg = new Region(); reg.setName(region); reg.setPartner(getActiveUser().getPartner()); regDAO.save(reg); } e.setRegion(reg); } if (dept != null) { DepartmentDAO dDAO = new DepartmentDAO(); Department d = dDAO.getDepartmentByName(dept); if (d == null) { d = new Department(); d.setName(dept); d.setPartner(getActiveUser().getPartner()); dDAO.save(d); } e.setDepartment(d); } if (make != null && type != null && model != null) { VehicleMake m = null; VehicleType t = null; VehicleModel md = null; GeneralDAO gDAO = new GeneralDAO(); Hashtable<String, Object> params = new Hashtable<String, Object>(); params.put("name", make); params.put("partner", getActiveUser().getPartner()); Object retObj = gDAO.search("VehicleMake", params); if (retObj != null) { Vector<VehicleMake> retList = (Vector<VehicleMake>) retObj; for (VehicleMake ret : retList) m = ret; } if (m == null) { m = new VehicleMake(); m.setName(make); m.setPartner(getActiveUser().getPartner()); new PlainDAO().save(m); } params = new Hashtable<String, Object>(); params.put("name", type); params.put("partner", getActiveUser().getPartner()); retObj = gDAO.search("VehicleType", params); if (retObj != null) { Vector<VehicleType> retList = (Vector<VehicleType>) retObj; for (VehicleType ret : retList) t = ret; } if (t == null) { t = new VehicleType(); t.setName(type); t.setPartner(getActiveUser().getPartner()); new PlainDAO().save(t); } params = new Hashtable<String, Object>(); params.put("name", model); params.put("make", m); params.put("type", t); params.put("year", year); params.put("partner", getActiveUser().getPartner()); retObj = gDAO.search("VehicleModel", params); if (retObj != null) { Vector<VehicleModel> retList = (Vector<VehicleModel>) retObj; for (VehicleModel ret : retList) md = ret; } if (md == null) { md = new VehicleModel(); md.setName(model); try { md.setKmpl((kmpl != null && kmpl.trim().length() > 0) ? Double.parseDouble(kmpl) : 0); } catch (Exception ex) { } md.setMake(m); md.setType(t); md.setYear(year); md.setPartner(getActiveUser().getPartner()); new PlainDAO().save(md); } e.setModel(md); } loadedCars.add(e); } catch (Exception ig) { } } else pos += 1; } } setAllusers(null); } catch (Exception ex) { ex.printStackTrace(); } audit.setActionPerformed(audit.getActionPerformed() + " Loaded: " + loadedCars.size()); int success = 0, failed = 0; CarDAO cDAO = new CarDAO(); for (Car e : loadedCars) { if (cDAO.createCar(e)) { success += 1; if (e.getCardPan() != null) { Card card = new Card(); card.setCardPan(getVehicle().getCardPan()); card.setCrt_dt(new Date()); new PlainDAO().save(card); } } else failed += 1; } audit.setActionPerformed(audit.getActionPerformed() + " Success: " + success + ", Failed: " + failed); FacesContext curContext = FacesContextImpl.getCurrentInstance(); curContext.addMessage(null, new FacesMessage(FacesMessage.SEVERITY_INFO, "Done", "Loaded: " + loadedCars.size() + ", Success: " + success + ", Failed: " + failed)); new AuditDAO().save(audit); setVehicles(null); }
From source file:com.dexter.fuelcard.mbean.UserMBean.java
public void buckLoadUsers() { AuditTrail audit = new AuditTrail(); audit.setPartner(getActiveUser().getPartner()); audit.setAuditTime(new java.util.Date()); audit.setActionPerformed("Batch loading users..."); audit.setEntity("USER"); audit.setUsername(getActiveUser().getUsername()); Vector<User> loadedUsers = new Vector<User>(); try {//ww w. j a v a 2s . co m /*InputStream inputstream = getUploadItem().getInputstream(); ByteArrayOutputStream fos = new ByteArrayOutputStream(); int read = 0; byte[] bytes = new byte[1024]; while ((read = inputstream.read(bytes)) != -1) { fos.write(bytes, 0, read); } fos.close(); ByteArrayInputStream byteIn = new ByteArrayInputStream(fos.toByteArray());*/ //Get the workbook instance for XLS file HSSFWorkbook workbook = new HSSFWorkbook(getUploadItem().getInputstream()); RoleDAO rDAO = new RoleDAO(); for (int i = 0; i < workbook.getNumberOfSheets(); i++) { //Get current sheet from the workbook HSSFSheet sheet = workbook.getSheetAt(i); //Get iterator to all the rows in current sheet starting from row 2 Iterator<Row> rowIterator = sheet.iterator(); int pos = 1; // reading the contents // column 1 - username, 2 - password, 3 - full name, 4 - role id, 5 - email, 6 - mobile number, 7 - Vehicle Reg Number while (rowIterator.hasNext()) { Row row = rowIterator.next(); String username = "", password = "", fullname = "", email = "", mobile = "", regNumber = ""; long role_id = 0L; if (pos > 1) // skip the first row, should be headers { //Get iterator to all cells of current row Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); String val = ""; switch (cell.getCellType()) { case Cell.CELL_TYPE_BLANK: val = ""; break; case Cell.CELL_TYPE_BOOLEAN: val = "" + cell.getBooleanCellValue(); break; case Cell.CELL_TYPE_ERROR: val = ""; break; case Cell.CELL_TYPE_NUMERIC: val = "" + cell.getNumericCellValue(); break; case Cell.CELL_TYPE_STRING: val = cell.getStringCellValue(); break; default: { try { val = cell.getStringCellValue(); } catch (Exception ex) { } break; } } switch (cell.getColumnIndex()) { case 0: username = val; break; case 1: password = val; break; case 2: fullname = val; break; case 3: try { role_id = Long.parseLong(val); } catch (Exception ex) { ex.printStackTrace(); } break; case 4: email = val; break; case 5: mobile = val; break; case 6: regNumber = val; break; } } try { User e = new User(); e.setUsername(username); e.setPassword(password); e.setFullname(fullname); e.setEmail(email); e.setMobileNumber(mobile); e.setActive(true); e.setRegNumber(regNumber); Role role = rDAO.getRoleById(role_id); if (role != null) { e.setRole(role); loadedUsers.add(e); } } catch (Exception ig) { } } else pos += 1; } } setAllusers(null); } catch (Exception ex) { ex.printStackTrace(); } audit.setActionPerformed(audit.getActionPerformed() + " Loaded: " + loadedUsers.size()); int success = 0, failed = 0; UserDAO uDAO = new UserDAO(); for (User e : loadedUsers) { String ret = uDAO.createUser(e); if (ret.indexOf("Success") >= 0) { success += 1; if (e.getRegNumber() != null) { CarDAO cDAO = new CarDAO(); Car c = cDAO.getCarByRegNumber(e.getRegNumber()); if (c != null) { c.setAssigned(true); c.setAssignedUser(e); cDAO.updateCar(c); } } } else failed += 1; } audit.setActionPerformed(audit.getActionPerformed() + " Success: " + success + ", Failed: " + failed); FacesContext curContext = FacesContextImpl.getCurrentInstance(); curContext.addMessage(null, new FacesMessage(FacesMessage.SEVERITY_INFO, "Done", "Loaded: " + loadedUsers.size() + ", Success: " + success + ", Failed: " + failed)); new AuditDAO().save(audit); setAllusers(null); }
From source file:com.dtrules.compiler.excel.util.ImportRuleSets.java
License:Apache License
/** * Reads the decision table out of an Excel spreadsheet and generates the * approriate XML. //from w w w . ja va2s. c om * @param file * @param sb * @return true if at least one decision table was found in this file * @throws Exception */ public boolean convertDecisionTable(StringBuffer data, File file, XMLPrinter out, int depth) throws Exception { if (!(file.getName().endsWith(".xls"))) return false; InputStream input = new FileInputStream(file.getAbsolutePath()); POIFSFileSystem fs = new POIFSFileSystem(input); HSSFWorkbook wb = new HSSFWorkbook(fs); boolean tablefound = false; CountsAreDirty = false; for (int i = 0; i < wb.getNumberOfSheets(); i++) { tablefound |= convertOneSheet(data, file.getName(), wb.getSheetAt(i), out, depth); } if (CountsAreDirty == true) { System.out.println( "Line Numbers on Contexts, Initial Actions, Conditions, and/or Actions are incorrect.\r\n" + "A Corrected version has been written to the decision table directory"); OutputStream output = new FileOutputStream(file.getAbsolutePath() + ".fixedCounts"); wb.write(output); } else { (new File(file.getAbsolutePath() + ".fixedCounts")).delete(); } return tablefound; }
From source file:com.duroty.lucene.parser.MSExcelParser.java
License:Open Source License
/** * DOCUMENT ME!// w w w . j a va2s. co m * * @return DOCUMENT ME! * * @throws ParserException DOCUMENT ME! */ private String getContents() throws ParserException { String contents = ""; try { POIFSFileSystem fs = new POIFSFileSystem(input); HSSFWorkbook workbook = new HSSFWorkbook(fs); StringBuffer buffer = new StringBuffer(); for (int i = 0; i < workbook.getNumberOfSheets(); i++) { HSSFSheet sheet = workbook.getSheetAt(i); Iterator rows = sheet.rowIterator(); while (rows.hasNext()) { HSSFRow row = (HSSFRow) rows.next(); Iterator cells = row.cellIterator(); while (cells.hasNext()) { HSSFCell cell = (HSSFCell) cells.next(); switch (cell.getCellType()) { case HSSFCell.CELL_TYPE_NUMERIC: String num = Double.toString(cell.getNumericCellValue()).trim(); if (num.length() > 0) { buffer.append(num + " "); } break; case HSSFCell.CELL_TYPE_STRING: String text = cell.getStringCellValue().trim(); if (text.length() > 0) { buffer.append(text + " "); } break; } } buffer.append("\n"); /*if (sleep > 0) { try { Thread.sleep(sleep); } catch (Exception ex) { } }*/ } } contents = buffer.toString(); } catch (Exception ex) { throw new ParserException(ex); } return contents; }
From source file:com.efficio.fieldbook.web.nursery.service.impl.ExcelImportStudyServiceImpl.java
License:Open Source License
private void validateNumberOfSheets(HSSFWorkbook xlsBook) throws WorkbookParserException { if (xlsBook.getNumberOfSheets() != 2) { throw new WorkbookParserException("error.workbook.import.invalidNumberOfSheets"); }/*from w w w .j a v a 2s .co m*/ }
From source file:com.elbeesee.poink.transreptor.HSSFWorkbookToXML.java
License:Open Source License
public void onTransrept(INKFRequestContext aContext) throws Exception { IHSSFWorkbookRepresentation aIHSSFWorkbookRepresentation = (IHSSFWorkbookRepresentation) aContext .sourcePrimary(IHSSFWorkbookRepresentation.class); HSSFWorkbook vWorkbook = aIHSSFWorkbookRepresentation.getWorkbookReadOnly(); StringBuilder vWorkbookXML = new StringBuilder(); int vNumberOfSheets = vWorkbook.getNumberOfSheets(); vWorkbookXML.append("<workbook numSheets=\""); vWorkbookXML.append(vNumberOfSheets); vWorkbookXML.append("\">"); // do the sheets for (int i = 0; i < vNumberOfSheets; i++) { IHSSFSheetRepresentation vHSSFSheetRepresentation = new HSSFSheetImplementation( vWorkbook.getSheetAt(i)); String vSheetXML = aContext.transrept(vHSSFSheetRepresentation, String.class); vWorkbookXML.append(vSheetXML);/*from www .j av a2 s . c o m*/ } // vWorkbookXML.append("</workbook>"); INKFResponse vResponse = aContext.createResponseFrom(vWorkbookXML.toString()); vResponse.setExpiry(INKFResponse.EXPIRY_DEPENDENT); }