Embed Excel in QT window with toolbars showing

[mikek10]

Hi,

Have spent several days trying things from numerous threads on this forum but cannot seem to get the result I need.

I need to embed excel within a QT window, showing all excel toolbars as well as the spreadsheet cells. Excel must show within a QT window rather than launching a new instance of Excel.

If I open the desired spreadsheet file directly i.e. ui->excel->setControl("c:\\test\\book.xlsx"); then the spreadsheet displays within the QAxWidget - which is good, but the toolbars are hidden and I cannot seem to make them visible (some attempts below). If I use ui->excel=new QAxWidget("Excel.Application") then open the spreadsheet using ui->excel->querySubObject("WorkBooks")->dynamicCall("Open (const QString&)", QString("c:\\test\\book.xlsx")); the Excel toolbars are visible but Excel is in a separate window and excel is shown in the taskbar rather than being embedded within QT.

Any help would be greatly appreciated!!

Thanks

ui->excel=new QAxWidget("Excel.Application");
    ui->gridLayout->addWidget(ui->excel);
    //ui->excel->querySubObject("WorkBooks")->dynamicCall("Open (const QString&)", QString("c:\\test\\book.xlsx"));
    ui->excel->setControl("c:\\test\\book.xlsx");
    ui->excel->querySubObject("ActiveWorkBook");
    ui->excel->setProperty("Visible", true);
    ui->excel->setProperty("Caption", "Qt Excel");      //Titled Qt Excel
    ui->excel->setProperty("DisplayAlerts", true);
    ui->excel->setProperty("DisplayFullScreen", false);
    ui->excel->dynamicCall("CommandBars("MyToolbar").Enabled = true");
    ui->excel->dynamicCall("CommandBars("Worksheet Menu Bar").Enabled = true");
    ui->excel->dynamicCall("CommandBars("MyToolbar").Enabled = true");
    ui->excel->dynamicCall("CommandBars("Worksheet Menu Bar").Visible = true");   
    ui->excel->dynamicCall("show.toolbar("Ribbon",True");

ui->excel=new QAxWidget("Excel.Application");
    ui->gridLayout->addWidget(ui->excel);
    //ui->excel->querySubObject("WorkBooks")->dynamicCall("Open (const QString&)", QString("c:\\test\\book.xlsx"));
    ui->excel->setControl("c:\\test\\book.xlsx");
    ui->excel->querySubObject("ActiveWorkBook");
    ui->excel->setProperty("Visible", true);
    ui->excel->setProperty("Caption", "Qt Excel");      //Titled Qt Excel
    ui->excel->setProperty("DisplayAlerts", true);
    ui->excel->setProperty("DisplayFullScreen", false);
    ui->excel->dynamicCall("CommandBars("MyToolbar").Enabled = true");
    ui->excel->dynamicCall("CommandBars("Worksheet Menu Bar").Enabled = true");
    ui->excel->dynamicCall("CommandBars("MyToolbar").Enabled = true");
    ui->excel->dynamicCall("CommandBars("Worksheet Menu Bar").Visible = true");   
    ui->excel->dynamicCall("show.toolbar("Ribbon",True");

To copy to clipboard, switch view to plain text mode