如何在 Java 上的 JTable 中填充一些 Excel 行? [英] How to fill some rows of Excel in a JTable on Java?

问题描述

我正在将数据从 Excel 文件导入 Java JTable.我可以导入所有工作表，但我只想导入 一些 行.这是我用来导入工作表的代码:

I'm working on importing data from an Excel file into a Java JTable. I can import all the sheet, but I want to import only some rows. This is the code I'm using to import the sheet:

 private void remplirtable(JTable table, int numfeuil,String s) {

        Workbook wb;
        File fichier = new File(s);
        try {
            //création de la table et importation du fichier
                    wb = Workbook.getWorkbook(fichier);
            Sheet sheet = wb.getSheet(numfeuil);
            String[] columnsnames=new String[sheet.getColumns()];
            DefaultTableModel model = new DefaultTableModel();
            //Remplir la table désignée
                        table.setModel(model);
            int colonnes = sheet.getColumns();
            int lignes = sheet.getRows();
            Object data[] = new Object[colonnes];
            for (int i=0; i<lignes; i++){
                for (int j=0; j<colonnes; j++){
                if (i==0)
                    {
                        //Component c=super.prepareRenderer(renderer, j, i);
                        model.addColumn(sheet.getCell(j,i).getContents());

                    }
                    //System.out.println(sheet.getCell(j,i).getContents());
                    if(i>=1)
                        data[j]=sheet.getCell(j,i).getContents();

                }model.addRow(data);
            }model.removeRow(0);
        } catch (BiffException | IOException e) {
        }

    }

为了仅导入行 (3,4,5)，我使用了此代码.A 是我们存放行数的数组:

In order to import only the rows (3,4,5), I used this code. A is the array in which we stock the rows numbers:

private void RemplirPostes(JTable table, int numfeuil,String s,int[] A) {
        Workbook wb;
        File fichier = new File(s);
        try {
            //création de la table et importation du fichier
                    wb = Workbook.getWorkbook(fichier);
            Sheet sheet = wb.getSheet(numfeuil);
            DefaultTableModel model = new DefaultTableModel();
            //Remplir la table désignée
                        table.setModel(model);
            int colonnes = sheet.getColumns();
                Object data[] = new Object[colonnes];

                        for(int k=0;k<A.length;k++)
                            {
                              for (int j=0; j<colonnes; j++){
                              if (A[k]==0)
                    {
                        //Component c=super.prepareRenderer(renderer, j, i);
                model.addColumn(sheet.getCell(j,A[k]).getContents());

                    }
                    //System.out.println(sheet.getCell(j,i).getContents());
                    if(A[k]>=1)

                        data[j]=sheet.getCell(j,A[k]).getContents();

                }model.addRow(data);
                                }
            model.removeRow(0); 

                } catch (BiffException | IOException e) {
        }

    }

而这一切都行不通.

推荐答案

从这个完整的例子开始，如下代码创建一个表，该表具有从 MIN_ROW 到 MAX_ROW(含)的指​​定数量的 COLUMNS.

Starting from this complete example, the following code creates a table having the indicated number of COLUMNS from MIN_ROW to MAX_ROW, inclusive.

private static final int COLUMNS = 4;
private static final int MIN_ROW = 3;
private static final int MAX_ROW = 5;
…
DataFormatter format = new DataFormatter();
DefaultTableModel model = new DefaultTableModel(0, COLUMNS);
for (Row row : sheet) {
    if (row.getRowNum() >= MIN_ROW && row.getRowNum() <= MAX_ROW) {
        Vector rowData = new Vector();
        for (Cell cell : row) {
            rowData.add(format.formatCellValue(cell));
        }
        model.addRow(rowData);
    }
}
…
JFrame f = new JFrame("TableTest");
f.add(new JTable(model));

附录:仔细观察您当前的方法，您可能希望容纳不连续的行.用 List 替换数组可能会有所帮助.然后你可以使用 contains() 代替上面的谓词:

Addendum: Looking closer at your current approach, you may want to accommodate non-contiguous rows. It may help to replace your array with a List<Integer>. You can then use contains() in place of the predicate above:

if (a.contains(row.getRowNum()) {…}

附录:要计算公式，您可以将 FormulaEvaluator 传递给 formatCellValue().

Addendum: To evaluate formulae, you can pass a FormulaEvaluator to formatCellValue().

FormulaEvaluator eval = book.getCreationHelper().createFormulaEvaluator();
…
rowData.add(format.formatCellValue(cell, eval));

这篇关于如何在 Java 上的 JTable 中填充一些 Excel 行?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！