Examples of com.extentech.ExtenXLS.WorkSheetHandle

com.extentech.ExtenXLS.WorkSheetHandle
The WorkSheetHandle provides a handle to a Worksheet within an XLS file
and includes convenience methods for working with the Cell values within the sheet.

for example:

WorkBookHandle book = new WorkBookHandle("testxls.xls");
WorkSheetHandle sheet1 = book.getWorkSheet("Sheet1");
CellHandle cell = sheet1.getCell("B22");

to add a cell:

CellHandle cell = sheet1.add("Hello World","C22");

to add a numeric cell:

CellHandle cell = sheet1.add(Integer.valueOf(120),"C23");

to add a formula cell:

CellHandle cell = sheet1.add("=PI()","C24");

@see WorkSheet @see WorkBookHandle @see CellHandle

   * 
   *
   */
  protected void tesSplitCols() {
    try {
      WorkSheetHandle sheet= workbook.getWorkSheet(0);
      sheet.splitCol(5, 5000); // split at col 5 (F), set divider at 1000 col units
    } catch (Exception e) {
      System.out.println("Error setting Split panes: " + e.getMessage());
    }
    writeFile(workbook, "testSplitPanesCol.xls");  
  }

View Full Code Here

   * 
   *
   */
  protected void tesSplitRows() {
    try {
      WorkSheetHandle sheet= workbook.getWorkSheet(0);
      sheet.splitRow(10, 5000); // split at row 10, set divider at 5000 twips
    } catch (Exception e) {
      System.out.println("Error setting Split panes: " + e.getMessage());
    }
    writeFile(workbook,"testSplitPanesRow.xls");    
  }

View Full Code Here

   *
   */
  protected void testFreezePanes() {
    String fileName = "testFreezePanes.xls";
    try {
      WorkSheetHandle sheet= workbook.getWorkSheet(0);
      // try freezing
      sheet.freezeRow(9);
      sheet.freezeCol(17);
    } catch (Exception e) {
      System.out.println("Error setting Freeze panes: " + e.getMessage());
    }
    writeFile(workbook, fileName);    
  }

View Full Code Here

0 1

TOP

Related Classes of com.extentech.ExtenXLS.WorkSheetHandle

com.extentech.formats.XLS.Boundsheet

com.extentech.formats.XLS.charts.Chart

com.extentech.formats.XLS.OOXMLReader

com.extentech.formats.XLS.OOXMLWriter

com.extentech.toolkit.CompatibleVector

docs.samples.CellRanges.TestCellRanges

docs.samples.Compare2Spreadsheets.Compare2Spreadsheets

docs.samples.Formats.TestFormats

docs.samples.Input_Output_CSV.Spreadsheet_CSV_Input

docs.samples.PasswordProtection.testPasswordProtect

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.