cvs commit: jakarta-poi/src/testcases/org/apache/poi/hssf/usermodel TestNamedRange.java

[acoliver]

acoliver    02/04/27 06:18:57

  Added:       src/testcases/org/apache/poi/hssf/usermodel
                        TestNamedRange.java
  Log:
  Committed Libin's named range test.  Made some rather significant changes to it.
  
  Revision  Changes    Path
  1.1                  
jakarta-poi/src/testcases/org/apache/poi/hssf/usermodel/TestNamedRange.java
  
  Index: TestNamedRange.java
  ===================================================================
  /*
   * RangeTestTest.java
   * NetBeans JUnit based test
   *
   * Created on April 21, 2002, 6:23 PM
   */
  
  package org.apache.poi.hssf.usermodel;
  
  import junit.framework.*;
  
  import org.apache.poi.poifs.filesystem.POIFSFileSystem;
  
  import java.io.File;
  import java.io.FileInputStream;
  import java.io.FileNotFoundException;
  import java.io.FileOutputStream;
  import java.io.IOException;
  
  
  /**
   * 
   * @author ROMANL
   * @author Andrew C. Oliver (acoliver at apache dot org)
   */
  public class TestNamedRange
      extends TestCase {
      
      public TestNamedRange(String testName) {
          super(testName);
      }
      
      public static void main(java.lang.String[] args) {
          String filename = System.getProperty("HSSF.testdata.path");
          
          // assume andy is running this in the debugger
          if (filename == null)
          {
              if (args != null && args.length == 1) {
              System.setProperty(
                  "HSSF.testdata.path",
                  args[0]);
              } else {
                  System.err.println("Geesh, no HSSF.testdata.path system " +
                            "property, no command line arg with the path "+
                            "what do you expect me to do, guess where teh data " +
                            "files are?  Sorry, I give up!");
                                     
              }
              
          }
          
          
          junit.textui.TestRunner.run(TestNamedRange.class);
      }
      
      /** Test of TestCase method, of class test.RangeTest. */
      public void testNamedRange() 
          throws IOException
      {
          FileInputStream fis = null;
          POIFSFileSystem fs  = null;
          HSSFWorkbook wb     = null;
          
          System.out.println("testTestCase");
          
          String filename = System.getProperty("HSSF.testdata.path");
  
          filename = filename + "/Simple.xls";
          
          
              fis = new FileInputStream(filename);
              fs = new POIFSFileSystem(fis);
              wb = new HSSFWorkbook(fs);
          
          
          //Creating new Named Range
          HSSFName newNamedRange = wb.createName();
          
          //Getting Sheet Name for the reference
          String sheetName = wb.getSheetName(0);
          
          //Setting its name
          newNamedRange.setNameName("RangeTest");
          //Setting its reference
          newNamedRange.setReference(sheetName + ".$D$4:$E$8");
    
          //Getting NAmed Range
          HSSFName namedRange1 = wb.getNameAt(0);
          //Getting it sheet name
          sheetName = namedRange1.getSheetName();
          //Getting its reference
          String referece = namedRange1.getReference();
                                 
          File             file = File.createTempFile("testNamedRange",
                                          ".xls");
  
          FileOutputStream fileOut = new FileOutputStream(file);
          wb.write(fileOut);
          fis.close();
          fileOut.close();
      }
          
  }