第1个回答 2013-09-17
HSSFWorkbook wb = null;
POIFSFileSystem fs = null;
try {
fs = new POIFSFileSystem(new FileInputStream("e:\\workbook.xls"));
wb = new HSSFWorkbook(fs);
} catch (IOException e) {
e.printStackTrace();
}
HSSFSheet sheet = wb.getSheetAt(0);
HSSFRow row = sheet.getRow(0);
HSSFCell cell = row.getCell(0);
String msg = cell.getStringCellValue();
System.out.println(msg);追问
POIFSFileSystem fs = null;
try {
fs = new POIFSFileSystem(new FileInputStream("e:\\workbook.xls"));
wb = new HSSFWorkbook(fs);
} catch (IOException e) {
e.printStackTrace();
}
HSSFSheet sheet = wb.getSheetAt(0);
HSSFRow row = sheet.getRow(0);
HSSFCell cell = row.getCell(0);
String msg = cell.getStringCellValue();
System.out.println(msg);追问
你这个是取得里边数据 不是批注，还是谢谢你了
第2个回答 2013-09-17
调用 HSSFCell.getCellComment()追问
为什么打印是这个格式org.apache.poi.xssf.usermodel.XSSFComment@115bce4
追答哦，那你就是用XSSFWorkbook，读的是xlsx文件，读出来的sheet是XSSFSheet，单元格是XSSFCell，注释是XSSFComment
用HSSFWorkbook，读的是xls文件，读出来的sheet是HSSFSheet，单元格是HSSFCell，注释是HSSFComment
相似回答