excel中的数据读取和删除空行以及从行提取数据从数组列表添加到列表
excel中的数据读取和删除空行以及从行提取数据从数组列表添加到列表
提问于 2019-05-07 21:31:44
如何从数组列表中删除空行和单元格。我使用过myList.removeAll(Arrays.asList(""，null))；这一行确实可以帮助我删除空白单元格。但它仍然会向列表中添加空行。我也可以添加读取所有数据作为行和添加列表作为行。
除了输出为列表行。
[DataGrouping RWAExposureType AA RWA ex 1.06x AA RWA SA RWA, Credit Available For Sale $ 449,454 $ 476,421 $ 264,503,Contingent $ 113,262 $ 120,057 $ 258,508,Total $ 562,715 $ 596,478 $ 523,011, Total $ 562,715 $ 596,478 $ 523,011]读取Excel的代码
ArrayList myList = new ArrayList();
FileInputStream fis = new FileInputStream(System.getProperty("user.dir") + "\\src\\main\\resources\\excelfiles\\Mode Report.xlsx");
XSSFWorkbook wb = new XSSFWorkbook(fis);
CreationHelper creationHelper = wb.getCreationHelper();
// Read sheet inside the workbook by its name
XSSFSheet sh1 = wb.getSheetAt(0);
// Data formatter
DataFormatter formatter = new DataFormatter();
FormulaEvaluator formulaEvaluator = creationHelper.createFormulaEvaluator();
for (Row row : sh1) {
if (row == null) {
}
for (Cell cell : row) {
CellStyle cellStyle = cell.getCellStyle();
String dataFormatString = cellStyle.getDataFormatString();
if (dataFormatString != null && dataFormatString.contains(";"))
cellStyle.setDataFormat(creationHelper.createDataFormat().getFormat(dataFormatString + ";"));
String cellContent = formatter.formatCellValue(cell, formulaEvaluator);
myList.removeAll(Arrays.asList("", null));
myList.add(cellContent);
}
}
System.out.println(myList + "lisi");带有removeAll的OUTput仍从excel中提取空行
[
, Data Grouping, RWA Exposure Type, ( $ M ) AA RWA ex 1.06x, ( $ M ) AA RWA, ( $ M ) SA RWA, Credit, $ 562,715, $ 596,478, $ 523,011, Available For Sale, $ 449,454, $ 476,421, $ 264,503, Contingent, $ 113,262, $ 120,057, $ 258,508, Total, $ 562,715, $ 596,478, $ 523,011, 5/6/2019 2:23:35 PM
, ]lisi不带removeAll的输出。[
, , , , , Data Grouping, RWA Exposure Type, ( $ M ) AA RWA ex 1.06x, ( $ M ) AA RWA, ( $ M ) SA RWA, Credit, , $ 562,715, $ 596,478, $ 523,011, , Available For Sale, $ 449,454, $ 476,421, $ 264,503, , Contingent, $ 113,262, $ 120,057, $ 258,508, Total, , $ 562,715, $ 596,478, $ 523,011, 5/6/2019 2:23:35 PM
, , , , ]lisi预期输出应为
[Data Grouping, RWA Exposure Type, ( $ M ) AA RWA ex 1.06x, ( $ M ) AA RWA, ( $ M ) SA RWA, Credit, $ 562,715, $ 596,478, $ 523,011, Available For Sale, $ 449,454, $ 476,421, $ 264,503, Contingent, $ 113,262, $ 120,057, $ 258,508, Total, $ 562,715, $ 596,478, $ 523,011, 5/6/2019 2:23:35 PM]lisi回答 1
Stack Overflow用户
发布于 2019-05-08 01:51:21
根据来自XtremeBaumer的评论
if(cellContent != null && !cellContent.trim().isEmpty())
myList.add(cellContent);页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/56023822
复制相关文章
相似问题
腾讯云开发者
