Example usage for org.apache.poi.hssf.usermodel HSSFWorkbook getName

Introduction

In this page you can find the example usage for org.apache.poi.hssf.usermodel HSSFWorkbook getName.

Prototype

@Override
    public HSSFName getName(String name) 

Source Link

Usage

From source file:com.wetts.base.utils.poi.excel.ExcelDao.java

License:Open Source License

/**
 * ??//from w  w w  . j  a va2s  . co m
 *
 * @param wb
 * @param name
 * @param expression
 * @return
 */
public static HSSFName createName(HSSFWorkbook wb, String name, String expression) {
    HSSFName refer = wb.getName(name);
    //?????
    if (refer == null) {
        refer = wb.createName();
        refer.setNameName(name);
    }
    //???
    refer.setRefersToFormula(expression);
    return refer;
}

---

From source file:org.jxstar.report.studio.ExportStatBO.java

/**
 * excle???????//w w  w . j av  a2  s .c  om
 * s1y=OFFSET(Sheet1!$C$3,0,0,COUNTA(Sheet1!C:C)-1,1) -- 
 * s2y=OFFSET(Sheet1!$B$3,0,0,COUNTA(Sheet1!B:B)-1,1) -- 
 * @param titles -- 
 * @param chars -- 
 * @param nums -- 
 * @param wb -- 
 * @return
 */
private boolean updateChartName(String[] titles, String chars, String nums, HSSFWorkbook wb) {
    //?1???1
    char x_no = 'B', y_no = 'C';
    for (int i = 0, n = titles.length; i < n; i++) {
        if (chars.equals(titles[i])) {
            x_no = (char) (65 + i + 1);
        } else if (nums.equals(titles[i])) {
            y_no = (char) (65 + i + 1);
        }
    }

    //?????
    HSSFName s1y = wb.getName("s1y");
    HSSFName s2y = wb.getName("s2y");
    if (s1y == null || s2y == null) {
        _log.showWarn("chart tpl HSSFName s1y is null or s2y is null!!");
        return false;
    }

    _log.showDebug(".............x_no=" + x_no + ";y_no=" + y_no);
    s1y.setRefersToFormula("OFFSET(Sheet1!$" + y_no + "$3,0,0,COUNTA(Sheet1!" + y_no + ":" + y_no + ")-1,1)");
    s2y.setRefersToFormula("OFFSET(Sheet1!$" + x_no + "$3,0,0,COUNTA(Sheet1!" + x_no + ":" + x_no + ")-1,1)");

    return true;
}

---