PHP使用COM操作Excel XLSX，无法将文件添加到OleObjects

Question

i'm doing Excel XLSX editing with PHP through COM component,

i need to add an outside txt file to a sheet as an OleObjects,

here is my code:

$tmpSheet = $excel->ActiveWorkbook->Sheets->Add();
$tmpSheet->Activate();
$tmpSheet->Name = "runLog";

$tmpObj = array("", "e:/test01.txt"
                =);
$tmpSheet->OLEObjects->Add($tmpObj);

return error is:

Source:</b> Microsoft ExcelDescription:</b> Cannot insert object.

how can i solve it?

thank you.

Answer 1

i solved myself........

final code:

        $tmpSheet = $excel->ActiveWorkbook->Sheets->Add(null, $tmpSheet);
        $tmpSheet->Activate();
        $tmpSheet->Name = $resultSheetName;

        $tmpSheet = $excel->ActiveWorkbook->Sheets($excel->ActiveWorkbook->Sheets->Count);
        $tmpSheet->OLEObjects->Add(null, "" . __dir__ . "/" . $tmpSrcFilePath);

notice:

i. first param ClassType set to null.

ii. second param FileName set to full path.

thank you everyone.........