Examples of HSSFSheet

com.dotcms.repackage.org.apache.poi.hssf.usermodel.HSSFSheet
org.apache.poi.hssf.usermodel.HSSFSheet
High level representation of a worksheet. @author Andrew C. Oliver (acoliver at apache dot org) @author Glen Stampoultzis (glens at apache.org) @author Libin Roman (romal at vistaportal.com) @author Shawn Laubach (slaubach at apache dot org) (Just a little) @author Jean-Pierre Paris (jean-pierre.paris at m4x dot org) (Just a little, too) @author Yegor Kozlov (yegor at apache.org) (Autosizing columns)
org.zkoss.poi.hssf.usermodel.HSSFSheet

Examples of org.apache.poi.hssf.usermodel.HSSFSheet

  public static void export2SimpleExcel(String sheetName,
      String[] columnPropterties, String[] columnNames, List<?> list,
      OutputStream out) throws IOException
  {
    wb = new HSSFWorkbook();
    HSSFSheet sheet = wb.createSheet(sheetName);
    // 创建第1行，也就是输出表头
    HSSFRow row = sheet.createRow(0);
    HSSFCell cell;
    for (int i = 0; i < columnNames.length; i++)
    {
      cell = row.createCell(i);
      cell.setCellValue(new HSSFRichTextString(columnNames[i]));
    }
    // 下面是输出各行的数据
    for (int i = 0; i < list.size(); i++)
    {
      row = sheet.createRow(i + 1);
      Object o = list.get(i);
      for (int j = 0; j < columnPropterties.length; j++)
      {
        cell = row.createCell(j);
        Object obj = ReflectionUtils.invokeGetterMethod(o, columnPropterties[j]);

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFSheet

     * Tests reading a file containing this ptg.
     */
    public void testReading() throws Exception
    {
        HSSFWorkbook workbook = loadWorkbook("PercentPtg.xls");
        HSSFSheet sheet = workbook.getSheetAt(0);


        assertEquals("Wrong numeric value for original number", 53000.0,
                     sheet.getRow(0).getCell((short) 0).getNumericCellValue(), 0.0);
        assertEquals("Wrong numeric value for percent formula result", 5300.0,
                     sheet.getRow(1).getCell((short) 0).getNumericCellValue(), 0.0);
        assertEquals("Wrong formula string for percent formula", "A1*10%",
                     sheet.getRow(1).getCell((short) 0).getCellFormula());
    }

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFSheet

    {
        File file = new File( _test_file_path + File.separator + "duprich1.xls" );
        InputStream stream = new FileInputStream( file );
        HSSFWorkbook wb = new HSSFWorkbook( stream );
        stream.close();
        HSSFSheet sheet = wb.getSheetAt( 1 );
        assertEquals( "01/05 (Wed)", sheet.getRow( 0 ).getCell( (short) 8 ).getStringCellValue() );
        assertEquals( "01/05 (Wed)", sheet.getRow( 1 ).getCell( (short) 8 ).getStringCellValue() );


        file = TempFile.createTempFile( "testout", "xls" );
        FileOutputStream outStream = new FileOutputStream( file );
        wb.write( outStream );
        outStream.close();
        file.delete();


        // test the second file.
        file = new File( _test_file_path + File.separator + "duprich2.xls" );
        stream = new FileInputStream( file );
        wb = new HSSFWorkbook( stream );
        stream.close();
        sheet = wb.getSheetAt( 0 );
        int row = 0;
        assertEquals( "Testing", sheet.getRow( row++ ).getCell( (short) 0 ).getStringCellValue() );
        assertEquals( "rich", sheet.getRow( row++ ).getCell( (short) 0 ).getStringCellValue() );
        assertEquals( "text", sheet.getRow( row++ ).getCell( (short) 0 ).getStringCellValue() );
        assertEquals( "strings", sheet.getRow( row++ ).getCell( (short) 0 ).getStringCellValue() );
        assertEquals( "Testing", sheet.getRow( row++ ).getCell( (short) 0 ).getStringCellValue() );
        assertEquals( "Testing", sheet.getRow( row++ ).getCell( (short) 0 ).getStringCellValue() );


//        file = new File("/tryme.xls");
        file = TempFile.createTempFile( "testout", ".xls" );
        outStream = new FileOutputStream( file );
        wb.write( outStream );

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFSheet

      HSSFWorkbook wb = new HSSFWorkbook();
      
      wb.createSheet("NoQuotesNeeded");
      wb.createSheet("Quotes Needed Here &#$@");
      
      HSSFSheet sheet = wb.createSheet("Test");
      HSSFRow row = sheet.createRow(0);
      HSSFCell cell;
      
      cell = row.createCell((short)0);
      cell.setCellFormula("NoQuotesNeeded!A1");

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFSheet

  public void testUnderscore() {
    HSSFWorkbook wb = new HSSFWorkbook();
      
      wb.createSheet("Cash_Flow");;
      
      HSSFSheet sheet = wb.createSheet("Test");
      HSSFRow row = sheet.createRow(0);
      HSSFCell cell;
      
      cell = row.createCell((short)0);
      cell.setCellFormula("Cash_Flow!A1");

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFSheet

    public void testExponentialInSheet() throws Exception {
        HSSFWorkbook wb = new HSSFWorkbook();


        wb.createSheet("Cash_Flow");;


        HSSFSheet sheet = wb.createSheet("Test");
        HSSFRow row = sheet.createRow(0);
        HSSFCell cell = row.createCell((short)0);
        String formula = null;


        cell.setCellFormula("1.3E21/3");
        formula = cell.getCellFormula();

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFSheet

    /**
     * Sets up a test file
     */
    private ByteArrayOutputStream setupRunFile(HSSFWorkbook book) throws Exception {
        ByteArrayOutputStream stream = new ByteArrayOutputStream();
        HSSFSheet sheet = book.createSheet("Test");
        HSSFRow   row   = sheet.createRow(0);
        HSSFCell  cell  = row.createCell((short)0);
        cell.setCellValue(10.5);
        book.write(stream);
        return stream;
    }

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFSheet

    HSSFWorkbook wb = new HSSFWorkbook();


    wb.createSheet("NoQuotesNeeded");
    wb.createSheet("Quotes Needed Here &#$@");


    HSSFSheet sheet = wb.createSheet("Test");
    HSSFRow row = sheet.createRow(0);
    HSSFCell cell;


    cell = row.createCell((short)0);
    cell.setCellFormula("NoQuotesNeeded!A1");

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFSheet

  public void testUnderscore() {
    HSSFWorkbook wb = new HSSFWorkbook();


    wb.createSheet("Cash_Flow");


    HSSFSheet sheet = wb.createSheet("Test");
    HSSFRow row = sheet.createRow(0);
    HSSFCell cell;


    cell = row.createCell((short)0);
    cell.setCellFormula("Cash_Flow!A1");
  }

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFSheet

  public void testExponentialInSheet() {
    HSSFWorkbook wb = new HSSFWorkbook();


    wb.createSheet("Cash_Flow");


    HSSFSheet sheet = wb.createSheet("Test");
    HSSFRow row = sheet.createRow(0);
    HSSFCell cell = row.createCell((short)0);
    String formula = null;


    cell.setCellFormula("1.3E21/3");
    formula = cell.getCellFormula();

View Full Code Here

0 1 2 3 4 5

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.