Method openExcelFile

ExcelViewer/mainwindow.cpp:85–181

}

void MainWindow::openExcelFile()
{
    // Show warning / information message before opening the file dialog
    QMessageBox::StandardButton choice = QMessageBox::question(
        this,
        "Information",
        "If the xlsx file is large, opening it may take a significant amount of time.\n\n"
        "Do you want to continue and select a file?",
        QMessageBox::Yes | QMessageBox::No,
        QMessageBox::Yes
        );

    if (choice != QMessageBox::Yes)
        return;

    QString filePath = QFileDialog::getOpenFileName(
        this,
        "Select Excel File",
        QString(),
        "Excel File (*.xlsx)"
        );

    if (filePath.isEmpty())
        return;

    // First, read sheet names using QXlsx::Document
    Document doc(filePath);
    if (!doc.isLoadPackage())
    {
        QMessageBox::warning(
            this,
            "Error",
            "Failed to load the Excel file."
            );
        return;
    }

    const QStringList sheetNames = doc.sheetNames();
    if (sheetNames.isEmpty())
    {
        QMessageBox::information(
            this,
            "Info",
            "The Excel file has no sheets."
            );
        return;
    }

    clearTabs();

    // For each sheet, create a model and a view, and add as a tab
    for (const QString &sheetName : sheetNames)
    {
        ExcelModel *model = new ExcelModel(this);
        if (!model->loadFromXlsx(filePath, sheetName))
        {
            delete model;
            continue;