如何使用apache poi读取xlsx类型的excel文件的单元格内容?

也请查看 Apache PoI快速指南，以获取提供的Cell Comment示例It seems I'm in a bit of a pickle, I read various topics about read xls files with hssf but I can't seem to find good xssf tutorials and it's really hard since they have different statements. My code is supposed to read the row 2, column 2 but I get a "getContents() is undefined for the type XSSFComment" errorMy code goes something like: import java.io.FileOutputStream;import java.io.IOException;import java.io.InputStream;import org.apache.poi.xssf.usermodel.XSSFCell;import org.apache.poi.xssf.usermodel.XSSFRow;import org.apache.poi.xssf.usermodel.XSSFSheet;import org.apache.poi.xssf.usermodel.XSSFWorkbook;public class parsing{public static void main(String[] args) throws IOException {InputStream ExcelFileToRead = new FileInputStream("C:/test.xlsx");XSSFWorkbook wb = new XSSFWorkbook(ExcelFileToRead);XSSFSheet sh = wb.getSheetAt(0);System.out.println(sh.getCellComment(1,1).getContents());}}Error:Exception in thread "main" java.lang.Error: Unresolved compilation problem: The method getContents() is undefined for the type XSSFComment at parsing.main(parsing.java:18) 解决方案 As per the documentation of latest Apache POI the class XSSFComment doesn't have getContents() method at all.Instead try to use getString() method to get the Comment content. Check the documentation of Apache POI XSSFCommentAlso check Apache PoI Quick Guide for the Cell Comment example provided. 这篇关于如何使用apache poi读取xlsx类型的excel文件的单元格内容?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！ 上岸，阿里云！