读取Excel并将其显示在tableview上。使用二维数组或列表填充TableView

import org.apache.poi.ss.usermodel.*;

public class ExcelReader {
    public static void readExcel(String filePath) {
        try {
            Workbook workbook = WorkbookFactory.create(new File(filePath));
            Sheet sheet = workbook.getSheetAt(0); // 获取第一个Sheet
            DataFormatter dataFormatter = new DataFormatter();

            for (Row row : sheet) {
                for (Cell cell : row) {
                    String cellValue = dataFormatter.formatCellValue(cell);
                    System.out.print(cellValue + "\t");
                }
                System.out.println();
            }

            workbook.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

import javafx.application.Application;
import javafx.collections.FXCollections;
import javafx.collections.ObservableList;
import javafx.scene.Scene;
import javafx.scene.control.TableColumn;
import javafx.scene.control.TableView;
import javafx.scene.control.cell.PropertyValueFactory;
import javafx.scene.layout.VBox;
import javafx.stage.Stage;

public class ExcelTableView extends Application {
    private TableView<ObservableList<String>> tableView = new TableView<>();

    public static void main(String[] args) {
        launch(args);
    }

    @Override
    public void start(Stage primaryStage) {
        String filePath = "path/to/excel.xlsx";
        ExcelReader.readExcel(filePath); // 调用ExcelReader的readExcel方法读取Excel数据

        primaryStage.setTitle("Excel TableView");
        VBox vbox = new VBox(tableView);
        Scene scene = new Scene(vbox, 400, 300);
        primaryStage.setScene(scene);
        primaryStage.show();
    }

    public void populateTableView(List<List<String>> data) {
        // 创建TableColumn对象，定义每一列的标题和数据绑定的属性
        for (int i = 0; i < data.get(0).size(); i++) {
            final int colIndex = i;
            TableColumn<ObservableList<String>, String> column = new TableColumn<>("Column " + (i+1));
            column.setCellValueFactory(cellData -> {
                List<String> row = cellData.getValue();
                if (colIndex >= row.size()) {
                    return new SimpleStringProperty("");
                }
                return new SimpleStringProperty(row.get(colIndex));
            });
            tableView.getColumns().add(column);
        }

        // 创建ObservableList对象，用于存储Excel数据
        ObservableList<ObservableList<String>> tableData = FXCollections.observableArrayList();
        for (List<String> rowData : data) {
            tableData.add(FXCollections.observableArrayList(rowData));
        }
        tableView.setItems(tableData);
    }
}