QT:读excel文件的操作

效果图：

 直接看代码：

excelbash.h  excelbash.cpp

#ifndef EXCELBASE_H
#define EXCELBASE_H

#include <QObject>
#include <QAxObject>
#include <QString>
#include <QStringList>
#include <QVariant>
#include <QObject>

class excelBase : public QObject
{
public:
    excelBase(QString xlsFilePath, QObject *parent = NULL);
    ~excelBase();

    void save();
    void close();
    int sheetCount();
    QString getSheetName(int sheetIndex);
    QAxObject *getWorkBooks();
    QAxObject *getWorkBook();
    QAxObject *getWorkSheets();
    QAxObject *getWorkSheet();
    // 返回当前 Sheet.
    QVariant read(int index, int row, int col);
    void readAll(int index);

private:
    QAxObject * excel;
    QAxObject * workBooks;
    QAxObject * workBook;
    QAxObject * sheets;
    QAxObject * sheet;
};