您好,我试用的是java版的。
Worksheet有saveToFile方法,可以直接把sheet保存成txt文件。
但是我不想保存成txt文件,我只想在代码中获取到String对象,有这样的方法吗?
Workbook workbook = new Workbook();
// 加载文档
workbook.loadFromFile("test.xlsx");
Worksheet worksheet = workbook.getWorksheets().get(0);
// 遍历所有单元格
for (int i = 1; i <= worksheet.getLastRow(); i++) {
for (int j = 1; j <= worksheet.getLastColumn(); j++) {
CellRange range = worksheet.getRange().get(i, j);
// 获取到单元格实际显示的文本
String displayedText = range.getDisplayedText();
}
}
Workbook workbook = new Workbook();
// 加载文档
workbook.loadFromFile("test.xlsx");
Worksheet worksheet = workbook.getWorksheets().get(0);
// 将sheet保存为流
ByteArrayOutputStream byteArrayOutputStream = new ByteArrayOutputStream();
worksheet.saveToStream(byteArrayOutputStream, " ");
// 从流中读取字符串
String text = null;
try {
text = new String(byteArrayOutputStream.toByteArray(), "UTF-8");
} catch (UnsupportedEncodingException e) {
e.printStackTrace();
}
byteArrayOutputStream.close();