Package org.apache.poi.xssf.model

Examples of org.apache.poi.xssf.model.CommentsTable

291
292
293
294
295
296
297
298
299
300
301
                PackageRelationshipCollection commentsRel =
                  part.getRelationshipsByType(SHEET_COMMENTS.REL);
                if(commentsRel != null && commentsRel.size() > 0) {
                  PackagePart commentsPart =
                    getTargetPart(commentsRel.getRelationship(0));
                  comments = new CommentsTable(commentsPart.getInputStream());
                }
               
                // Now create the sheet
                WorksheetDocument worksheetDoc = WorksheetDocument.Factory.parse(part.getInputStream());
                XSSFSheet sheet = new XSSFSheet(ctSheet, worksheetDoc.getWorksheet(), this, comments);
View Full Code Here
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
                workbook.getSheets().getSheetArray(i).setId(rel.getId());
                workbook.getSheets().getSheetArray(i).setSheetId(sheetNumber);
               
                // If our sheet has comments, then write out those
                if(sheet.hasComments()) {
                  CommentsTable ct = (CommentsTable)sheet.getCommentsSourceIfExists();
                    PackagePartName ctName = PackagingURIHelper.createPartName(
                        SHEET_COMMENTS.getFileName(sheetNumber));
                    part.addRelationship(ctName, TargetMode.INTERNAL, SHEET_COMMENTS.getRelation(), "rComments");
                    PackagePart ctPart = pkg.createPart(ctName, SHEET_COMMENTS.getContentType());
                   
                    out = ctPart.getOutputStream();
                    ct.writeTo(out);
                    out.close();
                }
            }
            
            // Write shared strings and styles
View Full Code Here
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
    public void testGetCellComment() {
        XSSFWorkbook workbook = new XSSFWorkbook();
        CTSheet ctSheet = CTSheet.Factory.newInstance();
        CTWorksheet ctWorksheet = CTWorksheet.Factory.newInstance();
        CTComments ctComments = CTComments.Factory.newInstance();
        CommentsTable sheetComments = new CommentsTable(ctComments);
        XSSFSheet sheet = new XSSFSheet(ctSheet, ctWorksheet, workbook, sheetComments);
        assertNotNull(sheet);
       
        CTComment ctComment = ctComments.addNewCommentList().insertNewComment(0);
        ctComment.setRef("C10");
        ctComment.setAuthorId(sheetComments.findAuthor("test C10 author"));
       
        assertNotNull(sheet.getCellComment(9, 2));
        assertEquals("test C10 author", sheet.getCellComment(9, 2).getAuthor());
    }
View Full Code Here
513
514
515
516
517
518
519
520
521
522
523
524
525
        CTSheet ctSheet = CTSheet.Factory.newInstance();
        CTWorksheet ctWorksheet = CTWorksheet.Factory.newInstance();
        XSSFSheet sheet = new XSSFSheet(ctSheet, ctWorksheet, workbook);
        Cell cell = sheet.createRow(0).createCell((short)0);
        CTComments ctComments = CTComments.Factory.newInstance();
        CommentsTable comments = new CommentsTable(ctComments);
        XSSFComment comment = comments.addComment();
       
        sheet.setCellComment("A1", comment);
        assertEquals("A1", ctComments.getCommentList().getCommentArray(0).getRef());
        comment.setAuthor("test A1 author");
        assertEquals("test A1 author", comments.getAuthor(ctComments.getCommentList().getCommentArray(0).getAuthorId()));
    }
View Full Code Here
980
981
982
983
984
985
986
987
988
    this.sheet = sheet;
  }
 
  private CommentsSource getComments() {
    if (sheetComments == null) {
      sheetComments = new CommentsTable();
    }
    return sheetComments;
  }
View Full Code Here
39
40
41
42
43
44
45
46
47
48
49
50
   
  private static final String TEST_RICHTEXTSTRING = "test richtextstring";
  private static final String TEST_AUTHOR = "test_author";

  public void testConstructors() {
    CommentsTable sheetComments = new CommentsTable();
    XSSFComment comment = sheetComments.addComment();
    assertNotNull(comment);
   
    CTComment ctComment = CTComment.Factory.newInstance();
    XSSFComment comment2 = new XSSFComment(sheetComments, ctComment);
    assertNotNull(comment2);
View Full Code Here
49
50
51
52
53
54
55
56
57
58
59
    XSSFComment comment2 = new XSSFComment(sheetComments, ctComment);
    assertNotNull(comment2);
  }
 
  public void testGetColumn() {
    CommentsTable sheetComments = new CommentsTable();
    CTComment ctComment = CTComment.Factory.newInstance();
    ctComment.setRef("A1");
    XSSFComment comment = new XSSFComment(sheetComments, ctComment);
    assertNotNull(comment);
    assertEquals(0, comment.getColumn());
View Full Code Here
60
61
62
63
64
65
66
67
68
69
70
    ctComment.setRef("C10");
    assertEquals(2, comment.getColumn());
  }
 
  public void testGetRow() {
    CommentsTable sheetComments = new CommentsTable();
    CTComment ctComment = CTComment.Factory.newInstance();
    ctComment.setRef("A1");
    XSSFComment comment = new XSSFComment(sheetComments, ctComment);
    assertNotNull(comment);
    assertEquals(0, comment.getRow());
View Full Code Here
77
78
79
80
81
82
83
84
85
86
    CTComment ctComment = ctComments.addNewCommentList().addNewComment();
    CTAuthors ctAuthors = ctComments.addNewAuthors();
    ctAuthors.insertAuthor(0, TEST_AUTHOR);
    ctComment.setAuthorId(0);

    CommentsTable sheetComments = new CommentsTable(ctComments);
    XSSFComment comment = new XSSFComment(sheetComments, ctComment);
    assertNotNull(comment);
    assertEquals(TEST_AUTHOR, comment.getAuthor());
  }
View Full Code Here
84
85
86
87
88
89
90
91
92
93
94
    assertNotNull(comment);
    assertEquals(TEST_AUTHOR, comment.getAuthor());
  }
 
  public void testSetColumn() {
    CommentsTable sheetComments = new CommentsTable();
    CTComment ctComment = CTComment.Factory.newInstance();
    XSSFComment comment = new XSSFComment(sheetComments, ctComment);
    comment.setColumn((short)3);
    assertEquals(3, comment.getColumn());
    assertEquals(3, (new CellReference(ctComment.getRef()).getCol()));
View Full Code Here
TOP

Related Classes of org.apache.poi.xssf.model.CommentsTable

  • org.apache.poi.openxml4j.opc.PackagePart
  • org.apache.poi.ss.util.CellReference
  • org.apache.poi.xssf.eventusermodel.TestXSSFReader
  • org.apache.poi.xssf.eventusermodel.XSSFReader$SheetIterator
  • org.apache.poi.xssf.extractor.XSSFEventBasedExcelExtractor
  • org.apache.poi.xssf.usermodel.TestXSSFCell
  • org.apache.poi.xssf.usermodel.TestXSSFComment
  • org.apache.poi.xssf.usermodel.TestXSSFSheet
  • org.apache.poi.xssf.usermodel.XSSFComment
  • org.apache.poi.xssf.usermodel.XSSFDrawing
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.