Java。HSSF。Apache-poi。如何修改代码

小编典典

Java。HSSF。Apache-poi。如何修改代码

java

我的数据以以下格式存储（向下看）：[-]表示空白单元格，右边可能只有10列（空格后）。像这样的东西：
[string0] [-] [string1] [string2] [string3] .. [string10] [-]

如何为以下代码更改此代码：

1）仅获取[string0]

2）仅获取[string1] [string2] [string3] .. [string10] [-]

    try {

    FileInputStream file = new FileInputStream("C:\\Users\\student3\\"+sfilename+".xls");

    //Get the workbook instance for XLS file
    HSSFWorkbook workbook = new HSSFWorkbook(file);

    //Get first sheet from the workbook
    HSSFSheet sheet = workbook.getSheetAt(0);

    //Iterate through each rows from first sheet
    Iterator<Row> rowIterator = sheet.iterator();
    while(rowIterator.hasNext()) {
        Row row = rowIterator.next();

        //For each row, iterate through each columns
        Iterator<Cell> cellIterator = row.cellIterator();
        while(cellIterator.hasNext()) {

            Cell cell = cellIterator.next();

            switch(cell.getCellType()) {
                case Cell.CELL_TYPE_STRING:
                    System.out.print(cell.getStringCellValue() + "\t\t");
                    list1.add(cell.getStringCellValue());
                    break;
            }
        }
        System.out.println("");
    }
    file.close();
    FileOutputStream out =
            new FileOutputStream("C:\\Users\\student3\\"+sfilename+".xls");
    workbook.write(out);
    out.close();

我不知道如何停止Iterator。他吸收了所有..

阅读 278

2020-11-30

共1个答案

小编典典

如果我很清楚，您只想过滤您的第一列字符串，然后单独休息。

为什么不为此使用一个简单的计数器：

 while(rowIterator.hasNext()) {
    Row row = rowIterator.next();
    String RowContent = null;
    Iterator<Cell> cellIterator = row.cellIterator();
    while(cellIterator.hasNext()) {
        Cell cell = cellIterator.next();
        RowContent=RowContent+cell.toString();
    }
    //Code for saving RowContent or printing or whatever you want for text in complete row
}

RowContent将在每次迭代中串联单个行的每个单元格。

2020-11-30