Examples of com.extentech.ExtenXLS.CommentHandle

com.extentech.ExtenXLS.CommentHandle

 CommentHandle allows for manipulation of the Note or Comment feature of Excel In order to create CommentHandles programatically use the methods in WorkSheetHandle or CellHandle

          sheet.add("Cell D2", "D2");
          CellHandle cell = sheet.add("Cell F7", "F7");
          // add a note to cell A1, specifying note text and author name
          sheet.createNote("A1", "This is a note attached to Cell A1", "cagney");
          // add a note to cell D2, specifying note text and author name
          CommentHandle nh= sheet.createNote("D2", "this is a note attached to D2\nshown", "maya");
          nh.show();  // make note at D2 always shown  
          cell.createComment("Another Note attached to F7.  This is very very long\nMultiLine\nRambling ...", "elmer");
          book.write(workingdir + "testAddNotesOUT.xls");
      }catch(Exception e) {
      Logger.logInfo(e.toString());
      }

View Full Code Here

        try {
            sheet = book.getWorkSheet(0);
            // create and modify a CommentHandle 
            CellHandle cell = sheet.add("Cell A1", "A1");
            // CommentHandle can be used to manipulate comments
            CommentHandle comment = cell.createComment("This is my comment", "noteAuthor");
            comment.setAuthor("newAuthor");
            comment.setCommentText("New comment text");            
            // retrieve CommentHandle from a worksheet and delete it.
            comment = null;
            comment = cell.getComment();
            cell.removeComment();

View Full Code Here

    try {
      sheet= book.getWorkSheet(0);
      sheet.add("CellA1", "A1");
      String noteTextWithFormats= "<f=\"Tahoma\";b;sz=\"14\">Note: <f=\"Tahoma\";i;sz=\"10\">Testing: <f=\"Tahoma\";u;sz=\"10\">A new note for A1";
      String noteTextWithoutFormats= "Note: Testing: A new note for A1";
      CommentHandle nh= sheet.createNote("A1", noteTextWithFormats, "an author");
          if (!noteTextWithoutFormats.equals(nh.getCommentText()))
            Logger.logInfo("Note text does not equal expected");
          book.write(workingdir + outputfile);        
    } catch (Exception e) {
      Logger.logInfo(e.toString());
      }

View Full Code Here

TOP

Related Classes of com.extentech.ExtenXLS.CommentHandle

docs.samples.Comments.TestComments

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.