qt读取execl中数据

要在Qt中读取Excel数据，可以使用Qt的QAxObject类。以下是一个简单的示例代码：

QAxObject* excel = new QAxObject("Excel.Application");
QAxObject* workbooks = excel->querySubObject("Workbooks");
QAxObject* workbook = workbooks->querySubObject("Open(const QString&)", "path/to/your/excel/file.xlsx");
QAxObject* worksheet = workbook->querySubObject("Worksheets(int)", 1);

// 读取第1行第1列的单元格内容
QAxObject* cell = worksheet->querySubObject("Cells(int,int)", 1, 1);
QVariant value = cell->dynamicCall("Value");
QString str = value.toString();

delete cell;
delete worksheet;
workbook->dynamicCall("Close()");
delete workbook;
workbooks->dynamicCall("Close()");
delete workbooks;
excel->dynamicCall("Quit()");
delete excel;

请注意，QAxObject是一个COM对象，因此需要在使用后手动删除它们以避免内存泄漏。此外，需要安装Microsoft Excel并启用其COM接口才能使用此代码。