Package com.extentech.formats.XLS

Examples of com.extentech.formats.XLS.CellNotFoundException

286
287
288
289
290
291
292
293
294
295
296
   * @return
   */
  public CellHandle getCell(String address)
  throws CellNotFoundException, WorkSheetNotFoundException{
    int shtpos = address.indexOf("!");
    if(shtpos<0)throw new CellNotFoundException(address + " not found.  You need to specify a location in the format: Sheet1!A1");
    String sheetstr = address.substring(0,shtpos);
    WorkSheetHandle sht = this.getWorkSheet(sheetstr);
    String celstr = address.substring(shtpos+1);
    return sht.getCell(celstr);
  }
View Full Code Here
489
490
491
492
493
494
495
496
        @return NameHandle a Named range in the WorkBook
    */
    public NameHandle getNamedRange(String rangename)
    throws CellNotFoundException{
        Name nand = mybook.getName(rangename.toUpperCase());  // case-insensitive
        if(nand == null)throw new CellNotFoundException(rangename);
        return new NameHandle(nand, this);
    }
View Full Code Here
503
504
505
506
507
508
509
510
    *@return NameHandle a Named range in the WorkBook that exists in the scope
*/
public NameHandle getNamedRangeInScope(String rangename)
throws CellNotFoundException{
    Name nand = mybook.getScopedName(rangename);
    if(nand == null)throw new CellNotFoundException(rangename);
    return new NameHandle(nand, this);
}
View Full Code Here
TOP

Related Classes of com.extentech.formats.XLS.CellNotFoundException

  • com.extentech.ExtenXLS.WorkBookHandle
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.