java - 在Excel中查找列中的单元格数量

Question

我想从 Excel 文件中查找列中的内容数。

示例

Location Device Second
1         A      10
2         B       20
3                 30

现在，我希望它应该显示，地点:3设备:2第二:3

我正在使用jxl。

 Workbook existingWorkbook = Workbook.getWorkbook(new File(filename1));
        WritableWorkbook workbookCopy = Workbook.createWorkbook(new File(filename1), existingWorkbook);
        WritableSheet sheetToEdit = workbookCopy.getSheet(0);

     int n=   sheetToEdit.getcolumns();
     System.out.println(n);

        workbookCopy.write();
        workbookCopy.close();

在这里，我只得到列数，

你能告诉我，我该怎么做吗？

Answer 1

我认为除了手动计数和确定空单元格之外，没有直接的方法可以做到这一点:

Workbook existingWorkbook = Workbook.getWorkbook(new File(filename1));
WritableWorkbook workbookCopy = Workbook.createWorkbook(new File(filename1), existingWorkbook);
WritableSheet sheetToEdit = workbookCopy.getSheet(0);

for (int i=0; i<sheetToEdit.getcolumns(); i++) {
    int columnCount = 0;
    for (Cell cell : sheetToEdit.getColumn(i))
        if (!cell.getContents().equals(""))
            columnCount++;
    System.out.println(columnCount);
}

workbookCopy.write();
workbookCopy.close();