第1个回答 2016-12-22
QAxWidgetexcel("Excel.Application");1)显示当前窗口:excel.setProperty("Visible",true);2)更改Excel标题栏:excel.setProperty("Caption","InvokeMicrosoftExcel");3)添加新工作簿:QAxObject*workbooks=excel.querySubObject("WorkBooks");workbooks->dynamicCall("Add");4)打开已存在的工作簿:workbooks->dynamicCall("Open(constQString&)",QString("c:/test.xls"));5)获取活动工作簿:QAxObject*workbook=excel.querySubObject("ActiveWorkBook");6)获取所有的工作表:QAxObject*worksheets=workbook->querySubObject("WorkSheets");7)获取工作表数量:intintCount=worksheets->property("Count").toInt();8)获取第一个工作表:QAxObject*worksheet=workbook->querySubObject("Worksheets(int)",1);9)获取cell的值:QAxObject*range=worksheet->querySubObject("Cells(int,int)",1,1);