roxen.lists.pike.general

Subject Author Date
using COM module with excel ¹ùÑ©ËÉú—­zºZŸ ¤¢x¢ <¹ùÑ©ËÉú—­zºZŸ ¤¢x¢[at]nirgendwo> 23-07-2009 
The following code not works, what is the correct usage?

 

int main(int argc, array(string) argv)

{

  object app;

 

  app = COM.CreateObject("Excel.Application");

  app->Visible = 1;

  app->WorkBooks->Add();

  for(int i=1;i<=100;i++){

           for(int j=1;j<=100;j++){

                     //app->ActiveSheet->Cells(i,j)->Value=1;

                     app->ActiveSheet->Cells[i][j]->Value=1;

           }

  }

  sleep(10);

  //app->Quit(consts["wdPromptToSaveChanges"]);

}

 

Xuesong Guo