I would like to ask you a question about using QT to operate Excel. Please give me some advice.

wudayongnb

I would like to ask you a question about using QT to operate Excel. Please give me some advice. [Copy link]

Recently, a host computer was used in a project, so I used QT5 to make a host computer. The host computer needs to write some data to an EXCEL file. I referred to the examples on the Internet and used the QAxObject class. When opening an EXCEL file, if you use the following two sentences to set it: excel->dynamicCall("SetVisible(bool Visible)", "false"); excel->setProperty("DisplayAlerts", false); When calling QAxObject* workbook = workbooks->querySubObject("Open(const QString&)", QDir::toNativeSeparators(file0)); When opening an excel file, it will prompt QAxBase: Error calling IDispatch member Open: Unknown error, and the opening fails. If you use the following two sentences to set: excel->dynamicCall("SetVisible(bool Visible)", "true"); //excel->setProperty("WindowState", "xlMinimized"); The Excel file can be opened normally, but if the EXCEL software is not cracked, an activation prompt will pop up after opening the Excel file, which will affect subsequent read and write operations and cause file record failure. The office version I use is 2013, the QT version is 5.9, and the computer system is win7. After the upper computer software I wrote was successfully tested on my own computer, it was packaged and copied to a colleague's computer (his computer system version is win10, the office version is 2016 Home Edition, and the genuine version has been activated), and problems will occur. I don't know if you have encountered such problems.

石玉

I remember there is a way to operate without installing EXCEL

lk1986

bucuoou

wudayongnb

Shi Yu posted on 2018-2-7 13:51 I remember there is a way to operate without installing EXCEL

Can you tell me about it?