VC操作EXCEL

COleVariant vOpt((long)DISP_E_PARAMNOTFOUND, VT_ERROR);

 CApplication app;  // app is the Excel _Application object

   // Start Excel and get Application object.

   if(!app.CreateDispatch("Excel.Application"))
   {
      AfxMessageBox("Cannot start Excel and get Application object.");
      return;
   }

   //Make the application visible and give the user control of
   //Microsoft Excel.
   app.put_Visible(TRUE);
   app.put_UserControl(TRUE);

   CWorkbooks books = (CWorkbooks)app.get_Workbooks();
   CWorkbook book = (CWorkbook)books.Add(vOpt);

   CSheets sheets = (CSheets)book.get_Worksheets();
   CWorksheet sheet = (CWorksheet)sheets.get_Item(COleVariant((short)1));
   CRange range = (CRange)sheet.get_Range(COleVariant("A1"),COleVariant("A2"));

   range.put_Value2(COleVariant("test"));

注明:Excel 2002(XP),2003 Range.put_Value(VARIANT RangeValueDataType,VARIANT newValue)有两个参数,Excel 98,2000,只有一个参数,pub_Value2(VARIANT newValue)