如何使用apache poi读取xlsx类型的excel文件的单元格内容? [英] How do I read the cell contents using apache poi for xlsx type of excel file?

问题描述

似乎我有点烦，我阅读了有关使用hssf读取xls文件的各种主题，但是我似乎找不到很好的xssf教程，因为它们有不同的陈述，所以这真的很难.我的代码应该读取第2行，第2列，但出现类型XSSFComment的getContents()未定义"错误

我的代码类似于:

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()); 
} 
}

错误:

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)

解决方案

根据最新的Apache POI文档，类XSSFComment根本没有getContents()方法.

相反，请尝试使用getString()方法来获取Comment内容.查看 Apache POI XSSFComment 的文档

也请查看 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" error

My 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 XSSFComment

Also check Apache PoI Quick Guide for the Cell Comment example provided.

这篇关于如何使用apache poi读取xlsx类型的excel文件的单元格内容?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！