qt 写入excel文件，打开后乱码问题

[yingzizizizizizzz]

void ReportDialog::setCellValue(int row, int column, const QString &value){
    QAxObject *pRange = pSheet->querySubObject("Cells(int,int)", row, column);
     pRange->dynamicCall("Value", value);
}

这个向excel填写内容的函数。
setCellValue(1,1,"这就是这样");

结果是：

求大神指导

[赵4老师]

字符编码惹的祸？ 对电脑而言没有乱码，只有二进制字节；对人脑才有乱码。啊 GBK:0xB0 0xA1,Unicode-16 LE:0x4A 0x55,Unicode-16 BE:0x55 0x4A,UTF-8:0xE5 0x95 0x8A

[小灸舞]

估计和楼主写入的编码有关

void WriteTest()
{
    CoInitialize(NULL);
    QAxObject *excel = new QAxObject();
    excel->setControl("Excel.Application");
    excel->dynamicCall("SetVisible (bool Visible)","false");
    excel->setProperty("DisplayAlerts", false);
    QAxObject *workbooks = excel->querySubObject("WorkBooks");//获取工作簿集合
    workbooks->dynamicCall("Open (const QString&)", "C:/Users/dell/Desktop/aa.xlsx");
    QAxObject *workbook = excel->querySubObject("ActiveWorkBook");//获取当前工作簿
    QAxObject *worksheet = workbook->querySubObject("Worksheets(int)", 1);
    QAxObject *range = worksheet->querySubObject("Cells(int,int)", 1, 1);
    range->dynamicCall("Value", "这就是这样啊");
    workbook->dynamicCall("SaveAs(const QString &)", QDir::toNativeSeparators("C:/Users/dell/Desktop/aa.xlsx"));
    workbook->dynamicCall("Close()");
    excel->dynamicCall("Quit()");
    delete excel;
    excel = NULL;
    CoUninitialize();
}