How to extract comment text from excel spreadsheet in Java

Aspose.Cells Product Family
,
1

Hi,
I want to extract text and image from excel, but I found that comment text can’t be extracted. As excel below, I add comment in column “First Name”. Is there any way I can extract comment text?
新建文件夹.zip (106.8 KB)

2

@lucy.hq,

How do you extract comments from the sheet? See the following sample code on how to extract comment text for your reference.
e.g.
Sample code:

Workbook workbook  =  new Workbook("Book1.xlsx");
Worksheet worksheet = workbook.getWorksheets().get(0);
            CommentCollection comments = worksheet.getComments();

            for (int i = 0; i < comments.getCount(); i++) {
                Comment comment = comments.get(i);

                System.out.println("comment " + comment.getNote()); 
            }

Let us know if you still have any confusion or issue.