Examples of org.apache.poi.hssf.usermodel.HSSFWorkbook.createName()

Class org.apache.poi.hssf.usermodel.HSSFWorkbook

Examples of org.apache.poi.hssf.usermodel.HSSFWorkbook.createName()

org.apache.poi.hssf.usermodel.HSSFWorkbook.createName()
creates a new named range and add it to the model @return named range high level

    assertEquals("Sheet1!$B$3", name.getRefersToFormula());
  }
  public void testFormulaGeneral() {
    // perhaps this testcase belongs on TestHSSFName
    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFName name = wb.createName();
    wb.createSheet("Sheet1");
    name.setNameName("test");
    name.setRefersToFormula("Sheet1!A1+Sheet1!A2");
    assertEquals("Sheet1!A1+Sheet1!A2", name.getRefersToFormula());
    name.setRefersToFormula("5*6");

View Full Code Here

    HSSFSheet s = workbook.createSheet("Foo");
    s.createRow(0).createCell(0).setCellValue(1.1);
    s.createRow(1).createCell(0).setCellValue(2.3);
    s.createRow(2).createCell(2).setCellValue(3.1);


    HSSFName name = workbook.createName();
    name.setNameName("testName");
    name.setRefersToFormula("A1:A2");


    confirmParseFormula(workbook);

View Full Code Here

        HSSFWorkbook wb = new HSSFWorkbook(); //or new XSSFWorkbook();
        HSSFSheet sheet = wb.createSheet("NamesWithUnderscore");


        HSSFName nm;


        nm = wb.createName();
        nm.setNameName("DA6_LEO_WBS_Number");
        nm.setRefersToFormula("33");


        nm = wb.createName();
        nm.setNameName("DA6_LEO_WBS_Name");

View Full Code Here


        nm = wb.createName();
        nm.setNameName("DA6_LEO_WBS_Number");
        nm.setRefersToFormula("33");


        nm = wb.createName();
        nm.setNameName("DA6_LEO_WBS_Name");
        nm.setRefersToFormula("33");


        nm = wb.createName();
        nm.setNameName("A1_");

View Full Code Here


        nm = wb.createName();
        nm.setNameName("DA6_LEO_WBS_Name");
        nm.setRefersToFormula("33");


        nm = wb.createName();
        nm.setNameName("A1_");
        nm.setRefersToFormula("22");


        nm = wb.createName();
        nm.setNameName("_A1");

View Full Code Here


        nm = wb.createName();
        nm.setNameName("A1_");
        nm.setRefersToFormula("22");


        nm = wb.createName();
        nm.setNameName("_A1");
        nm.setRefersToFormula("11");


        nm = wb.createName();
        nm.setNameName("A_1");

View Full Code Here


        nm = wb.createName();
        nm.setNameName("_A1");
        nm.setRefersToFormula("11");


        nm = wb.createName();
        nm.setNameName("A_1");
        nm.setRefersToFormula("44");


        nm = wb.createName();
        nm.setNameName("A_1_");

View Full Code Here


        nm = wb.createName();
        nm.setNameName("A_1");
        nm.setRefersToFormula("44");


        nm = wb.createName();
        nm.setNameName("A_1_");
        nm.setRefersToFormula("44");


        HSSFRow row = sheet.createRow(0);
        HSSFCell cell = row.createCell(0);

View Full Code Here

  }


  public void testNamedRangeThatLooksLikeCell() {
    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet sheet = wb.createSheet("Sheet1");
    HSSFName name = wb.createName();
    name.setRefersToFormula("Sheet1!B1");
    name.setNameName("pfy1");


    Ptg[] ptgs;
    try {

View Full Code Here


  /** Named ranges with backslashes, e.g. 'POI\\2009' */
  public void testBackSlashInNames() {
    HSSFWorkbook wb = new HSSFWorkbook();


    HSSFName name = wb.createName();
    name.setNameName("POI\\2009");
    name.setRefersToFormula("Sheet1!$A$1");


    HSSFSheet sheet = wb.createSheet();
    HSSFRow row = sheet.createRow(0);

View Full Code Here

0 1 2 3 4 5 6 7

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.