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

  }


  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

  public void testParseComplexName() {


    // Mock up a spreadsheet to match the critical details of the sample
    HSSFWorkbook wb = new HSSFWorkbook();
    wb.createSheet("Sheet1");
    HSSFName definedName = wb.createName();
    definedName.setNameName("foo");
    definedName.setRefersToFormula("Sheet1!B2");


    // Set the complex flag - POI doesn't usually manipulate this flag
    NameRecord nameRec = TestHSSFName.getNameRecord(definedName);

View Full Code Here

      throw new AssertionFailedError("Identified bug 47312c - '"
          + leadingZeroCellRef + "' should parse as 'B1'.");
    }


    // create a defined name called 'B0' and try again
    Name n = wb.createName();
    n.setNameName("B0");
    n.setRefersToFormula("1+1");
    ptgs = HSSFFormulaParser.parse("B0", wb);
    confirmTokenClasses(ptgs, NamePtg.class);
  }

View Full Code Here

    if (false) {
      // TODO - this code won't work until we can create user-defined functions directly with POI
      wb = new HSSFWorkbook();
      sheet = wb.createSheet();
      wb.setSheetName(0, "Sheet1");
      HSSFName hssfName = wb.createName();
      hssfName.setNameName("myFunc");
      
    } else {
      // This sample spreadsheet already has a VB function called 'myFunc'
      wb = HSSFTestDataSamples.openSampleWorkbook("testNames.xls");

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

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.