Examples of org.jsoup.nodes.Element.select()

org.jsoup.nodes.Element.select()
Find elements that match the {@link Selector} query, with this element as the starting context. Matched elementsmay include this element, or any of its children.
This method is generally more powerful to use than the DOM-type {@code getElementBy*} methods, becausemultiple filters can be combined, e.g.:
- {@code el.select("a[href]")} - finds links ({@code a} tags with {@code href} attributes)
- {@code el.select("a[href*=example.com]")} - finds links pointing to example.com (loosely)
See the query syntax documentation in {@link org.jsoup.select.Selector}. @param query a {@link Selector} query @return elements that match the query (empty if none match) @see org.jsoup.select.Selector

  }
  
  public int getNumberOfRows(int sheet){
    if(sheet<getNumberOfSheets()){
      Element table = tables.get(sheet);
      return table.select("tr").size();
    }
    return 0;
  }
  
  public int getNumberOfColumns(int sheet){

View Full Code Here

  }
  
  public int getNumberOfColumns(int sheet){
    if(sheet<getNumberOfSheets()){
      Element table = tables.get(sheet);
      Elements trs = table.select("tr");
      if(trs.size()>0){
        Element tr = trs.get(0);
        return tr.select("td").size();
      }
    }

View Full Code Here

    if(sheet<getNumberOfSheets()){
      Element table = tables.get(sheet);
      Elements trs = table.select("tr");
      if(trs.size()>0){
        Element tr = trs.get(0);
        return tr.select("td").size();
      }
    }
    return 0;
  }

View Full Code Here

  }
  
  public boolean setCellValue(int sheetNumber,int row,int column,String value){
    if(sheetNumber<getNumberOfSheets()){
      Element table = tables.get(sheetNumber);
      Elements trs = table.select("tr");
      if(row<trs.size()){
        Element tr = trs.get(row);
        Elements tds = tr.select("td");
        if(column<tds.size()){
          Element td = tds.get(column);

View Full Code Here

    if(sheetNumber<getNumberOfSheets()){
      Element table = tables.get(sheetNumber);
      Elements trs = table.select("tr");
      if(row<trs.size()){
        Element tr = trs.get(row);
        Elements tds = tr.select("td");
        if(column<tds.size()){
          Element td = tds.get(column);
          if(td!=null){
            td.html(value);
            return true;

View Full Code Here

            trHeight = tdHeight;
          }
          /**!
           * 处理生成的HTML的颜色的问题
           */
          Elements fonts = td.select("font");
          if(fonts.size()==0){
            css(td,"font-size","1.64em");
          }
          for(int fonti=0;fonti<fonts.size();fonti++){
            Element font = fonts.get(fonti);

View Full Code Here

      }else{
        name2Sheet.put("Spread Sheet"+i, sheet);
        name2SheetIndex.put("Spread Sheet"+i, i);
        index2SheetName.put(i, "Spread Sheet"+i);
      }
      Elements rows = sheet.select("tr");
      sheetRows.add(rows);
      List<Elements> sheetRowCell = new ArrayList<Elements>(); 
      for(int j=0;j<rows.size();j++){
        Element row = rows.get(j);
        Elements cells = row.select("td");

View Full Code Here

      Elements rows = sheet.select("tr");
      sheetRows.add(rows);
      List<Elements> sheetRowCell = new ArrayList<Elements>(); 
      for(int j=0;j<rows.size();j++){
        Element row = rows.get(j);
        Elements cells = row.select("td");
        sheetRowCell.add(cells);
      }
      sheetRowCells.add(sheetRowCell);
    }
  }

View Full Code Here

    
    
    Elements sheets = doc.select("table");
    for(int si=0;si<sheets.size();si++){
      Element sheet = sheets.get(si);
      Elements rows = sheet.select("tbody tr");
      for(int ri=0;ri<rows.size();ri++){
        Element row = rows.get(ri);
        Elements cells = row.select("td");
        for(int ci=0;ci<cells.size();ci++){
          Element cell = cells.get(ci);

View Full Code Here

    for(int si=0;si<sheets.size();si++){
      Element sheet = sheets.get(si);
      Elements rows = sheet.select("tbody tr");
      for(int ri=0;ri<rows.size();ri++){
        Element row = rows.get(ri);
        Elements cells = row.select("td");
        for(int ci=0;ci<cells.size();ci++){
          Element cell = cells.get(ci);
//          System.out.println(cell.toString());
          if(!org.apache.commons.lang.StringUtils.isBlank(cell.text())){
            if(cell.hasAttr("formula")){

View Full Code Here

0 1 2 3 4 5 6

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.