将excel里的内容显示到tablewidget里 但是没显示出来、 debug看到item里面已经是excel里的内容了,而且行列数都对,但是最后tablehistory这个tablewidget控件里却没有显示出来内容
QString filepath = QDir::currentPath() + "/历史记录.xlsx";
QAxObject *excel = NULL;
QAxObject *workbooks = NULL;
QAxObject *workbook = NULL;
excel = new QAxObject(this);
if (!excel->setControl("Excel.Application"))
{
excel->setControl("ket.Application");
}
if (!excel)
{
QMessageBox::critical(NULL, "错误信息", "EXCEL对象丢失");
return;
}
excel->dynamicCall("SetVisible(bool)", false);
workbooks = excel->querySubObject("WorkBooks");
workbook = workbooks->querySubObject("Open(const QString&)",filepath);
QAxObject * worksheet = workbook->querySubObject("WorkSheets(int)", 1); // 获取第一个工作sheet
QAxObject * usedrange = worksheet->querySubObject("UsedRange");//获取该sheet的使用范围对象
QAxObject * rows = usedrange->querySubObject("Rows");
QAxObject * columns = usedrange->querySubObject("Columns");
/*获取行数和列数*/
int intCols = columns->property("Count").toInt();
int intRows = rows->property("Count").toInt();
int intRowStart = usedrange->property("Row").toInt();
int intColStart = usedrange->property("Column").toInt();
/*获取excel内容*/
for (int i = intRowStart; i < intRowStart + intRows; i++) //行
{
for (int j = intColStart; j < intColStart + intCols; j++)
{
QAxObject *cell = worksheet->querySubObject("Cells(int,int)", i, j);
QTableWidgetItem *item = new QTableWidgetItem(cell->dynamicCall("text()").toString());
ui->tablehistory->setItem(i, j, item);
delete cell;
qDebug()<< item->text();
}
}
// 关闭excel
workbook->dynamicCall("Close(Boolean)",true);
excel->dynamicCall("Quit(void)");
delete excel;
excel = NULL;