vs中怎么利用qt读取excel表

您好，关于如何利用Qt读取Excel表格，可以使用QAxObject对象来操作，具体方法如下：

#include <QAxObject>

QAxObject *excel = new QAxObject( "Excel.Application", 0 );
excel->setProperty( "Visible", false );
QAxObject *workbooks = excel->querySubObject( "Workbooks" );
QAxObject *workbook = workbooks->querySubObject( "Open(const QString&)", "文件路径" );
QAxObject *worksheets = workbook->querySubObject( "Worksheets" );
QAxObject *worksheet = worksheets->querySubObject( "Item(int)", 1 ); // 读取第1个Sheet
int rows = worksheet->dynamicCall( "Rows" ).toInt();
int columns = worksheet->dynamicCall( "Columns" ).toInt();
for( int row = 1; row <= rows; ++row ) {
    for( int col = 1; col <= columns; ++col ) {
        QAxObject *cell = worksheet->querySubObject( "Cells(int,int)", row, col );
        QVariant value = cell->property( "Value" );
        qDebug() << value.toString();
        cell->dynamicCall( "Clear()" );
        delete cell;
    }
}
delete worksheet;
delete worksheets;
workbook->dynamicCall( "Close()" );
delete workbook;
workbooks->dynamicCall( "Close()" );
delete workbooks;
excel->dynamicCall( "Quit()" );
delete excel;

需要注意的是，该方法只能读取xlsx格式的Excel表格。如果要读取xls格式的表格，可以使用QVariant储存数据，但是需要引入QtXlsxWriter库。

希望可以帮到您。