private void processWorksheet(Element node) throws FHIRException { Sheet sheet = new Sheet(); sheet.title = node.getAttributeNS(XLS_NS, "Name"); sheets.put(node.getAttributeNS(XLS_NS, "Name"), sheet); NodeList table = node.getElementsByTagNameNS(XLS_NS, "Table"); check(table.getLength() == 1, "multiple table elements"); NodeList rows = ((Element)table.item(0)).getElementsByTagNameNS(XLS_NS, "Row"); if (rows.getLength() == 0) return; rowIndex = 1; sheet.columns = readRow((Element) rows.item(0)); for (int i = 1; i < rows.getLength(); i++) { rowIndex++; sheet.rows.add(readRow((Element) rows.item(i))); } //Remove empty rows at the end of the sheet while( sheet.rows.size() != 0 && isEmptyRow(sheet.rows.get(sheet.rows.size()-1) ) ) sheet.rows.remove(sheet.rows.size()-1); }
private void processWorksheet(Element node) throws FHIRException { Sheet sheet = new Sheet(); sheet.title = node.getAttributeNS(XLS_NS, "Name"); sheets.put(node.getAttributeNS(XLS_NS, "Name"), sheet); NodeList table = node.getElementsByTagNameNS(XLS_NS, "Table"); check(table.getLength() == 1, "multiple table elements"); NodeList rows = ((Element)table.item(0)).getElementsByTagNameNS(XLS_NS, "Row"); if (rows.getLength() == 0) return; rowIndex = 1; sheet.columns = readRow((Element) rows.item(0)); for (int i = 1; i < rows.getLength(); i++) { rowIndex++; sheet.rows.add(readRow((Element) rows.item(i))); } //Remove empty rows at the end of the sheet while( sheet.rows.size() != 0 && isEmptyRow(sheet.rows.get(sheet.rows.size()-1) ) ) sheet.rows.remove(sheet.rows.size()-1); }