QT怎样读写excel-CSDN论坛

Question

如题所述

Answer 1

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);