qt xlsx 怎样读取EXcel内的多个sheet

[wzfgf1]

qt xlsx 怎样读取EXcel内的多个sheet ，哪位大神上代码

[puthon]

可以试一下用QAxObject来读：

 QAxObject * worksheet = workbook->querySubObject("Worksheets(int)", 1);

我之前写过把excel文件读到sqlite的代码，读入直接用QAxObject，写操作用的一个开源库（很方便）你可以参考一下：https://blog.csdn.net/pyuxing/article/details/82903767#2excel_15

[浮一大白开水]

我在QT中使用的xllib,

void CAdvertisingProcess::importexcel()
{
	QFileInfo user_info(m_importxlsPath);

	QString user_ffix = user_info.suffix();
	if ((QString::compare(user_ffix, QString("xls"), Qt::CaseInsensitive) == 0) || (QString::compare(user_ffix, QString("xlsx"), Qt::CaseInsensitive) == 0))
	{
		QString user_absolute = user_info.absoluteFilePath();

		Book* book = xlCreateBook();
		if (book)
		{
			QByteArray pathba = user_absolute.toLocal8Bit();
			if (book->load(pathba.data()))
			{
				Sheet* sheet = book->getSheet(0);
				if (sheet)
				{
					int row = 0;
					int col = 0;
					while (1)
					{
						ADVERTISING_INFO userdata;
						col = 7;
						++row;
						const char* s = sheet->readStr(row, col);

						QString empno = QString::fromLocal8Bit(s);
						if (empno.size() == 0)
						{
							break;
						}
						userdata.XQ = empno;

						col++;

						s = sheet->readStr(row, col);
						userdata.LD = QString::fromLocal8Bit(s);
						col++;

						s = sheet->readStr(row, col);
						userdata.DY = QString::fromLocal8Bit(s);
						col++;

						s = sheet->readStr(row, col);
						userdata.DT = QString::fromLocal8Bit(s);

						m_dataList.append(userdata);
					}

					ShowMessageBoxSlot(QString::fromLocal8Bit("提示"), QString::fromLocal8Bit("用户导入完成"));

					UpdateAdInfo();
				}
				else
				{
					ShowMessageBoxSlot(QString::fromLocal8Bit("提示"), QString::fromLocal8Bit("导入失败，文件异常"));
				}
			}
			else
			{
				qDebug() << "At first run generate !" << endl;
				ShowMessageBoxSlot(QString::fromLocal8Bit("提示"), QString::fromLocal8Bit("导入失败，文件异常"));
			}

			book->release();
		}
		else
		{
			ShowMessageBoxSlot(QString::fromLocal8Bit("提示"), QString::fromLocal8Bit("导入失败，文件异常"));
		}

	}
	else
	{
		ShowMessageBoxSlot(QString::fromLocal8Bit("提示"), QString::fromLocal8Bit("导入失败，文件异常"));
	}
}

[浮一大白开水]

sheet就是getSheet（。。。）

[nnnhbobo123]

我也想知道，遇到这个问题，先做个记录，看看有没有人看处理

[weixin_42220591]

excel.selectSheet(const QString &name);
excel.sheetNames();
用这俩个搞定了。

[开心大爆炸]

https://github.com/QtExcel/QXlsx/wiki
第五个示例： Read all sheets data
这里有个代码，不知道是否能满足你的要求。