mfc操作excel（excel.h）

最新推荐文章于 2022-05-05 21:12:39 发布
最新推荐文章于 2022-05-05 21:12:39 发布
阅读量1.6k 收藏
点赞数
文章标签： mfc 操作excel excel.h

// Machine generated IDispatch wrapper class(es) created with ClassWizard
/
// _Application wrapper class

class _Application : public COleDispatchDriver
{
public:
 _Application() {}  // Calls COleDispatchDriver default constructor
 _Application(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
 _Application(const _Application& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}

// Attributes
public:

// Operations
public:
 LPDISPATCH GetApplication();
 long GetCreator();
 LPDISPATCH GetParent();
 LPDISPATCH GetActiveCell();
 LPDISPATCH GetActiveChart();
 CString GetActivePrinter();
 void SetActivePrinter(LPCTSTR lpszNewValue);
 LPDISPATCH GetActiveSheet();
 LPDISPATCH GetActiveWindow();
 LPDISPATCH GetActiveWorkbook();
 LPDISPATCH GetAddIns();
 LPDISPATCH GetAssistant();
 void Calculate();
 LPDISPATCH GetCells();
 LPDISPATCH GetCharts();
 LPDISPATCH GetColumns();
 LPDISPATCH GetCommandBars();
 long GetDDEAppReturnCode();
 void DDEExecute(long Channel, LPCTSTR String);
 long DDEInitiate(LPCTSTR App, LPCTSTR Topic);
 void DDEPoke(long Channel, const VARIANT& Item, const VARIANT& Data);
 VARIANT DDERequest(long Channel, LPCTSTR Item);
 void DDETerminate(long Channel);
 VARIANT Evaluate(const VARIANT& Name);
 VARIANT _Evaluate(const VARIANT& Name);
 VARIANT ExecuteExcel4Macro(LPCTSTR String);
 LPDISPATCH Intersect(LPDISPATCH Arg1, LPDISPATCH Arg2, const VARIANT& Arg3, const VARIANT& Arg4, const VARIANT& Arg5, const VARIANT& Arg6, const VARIANT& Arg7, const VARIANT& Arg8, const VARIANT& Arg9, const VARIANT& Arg10,
  const VARIANT& Arg11, const VARIANT& Arg12, const VARIANT& Arg13, const VARIANT& Arg14, const VARIANT& Arg15, const VARIANT& Arg16, const VARIANT& Arg17, const VARIANT& Arg18, const VARIANT& Arg19, const VARIANT& Arg20,
  const VARIANT& Arg21, const VARIANT& Arg22, const VARIANT& Arg23, const VARIANT& Arg24, const VARIANT& Arg25, const VARIANT& Arg26, const VARIANT& Arg27, const VARIANT& Arg28, const VARIANT& Arg29, const VARIANT& Arg30);
 LPDISPATCH GetNames();
 LPDISPATCH GetRange(const VARIANT& Cell1, const VARIANT& Cell2);
 LPDISPATCH GetRows();
 VARIANT Run(const VARIANT& Macro, const VARIANT& Arg1, const VARIANT& Arg2, const VARIANT& Arg3, const VARIANT& Arg4, const VARIANT& Arg5, const VARIANT& Arg6, const VARIANT& Arg7, const VARIANT& Arg8, const VARIANT& Arg9,
  const VARIANT& Arg10, const VARIANT& Arg11, const VARIANT& Arg12, const VARIANT& Arg13, const VARIANT& Arg14, const VARIANT& Arg15, const VARIANT& Arg16, const VARIANT& Arg17, const VARIANT& Arg18, const VARIANT& Arg19,
  const VARIANT& Arg20, const VARIANT& Arg21, const VARIANT& Arg22, const VARIANT& Arg23, const VARIANT& Arg24, const VARIANT& Arg25, const VARIANT& Arg26, const VARIANT& Arg27, const VARIANT& Arg28, const VARIANT& Arg29,
  const VARIANT& Arg30);
 VARIANT _Run2(const VARIANT& Macro, const VARIANT& Arg1, const VARIANT& Arg2, const VARIANT& Arg3, const VARIANT& Arg4, const VARIANT& Arg5, const VARIANT& Arg6, const VARIANT& Arg7, const VARIANT& Arg8, const VARIANT& Arg9,
  const VARIANT& Arg10, const VARIANT& Arg11, const VARIANT& Arg12, const VARIANT& Arg13, const VARIANT& Arg14, const VARIANT& Arg15, const VARIANT& Arg16, const VARIANT& Arg17, const VARIANT& Arg18, const VARIANT& Arg19,
  const VARIANT& Arg20, const VARIANT& Arg21, const VARIANT& Arg22, const VARIANT& Arg23, const VARIANT& Arg24, const VARIANT& Arg25, const VARIANT& Arg26, const VARIANT& Arg27, const VARIANT& Arg28, const VARIANT& Arg29,
  const VARIANT& Arg30);
 LPDISPATCH GetSelection();
 void SendKeys(const VARIANT& Keys, const VARIANT& Wait);
 LPDISPATCH GetSheets();
 LPDISPATCH GetThisWorkbook();
 LPDISPATCH Union(LPDISPATCH Arg1, LPDISPATCH Arg2, const VARIANT& Arg3, const VARIANT& Arg4, const VARIANT& Arg5, const VARIANT& Arg6, const VARIANT& Arg7, const VARIANT& Arg8, const VARIANT& Arg9, const VARIANT& Arg10, const VARIANT& Arg11,
  const VARIANT& Arg12, const VARIANT& Arg13, const VARIANT& Arg14, const VARIANT& Arg15, const VARIANT& Arg16, const VARIANT& Arg17, const VARIANT& Arg18, const VARIANT& Arg19, const VARIANT& Arg20, const VARIANT& Arg21,
  const VARIANT& Arg22, const VARIANT& Arg23, const VARIANT& Arg24, const VARIANT& Arg25, const VARIANT& Arg26, const VARIANT& Arg27, const VARIANT& Arg28, const VARIANT& Arg29, const VARIANT& Arg30);
 LPDISPATCH GetWindows();
 LPDISPATCH GetWorkbooks();
 LPDISPATCH GetWorksheetFunction();
 LPDISPATCH GetWorksheets();
 LPDISPATCH GetExcel4IntlMacroSheets();
 LPDISPATCH GetExcel4MacroSheets();
 void ActivateMicrosoftApp(long Index);
 void AddChartAutoFormat(const VARIANT& Chart, LPCTSTR Name, const VARIANT& Description);
 void AddCustomList(const VARIANT& ListArray, const VARIANT& ByRow);
 BOOL GetAlertBeforeOverwriting();
 void SetAlertBeforeOverwriting(BOOL bNewValue);
 CString GetAltStartupPath();
 void SetAltStartupPath(LPCTSTR lpszNewValue);
 BOOL GetAskToUpdateLinks();
 void SetAskToUpdateLinks(BOOL bNewValue);
 BOOL GetEnableAnimations();
 void SetEnableAnimations(BOOL bNewValue);
 LPDISPATCH GetAutoCorrect();
 long GetBuild();
 BOOL GetCalculateBeforeSave();
 void SetCalculateBeforeSave(BOOL bNewValue);
 long GetCalculation();
 void SetCalculation(long nNewValue);
 VARIANT GetCaller(const VARIANT& Index);
 BOOL GetCanPlaySounds();
 BOOL GetCanRecordSounds();
 CString GetCaption();
 void SetCaption(LPCTSTR lpszNewValue);
 BOOL GetCellDragAndDrop();
 void SetCellDragAndDrop(BOOL bNewValue);
 double CentimetersToPoints(double Centimeters);
 BOOL CheckSpelling(LPCTSTR Word, const VARIANT& CustomDictionary, const VARIANT& IgnoreUppercase);
 VARIANT GetClipboardFormats(const VARIANT& Index);
 BOOL GetDisplayClipboardWindow();
 void SetDisplayClipboardWindow(BOOL bNewValue);
 long GetCommandUnderlines();
 void SetCommandUnderlines(long nNewValue);
 BOOL GetConstrainNumeric();
 void SetConstrainNumeric(BOOL bNewValue);
 VARIANT ConvertFormula(const VARIANT& Formula, long FromReferenceStyle, const VARIANT& ToReferenceStyle, const VARIANT& ToAbsolute, const VARIANT& RelativeTo);
 BOOL GetCopyObjectsWithCells();
 void SetCopyObjectsWithCells(BOOL bNewValue);
 long GetCursor();
 void SetCursor(long nNewValue);
 long GetCustomListCount();
 long GetCutCopyMode();
 void SetCutCopyMode(long nNewValue);
 long GetDataEntryMode();
 void SetDataEntryMode(long nNewValue);
 CString Get_Default();
 CString GetDefaultFilePath();
 void SetDefaultFilePath(LPCTSTR lpszNewValue);
 void DeleteChartAutoFormat(LPCTSTR Name);
 void DeleteCustomList(long ListNum);
 LPDISPATCH GetDialogs();
 BOOL GetDisplayAlerts();
 void SetDisplayAlerts(BOOL bNewValue);
 BOOL GetDisplayFormulaBar();
 void SetDisplayFormulaBar(BOOL bNewValue);
 BOOL GetDisplayFullScreen();
 void SetDisplayFullScreen(BOOL bNewValue);
 BOOL GetDisplayNoteIndicator();
 void SetDisplayNoteIndicator(BOOL bNewValue);
 long GetDisplayCommentIndicator();
 void SetDisplayCommentIndicator(long nNewValue);
 BOOL GetDisplayExcel4Menus();
 void SetDisplayExcel4Menus(BOOL bNewValue);
 BOOL GetDisplayRecentFiles();
 void SetDisplayRecentFiles(BOOL bNewValue);
 BOOL GetDisplayScrollBars();
 void SetDisplayScrollBars(BOOL bNewValue);
 BOOL GetDisplayStatusBar();
 void SetDisplayStatusBar(BOOL bNewValue);
 void DoubleClick();
 BOOL GetEditDirectlyInCell();
 void SetEditDirectlyInCell(BOOL bNewValue);
 BOOL GetEnableAutoComplete();
 void SetEnableAutoComplete(BOOL bNewValue);
 long GetEnableCancelKey();
 void SetEnableCancelKey(long nNewValue);
 BOOL GetEnableSound();
 void SetEnableSound(BOOL bNewValue);
 VARIANT GetFileConverters(const VARIANT& Index1, const VARIANT& Index2);
 LPDISPATCH GetFileSearch();
 LPDISPATCH GetFileFind();
 BOOL GetFixedDecimal();
 void SetFixedDecimal(BOOL bNewValue);
 long GetFixedDecimalPlaces();
 void SetFixedDecimalPlaces(long nNewValue);
 VARIANT GetCustomListContents(long ListNum);
 long GetCustomListNum(const VARIANT& ListArray);
 VARIANT GetOpenFilename(const VARIANT& FileFilter, const VARIANT& FilterIndex, const VARIANT& Title, const VARIANT& ButtonText, const VARIANT& MultiSelect);
 VARIANT GetSaveAsFilename(const VARIANT& InitialFilename, const VARIANT& FileFilter, const VARIANT& FilterIndex, const VARIANT& Title, const VARIANT& ButtonText);
 void Goto(const VARIANT& Reference, const VARIANT& Scroll);
 double GetHeight();
 void SetHeight(double newValue);
 void Help(const VARIANT& HelpFile, const VARIANT& HelpContextID);
 BOOL GetIgnoreRemoteRequests();
 void SetIgnoreRemoteRequests(BOOL bNewValue);
 double InchesToPoints(double Inches);
 VARIANT InputBox(LPCTSTR Prompt, const VARIANT& Title, const VARIANT& Default, const VARIANT& Left, const VARIANT& Top, const VARIANT& HelpFile, const VARIANT& HelpContextID, const VARIANT& Type);
 BOOL GetInteractive();
 void SetInteractive(BOOL bNewValue);
 VARIANT GetInternational(const VARIANT& Index);
 BOOL GetIteration();
 void SetIteration(BOOL bNewValue);
 double GetLeft();
 void SetLeft(double newValue);
 CString GetLibraryPath();
 void MacroOptions(const VARIANT& Macro, const VARIANT& Description, const VARIANT& HasMenu, const VARIANT& MenuText, const VARIANT& HasShortcutKey, const VARIANT& ShortcutKey, const VARIANT& Category, const VARIANT& StatusBar,
  const VARIANT& HelpContextID, const VARIANT& HelpFile);
 void MailLogoff();
 void MailLogon(const VARIANT& Name, const VARIANT& Password, const VARIANT& DownloadNewMail);
 VARIANT GetMailSession();
 long GetMailSystem();
 BOOL GetMathCoprocessorAvailable();
 double GetMaxChange();
 void SetMaxChange(double newValue);
 long GetMaxIterations();
 void SetMaxIterations(long nNewValue);
 BOOL GetMouseAvailable();
 BOOL GetMoveAfterReturn();
 void SetMoveAfterReturn(BOOL bNewValue);
 long GetMoveAfterReturnDirection();
 void SetMoveAfterReturnDirection(long nNewValue);
 LPDISPATCH GetRecentFiles();
 CString GetName();
 LPDISPATCH NextLetter();
 CString GetNetworkTemplatesPath();
 LPDISPATCH GetODBCErrors();
 long GetODBCTimeout();
 void SetODBCTimeout(long nNewValue);
 void OnKey(LPCTSTR Key, const VARIANT& Procedure);
 void OnRepeat(LPCTSTR Text, LPCTSTR Procedure);
 void OnTime(const VARIANT& EarliestTime, LPCTSTR Procedure, const VARIANT& LatestTime, const VARIANT& Schedule);
 void OnUndo(LPCTSTR Text, LPCTSTR Procedure);
 CString GetOnWindow();
 void SetOnWindow(LPCTSTR lpszNewValue);
 CString GetOperatingSystem();
 CString GetOrganizationName();
 CString GetPath();
 CString GetPathSeparator();
 VARIANT GetPreviousSelections(const VARIANT& Index);
 BOOL GetPivotTableSelection();
 void SetPivotTableSelection(BOOL bNewValue);
 BOOL GetPromptForSummaryInfo();
 void SetPromptForSummaryInfo(BOOL bNewValue);
 void Quit();
 void RecordMacro(const VARIANT& BasicCode, const VARIANT& XlmCode);
 BOOL GetRecordRelative();
 long GetReferenceStyle();
 void SetReferenceStyle(long nNewValue);
 VARIANT GetRegisteredFunctions(const VARIANT& Index1, const VARIANT& Index2);
 BOOL RegisterXLL(LPCTSTR Filename);
 void Repeat();
 BOOL GetRollZoom();
 void SetRollZoom(BOOL bNewValue);
 void SaveWorkspace(const VARIANT& Filename);
 BOOL GetScreenUpdating();
 void SetScreenUpdating(BOOL bNewValue);
 void SetDefaultChart(const VARIANT& FormatName, const VARIANT& Gallery);
 long GetSheetsInNewWorkbook();
 void SetSheetsInNewWorkbook(long nNewValue);
 BOOL GetShowChartTipNames();
 void SetShowChartTipNames(BOOL bNewValue);
 BOOL GetShowChartTipValues();
 void SetShowChartTipValues(BOOL bNewValue);
 CString GetStandardFont();
 void SetStandardFont(LPCTSTR lpszNewValue);
 double GetStandardFontSize();
 void SetStandardFontSize(double newValue);
 CString GetStartupPath();
 VARIANT GetStatusBar();
 void SetStatusBar(const VARIANT& newValue);
 CString GetTemplatesPath();
 BOOL GetShowToolTips();
 void SetShowToolTips(BOOL bNewValue);
 double GetTop();
 void SetTop(double newValue);
 long GetDefaultSaveFormat();
 void SetDefaultSaveFormat(long nNewValue);
 CString GetTransitionMenuKey();
 void SetTransitionMenuKey(LPCTSTR lpszNewValue);
 long GetTransitionMenuKeyAction();
 void SetTransitionMenuKeyAction(long nNewValue);
 BOOL GetTransitionNavigKeys();
 void SetTransitionNavigKeys(BOOL bNewValue);
 void Undo();
 double GetUsableHeight();
 double GetUsableWidth();
 BOOL GetUserControl();
 void SetUserControl(BOOL bNewValue);
 CString GetUserName_();
 void SetUserName(LPCTSTR lpszNewValue);
 CString GetValue();
 LPDISPATCH GetVbe();
 CString GetVersion();
 BOOL GetVisible();
 void SetVisible(BOOL bNewValue);
 void Volatile(const VARIANT& Volatile);
 double GetWidth();
 void SetWidth(double newValue);
 BOOL GetWindowsForPens();
 long GetWindowState();
 void SetWindowState(long nNewValue);
 long GetDefaultSheetDirection();
 void SetDefaultSheetDirection(long nNewValue);
 long GetCursorMovement();
 void SetCursorMovement(long nNewValue);
 BOOL GetControlCharacters();
 void SetControlCharacters(BOOL bNewValue);
 BOOL GetEnableEvents();
 void SetEnableEvents(BOOL bNewValue);
 BOOL Wait(const VARIANT& Time);
 BOOL GetExtendList();
 void SetExtendList(BOOL bNewValue);
 LPDISPATCH GetOLEDBErrors();
 CString GetPhonetic(const VARIANT& Text);
 LPDISPATCH GetCOMAddIns();
 LPDISPATCH GetDefaultWebOptions();
 CString GetProductCode();
 CString GetUserLibraryPath();
 BOOL GetAutoPercentEntry();
 void SetAutoPercentEntry(BOOL bNewValue);
 LPDISPATCH GetLanguageSettings();
 LPDISPATCH GetAnswerWizard();
 void CalculateFull();
 BOOL FindFile();
 long GetCalculationVersion();
 BOOL GetShowWindowsInTaskbar();
 void SetShowWindowsInTaskbar(BOOL bNewValue);
 long GetFeatureInstall();
 void SetFeatureInstall(long nNewValue);
 BOOL GetReady();
 LPDISPATCH GetFindFormat();
 void SetRefFindFormat(LPDISPATCH newValue);
 LPDISPATCH GetReplaceFormat();
 void SetRefReplaceFormat(LPDISPATCH newValue);
 LPDISPATCH GetUsedObjects();
 long GetCalculationState();
 long GetCalculationInterruptKey();
 void SetCalculationInterruptKey(long nNewValue);
 LPDISPATCH GetWatches();
 BOOL GetDisplayFunctionToolTips();
 void SetDisplayFunctionToolTips(BOOL bNewValue);
 long GetAutomationSecurity();
 void SetAutomationSecurity(long nNewValue);
 LPDISPATCH GetFileDialog(long fileDialogType);
 void CalculateFullRebuild();
 BOOL GetDisplayPasteOptions();
 void SetDisplayPasteOptions(BOOL bNewValue);
 BOOL GetDisplayInsertOptions();
 void SetDisplayInsertOptions(BOOL bNewValue);
 BOOL GetGenerateGetPivotData();
 void SetGenerateGetPivotData(BOOL bNewValue);
 LPDISPATCH GetAutoRecover();
 long GetHwnd();
 long GetHinstance();
 void CheckAbort(const VARIANT& KeepAbort);
 LPDISPATCH GetErrorCheckingOptions();
 BOOL GetAutoFormatAsYouTypeReplaceHyperlinks();
 void SetAutoFormatAsYouTypeReplaceHyperlinks(BOOL bNewValue);
 LPDISPATCH GetSmartTagRecognizers();
 LPDISPATCH GetNewWorkbook();
 LPDISPATCH GetSpellingOptions();
 LPDISPATCH GetSpeech();
 BOOL GetMapPaperSize();
 void SetMapPaperSize(BOOL bNewValue);
 BOOL GetShowStartupDialog();
 void SetShowStartupDialog(BOOL bNewValue);
 CString GetDecimalSeparator();
 void SetDecimalSeparator(LPCTSTR lpszNewValue);
 CString GetThousandsSeparator();
 void SetThousandsSeparator(LPCTSTR lpszNewValue);
 BOOL GetUseSystemSeparators();
 void SetUseSystemSeparators(BOOL bNewValue);
 LPDISPATCH GetThisCell();
 LPDISPATCH GetRtd();
 BOOL GetDisplayDocumentActionTaskPane();
 void SetDisplayDocumentActionTaskPane(BOOL bNewValue);
 void DisplayXMLSourcePane(const VARIANT& XmlMap);
 BOOL GetArbitraryXMLSupportAvailable();
};
/
// Sheets wrapper class

class Sheets : public COleDispatchDriver
{
public:
 Sheets() {}  // Calls COleDispatchDriver default constructor
 Sheets(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
 Sheets(const Sheets& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}

// Attributes
public:

// Operations
public:
 LPDISPATCH GetApplication();
 long GetCreator();
 LPDISPATCH GetParent();
 LPDISPATCH Add(const VARIANT& Before, const VARIANT& After, const VARIANT& Count, const VARIANT& Type);
 void Copy(const VARIANT& Before, const VARIANT& After);
 long GetCount();
 void Delete();
 void FillAcrossSheets(LPDISPATCH Range, long Type);
 LPDISPATCH GetItem(const VARIANT& Index);
 void Move(const VARIANT& Before, const VARIANT& After);
 LPUNKNOWN Get_NewEnum();
 void PrintPreview(const VARIANT& EnableChanges);
 void Select(const VARIANT& Replace);
 LPDISPATCH GetHPageBreaks();
 LPDISPATCH GetVPageBreaks();
 VARIANT GetVisible();
 void SetVisible(const VARIANT& newValue);
 LPDISPATCH Get_Default(const VARIANT& Index);
 void PrintOut(const VARIANT& From, const VARIANT& To, const VARIANT& Copies, const VARIANT& Preview, const VARIANT& ActivePrinter, const VARIANT& PrintToFile, const VARIANT& Collate, const VARIANT& PrToFileName);
};
/
// _Worksheet wrapper class

class _Worksheet : public COleDispatchDriver
{
public:
 _Worksheet() {}  // Calls COleDispatchDriver default constructor
 _Worksheet(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
 _Worksheet(const _Worksheet& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}

// Attributes
public:

// Operations
public:
 LPDISPATCH GetApplication();
 long GetCreator();
 LPDISPATCH GetParent();
 void Activate();
 void Copy(const VARIANT& Before, const VARIANT& After);
 void Delete();
 CString GetCodeName();
 CString Get_CodeName();
 void Set_CodeName(LPCTSTR lpszNewValue);
 long GetIndex();
 void Move(const VARIANT& Before, const VARIANT& After);
 CString GetName();
 void SetName(LPCTSTR lpszNewValue);
 LPDISPATCH GetNext();
 LPDISPATCH GetPageSetup();
 LPDISPATCH GetPrevious();
 void PrintPreview(const VARIANT& EnableChanges);
 BOOL GetProtectContents();
 BOOL GetProtectDrawingObjects();
 BOOL GetProtectionMode();
 BOOL GetProtectScenarios();
 void Select(const VARIANT& Replace);
 void Unprotect(const VARIANT& Password);
 long GetVisible();
 void SetVisible(long nNewValue);
 LPDISPATCH GetShapes();
 BOOL GetTransitionExpEval();
 void SetTransitionExpEval(BOOL bNewValue);
 BOOL GetAutoFilterMode();
 void SetAutoFilterMode(BOOL bNewValue);
 void SetBackgroundPicture(LPCTSTR Filename);
 void Calculate();
 BOOL GetEnableCalculation();
 void SetEnableCalculation(BOOL bNewValue);
 LPDISPATCH GetCells();
 LPDISPATCH ChartObjects(const VARIANT& Index);
 void CheckSpelling(const VARIANT& CustomDictionary, const VARIANT& IgnoreUppercase, const VARIANT& AlwaysSuggest, const VARIANT& SpellLang);
 LPDISPATCH GetCircularReference();
 void ClearArrows();
 LPDISPATCH GetColumns();
 long GetConsolidationFunction();
 VARIANT GetConsolidationOptions();
 VARIANT GetConsolidationSources();
 BOOL GetEnableAutoFilter();
 void SetEnableAutoFilter(BOOL bNewValue);
 long GetEnableSelection();
 void SetEnableSelection(long nNewValue);
 BOOL GetEnableOutlining();
 void SetEnableOutlining(BOOL bNewValue);
 BOOL GetEnablePivotTable();
 void SetEnablePivotTable(BOOL bNewValue);
 VARIANT Evaluate(const VARIANT& Name);
 VARIANT _Evaluate(const VARIANT& Name);
 BOOL GetFilterMode();
 void ResetAllPageBreaks();
 LPDISPATCH GetNames();
 LPDISPATCH OLEObjects(const VARIANT& Index);
 LPDISPATCH GetOutline();
 void Paste(const VARIANT& Destination, const VARIANT& Link);
 LPDISPATCH PivotTables(const VARIANT& Index);
 LPDISPATCH PivotTableWizard(const VARIANT& SourceType, const VARIANT& SourceData, const VARIANT& TableDestination, const VARIANT& TableName, const VARIANT& RowGrand, const VARIANT& ColumnGrand, const VARIANT& SaveData,
  const VARIANT& HasAutoFormat, const VARIANT& AutoPage, const VARIANT& Reserved, const VARIANT& BackgroundQuery, const VARIANT& OptimizeCache, const VARIANT& PageFieldOrder, const VARIANT& PageFieldWrapCount, const VARIANT& ReadData,
  const VARIANT& Connection);
 LPDISPATCH GetRange(const VARIANT& Cell1, const VARIANT& Cell2);
 LPDISPATCH GetRows();
 LPDISPATCH Scenarios(const VARIANT& Index);
 CString GetScrollArea();
 void SetScrollArea(LPCTSTR lpszNewValue);
 void ShowAllData();
 void ShowDataForm();
 double GetStandardHeight();
 double GetStandardWidth();
 void SetStandardWidth(double newValue);
 BOOL GetTransitionFormEntry();
 void SetTransitionFormEntry(BOOL bNewValue);
 long GetType();
 LPDISPATCH GetUsedRange();
 LPDISPATCH GetHPageBreaks();
 LPDISPATCH GetVPageBreaks();
 LPDISPATCH GetQueryTables();
 BOOL GetDisplayPageBreaks();
 void SetDisplayPageBreaks(BOOL bNewValue);
 LPDISPATCH GetComments();
 LPDISPATCH GetHyperlinks();
 void ClearCircles();
 void CircleInvalid();
 LPDISPATCH GetAutoFilter();
 BOOL GetDisplayRightToLeft();
 void SetDisplayRightToLeft(BOOL bNewValue);
 LPDISPATCH GetScripts();
 void PrintOut(const VARIANT& From, const VARIANT& To, const VARIANT& Copies, const VARIANT& Preview, const VARIANT& ActivePrinter, const VARIANT& PrintToFile, const VARIANT& Collate, const VARIANT& PrToFileName);
 LPDISPATCH GetTab();
 LPDISPATCH GetMailEnvelope();
 void SaveAs(LPCTSTR Filename, const VARIANT& FileFormat, const VARIANT& Password, const VARIANT& WriteResPassword, const VARIANT& ReadOnlyRecommended, const VARIANT& CreateBackup, const VARIANT& AddToMru, const VARIANT& TextCodepage,
  const VARIANT& TextVisualLayout, const VARIANT& Local);
 LPDISPATCH GetCustomProperties();
 LPDISPATCH GetSmartTags();
 LPDISPATCH GetProtection();
 void PasteSpecial(const VARIANT& Format, const VARIANT& Link, const VARIANT& DisplayAsIcon, const VARIANT& IconFileName, const VARIANT& IconIndex, const VARIANT& IconLabel, const VARIANT& NoHTMLFormatting);
 void Protect(const VARIANT& Password, const VARIANT& DrawingObjects, const VARIANT& Contents, const VARIANT& Scenarios, const VARIANT& UserInterfaceOnly, const VARIANT& AllowFormattingCells, const VARIANT& AllowFormattingColumns,
  const VARIANT& AllowFormattingRows, const VARIANT& AllowInsertingColumns, const VARIANT& AllowInsertingRows, const VARIANT& AllowInsertingHyperlinks, const VARIANT& AllowDeletingColumns, const VARIANT& AllowDeletingRows,
  const VARIANT& AllowSorting, const VARIANT& AllowFiltering, const VARIANT& AllowUsingPivotTables);
 LPDISPATCH GetListObjects();
 LPDISPATCH XmlDataQuery(LPCTSTR XPath, const VARIANT& SelectionNamespaces, const VARIANT& Map);
 LPDISPATCH XmlMapQuery(LPCTSTR XPath, const VARIANT& SelectionNamespaces, const VARIANT& Map);
};
/
// _Workbook wrapper class

class _Workbook : public COleDispatchDriver
{
public:
 _Workbook() {}  // Calls COleDispatchDriver default constructor
 _Workbook(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
 _Workbook(const _Workbook& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}

// Attributes
public:

// Operations
public:
 LPDISPATCH GetApplication();
 long GetCreator();
 LPDISPATCH GetParent();
 BOOL GetAcceptLabelsInFormulas();
 void SetAcceptLabelsInFormulas(BOOL bNewValue);
 void Activate();
 LPDISPATCH GetActiveChart();
 LPDISPATCH GetActiveSheet();
 long GetAutoUpdateFrequency();
 void SetAutoUpdateFrequency(long nNewValue);
 BOOL GetAutoUpdateSaveChanges();
 void SetAutoUpdateSaveChanges(BOOL bNewValue);
 long GetChangeHistoryDuration();
 void SetChangeHistoryDuration(long nNewValue);
 LPDISPATCH GetBuiltinDocumentProperties();
 void ChangeFileAccess(long Mode, const VARIANT& WritePassword, const VARIANT& Notify);
 void ChangeLink(LPCTSTR Name, LPCTSTR NewName, long Type);
 LPDISPATCH GetCharts();
 void Close(const VARIANT& SaveChanges, const VARIANT& Filename, const VARIANT& RouteWorkbook);
 CString GetCodeName();
 CString Get_CodeName();
 void Set_CodeName(LPCTSTR lpszNewValue);
 VARIANT GetColors(const VARIANT& Index);
 void SetColors(const VARIANT& Index, const VARIANT& newValue);
 LPDISPATCH GetCommandBars();
 long GetConflictResolution();
 void SetConflictResolution(long nNewValue);
 LPDISPATCH GetContainer();
 BOOL GetCreateBackup();
 LPDISPATCH GetCustomDocumentProperties();
 BOOL GetDate1904();
 void SetDate1904(BOOL bNewValue);
 void DeleteNumberFormat(LPCTSTR NumberFormat);
 long GetDisplayDrawingObjects();
 void SetDisplayDrawingObjects(long nNewValue);
 BOOL ExclusiveAccess();
 long GetFileFormat();
 void ForwardMailer();
 CString GetFullName();
 BOOL GetHasPassword();
 BOOL GetHasRoutingSlip();
 void SetHasRoutingSlip(BOOL bNewValue);
 BOOL GetIsAddin();
 void SetIsAddin(BOOL bNewValue);
 VARIANT LinkInfo(LPCTSTR Name, long LinkInfo, const VARIANT& Type, const VARIANT& EditionRef);
 VARIANT LinkSources(const VARIANT& Type);
 LPDISPATCH GetMailer();
 void MergeWorkbook(const VARIANT& Filename);
 BOOL GetMultiUserEditing();
 CString GetName();
 LPDISPATCH GetNames();
 LPDISPATCH NewWindow();
 void OpenLinks(LPCTSTR Name, const VARIANT& ReadOnly, const VARIANT& Type);
 CString GetPath();
 BOOL GetPersonalViewListSettings();
 void SetPersonalViewListSettings(BOOL bNewValue);
 BOOL GetPersonalViewPrintSettings();
 void SetPersonalViewPrintSettings(BOOL bNewValue);
 LPDISPATCH PivotCaches();
 void Post(const VARIANT& DestName);
 BOOL GetPrecisionAsDisplayed();
 void SetPrecisionAsDisplayed(BOOL bNewValue);
 void PrintPreview(const VARIANT& EnableChanges);
 void ProtectSharing(const VARIANT& Filename, const VARIANT& Password, const VARIANT& WriteResPassword, const VARIANT& ReadOnlyRecommended, const VARIANT& CreateBackup, const VARIANT& SharingPassword);
 BOOL GetProtectStructure();
 BOOL GetProtectWindows();
 BOOL GetReadOnly();
 void RefreshAll();
 void Reply();
 void ReplyAll();
 void RemoveUser(long Index);
 long GetRevisionNumber();
 void Route();
 BOOL GetRouted();
 LPDISPATCH GetRoutingSlip();
 void RunAutoMacros(long Which);
 void Save();
 void SaveCopyAs(const VARIANT& Filename);
 BOOL GetSaved();
 void SetSaved(BOOL bNewValue);
 BOOL GetSaveLinkValues();
 void SetSaveLinkValues(BOOL bNewValue);
 void SendMail(const VARIANT& Recipients, const VARIANT& Subject, const VARIANT& ReturnReceipt);
 void SendMailer(const VARIANT& FileFormat, long Priority);
 void SetLinkOnData(LPCTSTR Name, const VARIANT& Procedure);
 LPDISPATCH GetSheets();
 BOOL GetShowConflictHistory();
 void SetShowConflictHistory(BOOL bNewValue);
 LPDISPATCH GetStyles();
 void Unprotect(const VARIANT& Password);
 void UnprotectSharing(const VARIANT& SharingPassword);
 void UpdateFromFile();
 void UpdateLink(const VARIANT& Name, const VARIANT& Type);
 BOOL GetUpdateRemoteReferences();
 void SetUpdateRemoteReferences(BOOL bNewValue);
 VARIANT GetUserStatus();
 LPDISPATCH GetCustomViews();
 LPDISPATCH GetWindows();
 LPDISPATCH GetWorksheets();
 BOOL GetWriteReserved();
 CString GetWriteReservedBy();
 LPDISPATCH GetExcel4IntlMacroSheets();
 LPDISPATCH GetExcel4MacroSheets();
 BOOL GetTemplateRemoveExtData();
 void SetTemplateRemoveExtData(BOOL bNewValue);
 void HighlightChangesOptions(const VARIANT& When, const VARIANT& Who, const VARIANT& Where);
 BOOL GetHighlightChangesOnScreen();
 void SetHighlightChangesOnScreen(BOOL bNewValue);
 BOOL GetKeepChangeHistory();
 void SetKeepChangeHistory(BOOL bNewValue);
 BOOL GetListChangesOnNewSheet();
 void SetListChangesOnNewSheet(BOOL bNewValue);
 void PurgeChangeHistoryNow(long Days, const VARIANT& SharingPassword);
 void AcceptAllChanges(const VARIANT& When, const VARIANT& Who, const VARIANT& Where);
 void RejectAllChanges(const VARIANT& When, const VARIANT& Who, const VARIANT& Where);
 void ResetColors();
 LPDISPATCH GetVBProject();
 void FollowHyperlink(LPCTSTR Address, const VARIANT& SubAddress, const VARIANT& NewWindow, const VARIANT& AddHistory, const VARIANT& ExtraInfo, const VARIANT& Method, const VARIANT& HeaderInfo);
 void AddToFavorites();
 BOOL GetIsInplace();
 void PrintOut(const VARIANT& From, const VARIANT& To, const VARIANT& Copies, const VARIANT& Preview, const VARIANT& ActivePrinter, const VARIANT& PrintToFile, const VARIANT& Collate, const VARIANT& PrToFileName);
 void WebPagePreview();
 LPDISPATCH GetPublishObjects();
 LPDISPATCH GetWebOptions();
 void ReloadAs(long Encoding);
 LPDISPATCH GetHTMLProject();
 BOOL GetEnvelopeVisible();
 void SetEnvelopeVisible(BOOL bNewValue);
 long GetCalculationVersion();
 BOOL GetVBASigned();
 BOOL GetShowPivotTableFieldList();
 void SetShowPivotTableFieldList(BOOL bNewValue);
 long GetUpdateLinks();
 void SetUpdateLinks(long nNewValue);
 void BreakLink(LPCTSTR Name, long Type);
 void SaveAs(const VARIANT& Filename, const VARIANT& FileFormat, const VARIANT& Password, const VARIANT& WriteResPassword, const VARIANT& ReadOnlyRecommended, const VARIANT& CreateBackup, long AccessMode, const VARIANT& ConflictResolution,
  const VARIANT& AddToMru, const VARIANT& TextCodepage, const VARIANT& TextVisualLayout, const VARIANT& Local);
 BOOL GetEnableAutoRecover();
 void SetEnableAutoRecover(BOOL bNewValue);
 BOOL GetRemovePersonalInformation();
 void SetRemovePersonalInformation(BOOL bNewValue);
 CString GetFullNameURLEncoded();
 void CheckIn(const VARIANT& SaveChanges, const VARIANT& Comments, const VARIANT& MakePublic);
 BOOL CanCheckIn();
 void SendForReview(const VARIANT& Recipients, const VARIANT& Subject, const VARIANT& ShowMessage, const VARIANT& IncludeAttachment);
 void ReplyWithChanges(const VARIANT& ShowMessage);
 void EndReview();
 CString GetPassword();
 void SetPassword(LPCTSTR lpszNewValue);
 CString GetWritePassword();
 void SetWritePassword(LPCTSTR lpszNewValue);
 CString GetPasswordEncryptionProvider();
 CString GetPasswordEncryptionAlgorithm();
 long GetPasswordEncryptionKeyLength();
 void SetPasswordEncryptionOptions(const VARIANT& PasswordEncryptionProvider, const VARIANT& PasswordEncryptionAlgorithm, const VARIANT& PasswordEncryptionKeyLength, const VARIANT& PasswordEncryptionFileProperties);
 BOOL GetPasswordEncryptionFileProperties();
 BOOL GetReadOnlyRecommended();
 void SetReadOnlyRecommended(BOOL bNewValue);
 void Protect(const VARIANT& Password, const VARIANT& Structure, const VARIANT& Windows);
 LPDISPATCH GetSmartTagOptions();
 void RecheckSmartTags();
 LPDISPATCH GetPermission();
 LPDISPATCH GetSharedWorkspace();
 LPDISPATCH GetSync();
 void SendFaxOverInternet(const VARIANT& Recipients, const VARIANT& Subject, const VARIANT& ShowMessage);
 LPDISPATCH GetXmlNamespaces();
 LPDISPATCH GetXmlMaps();
 long XmlImport(LPCTSTR Url, LPDISPATCH* ImportMap, const VARIANT& Overwrite, const VARIANT& Destination);
 LPDISPATCH GetSmartDocument();
 LPDISPATCH GetDocumentLibraryVersions();
 BOOL GetInactiveListBorderVisible();
 void SetInactiveListBorderVisible(BOOL bNewValue);
 BOOL GetDisplayInkComments();
 void SetDisplayInkComments(BOOL bNewValue);
 long XmlImportXml(LPCTSTR Data, LPDISPATCH* ImportMap, const VARIANT& Overwrite, const VARIANT& Destination);
 void SaveAsXMLData(LPCTSTR Filename, LPDISPATCH Map);
 void ToggleFormsDesign();
};
/
// Workbooks wrapper class

class Workbooks : public COleDispatchDriver
{
public:
 Workbooks() {}  // Calls COleDispatchDriver default constructor
 Workbooks(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
 Workbooks(const Workbooks& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}

// Attributes
public:

// Operations
public:
 LPDISPATCH GetApplication();
 long GetCreator();
 LPDISPATCH GetParent();
 LPDISPATCH Add(const VARIANT& Template);
 void Close();
 long GetCount();
 LPDISPATCH GetItem(const VARIANT& Index);
 LPUNKNOWN Get_NewEnum();
 LPDISPATCH Get_Default(const VARIANT& Index);
 LPDISPATCH Open(LPCTSTR Filename, const VARIANT& UpdateLinks, const VARIANT& ReadOnly, const VARIANT& Format, const VARIANT& Password, const VARIANT& WriteResPassword, const VARIANT& IgnoreReadOnlyRecommended, const VARIANT& Origin,
  const VARIANT& Delimiter, const VARIANT& Editable, const VARIANT& Notify, const VARIANT& Converter, const VARIANT& AddToMru, const VARIANT& Local, const VARIANT& CorruptLoad);
 void OpenText(LPCTSTR Filename, const VARIANT& Origin, const VARIANT& StartRow, const VARIANT& DataType, long TextQualifier, const VARIANT& ConsecutiveDelimiter, const VARIANT& Tab, const VARIANT& Semicolon, const VARIANT& Comma,
  const VARIANT& Space, const VARIANT& Other, const VARIANT& OtherChar, const VARIANT& FieldInfo, const VARIANT& TextVisualLayout, const VARIANT& DecimalSeparator, const VARIANT& ThousandsSeparator, const VARIANT& TrailingMinusNumbers,
  const VARIANT& Local);
 LPDISPATCH OpenDatabase(LPCTSTR Filename, const VARIANT& CommandText, const VARIANT& CommandType, const VARIANT& BackgroundQuery, const VARIANT& ImportDataAs);
 void CheckOut(LPCTSTR Filename);
 BOOL CanCheckOut(LPCTSTR Filename);
 LPDISPATCH OpenXML(LPCTSTR Filename, const VARIANT& Stylesheets, const VARIANT& LoadOption);
};
/
// Range wrapper class

class Range : public COleDispatchDriver
{
public:
 Range() {}  // Calls COleDispatchDriver default constructor
 Range(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
 Range(const Range& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}

// Attributes
public:

// Operations
public:
 LPDISPATCH GetApplication();
 long GetCreator();
 LPDISPATCH GetParent();
 VARIANT Activate();
 VARIANT GetAddIndent();
 void SetAddIndent(const VARIANT& newValue);
 CString GetAddress(const VARIANT& RowAbsolute, const VARIANT& ColumnAbsolute, long ReferenceStyle, const VARIANT& External, const VARIANT& RelativeTo);
 CString GetAddressLocal(const VARIANT& RowAbsolute, const VARIANT& ColumnAbsolute, long ReferenceStyle, const VARIANT& External, const VARIANT& RelativeTo);
 VARIANT AdvancedFilter(long Action, const VARIANT& CriteriaRange, const VARIANT& CopyToRange, const VARIANT& Unique);
 VARIANT ApplyNames(const VARIANT& Names, const VARIANT& IgnoreRelativeAbsolute, const VARIANT& UseRowColumnNames, const VARIANT& OmitColumn, const VARIANT& OmitRow, long Order, const VARIANT& AppendLast);
 VARIANT ApplyOutlineStyles();
 LPDISPATCH GetAreas();
 CString AutoComplete(LPCTSTR String);
 VARIANT AutoFill(LPDISPATCH Destination, long Type);
 VARIANT AutoFilter(const VARIANT& Field, const VARIANT& Criteria1, long Operator, const VARIANT& Criteria2, const VARIANT& VisibleDropDown);
 VARIANT AutoFit();
 VARIANT AutoFormat(long Format, const VARIANT& Number, const VARIANT& Font, const VARIANT& Alignment, const VARIANT& Border, const VARIANT& Pattern, const VARIANT& Width);
 VARIANT AutoOutline();
 VARIANT BorderAround(const VARIANT& LineStyle, long Weight, long ColorIndex, const VARIANT& Color);
 LPDISPATCH GetBorders();
 VARIANT Calculate();
 LPDISPATCH GetCells();
 LPDISPATCH GetCharacters(const VARIANT& Start, const VARIANT& Length);
 VARIANT CheckSpelling(const VARIANT& CustomDictionary, const VARIANT& IgnoreUppercase, const VARIANT& AlwaysSuggest, const VARIANT& SpellLang);
 VARIANT Clear();
 VARIANT ClearContents();
 VARIANT ClearFormats();
 VARIANT ClearNotes();
 VARIANT ClearOutline();
 long GetColumn();
 LPDISPATCH ColumnDifferences(const VARIANT& Comparison);
 LPDISPATCH GetColumns();
 VARIANT GetColumnWidth();
 void SetColumnWidth(const VARIANT& newValue);
 VARIANT Consolidate(const VARIANT& Sources, const VARIANT& Function, const VARIANT& TopRow, const VARIANT& LeftColumn, const VARIANT& CreateLinks);
 VARIANT Copy(const VARIANT& Destination);
 long CopyFromRecordset(LPUNKNOWN Data, const VARIANT& MaxRows, const VARIANT& MaxColumns);
 VARIANT CopyPicture(long Appearance, long Format);
 long GetCount();
 VARIANT CreateNames(const VARIANT& Top, const VARIANT& Left, const VARIANT& Bottom, const VARIANT& Right);
 VARIANT CreatePublisher(const VARIANT& Edition, long Appearance, const VARIANT& ContainsPICT, const VARIANT& ContainsBIFF, const VARIANT& ContainsRTF, const VARIANT& ContainsVALU);
 LPDISPATCH GetCurrentArray();
 LPDISPATCH GetCurrentRegion();
 VARIANT Cut(const VARIANT& Destination);
 VARIANT DataSeries(const VARIANT& Rowcol, long Type, long Date, const VARIANT& Step, const VARIANT& Stop, const VARIANT& Trend);
 VARIANT Get_Default(const VARIANT& RowIndex, const VARIANT& ColumnIndex);
 void Set_Default(const VARIANT& RowIndex, const VARIANT& ColumnIndex, const VARIANT& newValue);
 VARIANT Delete(const VARIANT& Shift);
 LPDISPATCH GetDependents();
 VARIANT DialogBox_();
 LPDISPATCH GetDirectDependents();
 LPDISPATCH GetDirectPrecedents();
 VARIANT EditionOptions(long Type, long Option, const VARIANT& Name, const VARIANT& Reference, long Appearance, long ChartSize, const VARIANT& Format);
 LPDISPATCH GetEnd(long Direction);
 LPDISPATCH GetEntireColumn();
 LPDISPATCH GetEntireRow();
 VARIANT FillDown();
 VARIANT FillLeft();
 VARIANT FillRight();
 VARIANT FillUp();
 LPDISPATCH Find(const VARIANT& What, const VARIANT& After, const VARIANT& LookIn, const VARIANT& LookAt, const VARIANT& SearchOrder, long SearchDirection, const VARIANT& MatchCase, const VARIANT& MatchByte, const VARIANT& SearchFormat);
 LPDISPATCH FindNext(const VARIANT& After);
 LPDISPATCH FindPrevious(const VARIANT& After);
 LPDISPATCH GetFont();
 VARIANT GetFormula();
 void SetFormula(const VARIANT& newValue);
 VARIANT GetFormulaArray();
 void SetFormulaArray(const VARIANT& newValue);
 long GetFormulaLabel();
 void SetFormulaLabel(long nNewValue);
 VARIANT GetFormulaHidden();
 void SetFormulaHidden(const VARIANT& newValue);
 VARIANT GetFormulaLocal();
 void SetFormulaLocal(const VARIANT& newValue);
 VARIANT GetFormulaR1C1();
 void SetFormulaR1C1(const VARIANT& newValue);
 VARIANT GetFormulaR1C1Local();
 void SetFormulaR1C1Local(const VARIANT& newValue);
 VARIANT FunctionWizard();
 BOOL GoalSeek(const VARIANT& Goal, LPDISPATCH ChangingCell);
 VARIANT Group(const VARIANT& Start, const VARIANT& End, const VARIANT& By, const VARIANT& Periods);
 VARIANT GetHasArray();
 VARIANT GetHasFormula();
 VARIANT GetHeight();
 VARIANT GetHidden();
 void SetHidden(const VARIANT& newValue);
 VARIANT GetHorizontalAlignment();
 void SetHorizontalAlignment(const VARIANT& newValue);
 VARIANT GetIndentLevel();
 void SetIndentLevel(const VARIANT& newValue);
 void InsertIndent(long InsertAmount);
 VARIANT Insert(const VARIANT& Shift, const VARIANT& CopyOrigin);
 LPDISPATCH GetInterior();
 VARIANT GetItem(const VARIANT& RowIndex, const VARIANT& ColumnIndex);
 void SetItem(const VARIANT& RowIndex, const VARIANT& ColumnIndex, const VARIANT& newValue);
 VARIANT Justify();
 VARIANT GetLeft();
 long GetListHeaderRows();
 VARIANT ListNames();
 long GetLocationInTable();
 VARIANT GetLocked();
 void SetLocked(const VARIANT& newValue);
 void Merge(const VARIANT& Across);
 void UnMerge();
 LPDISPATCH GetMergeArea();
 VARIANT GetMergeCells();
 void SetMergeCells(const VARIANT& newValue);
 VARIANT GetName();
 void SetName(const VARIANT& newValue);
 VARIANT NavigateArrow(const VARIANT& TowardPrecedent, const VARIANT& ArrowNumber, const VARIANT& LinkNumber);
 LPUNKNOWN Get_NewEnum();
 LPDISPATCH GetNext();
 CString NoteText(const VARIANT& Text, const VARIANT& Start, const VARIANT& Length);
 VARIANT GetNumberFormat();
 void SetNumberFormat(const VARIANT& newValue);
 VARIANT GetNumberFormatLocal();
 void SetNumberFormatLocal(const VARIANT& newValue);
 LPDISPATCH GetOffset(const VARIANT& RowOffset, const VARIANT& ColumnOffset);
 VARIANT GetOrientation();
 void SetOrientation(const VARIANT& newValue);
 VARIANT GetOutlineLevel();
 void SetOutlineLevel(const VARIANT& newValue);
 long GetPageBreak();
 void SetPageBreak(long nNewValue);
 VARIANT Parse(const VARIANT& ParseLine, const VARIANT& Destination);
 LPDISPATCH GetPivotField();
 LPDISPATCH GetPivotItem();
 LPDISPATCH GetPivotTable();
 LPDISPATCH GetPrecedents();
 VARIANT GetPrefixCharacter();
 LPDISPATCH GetPrevious();
 VARIANT _PrintOut(const VARIANT& From, const VARIANT& To, const VARIANT& Copies, const VARIANT& Preview, const VARIANT& ActivePrinter, const VARIANT& PrintToFile, const VARIANT& Collate);
 VARIANT PrintPreview(const VARIANT& EnableChanges);
 LPDISPATCH GetQueryTable();
 LPDISPATCH GetRange(const VARIANT& Cell1, const VARIANT& Cell2);
 VARIANT RemoveSubtotal();
 BOOL Replace(const VARIANT& What, const VARIANT& Replacement, const VARIANT& LookAt, const VARIANT& SearchOrder, const VARIANT& MatchCase, const VARIANT& MatchByte, const VARIANT& SearchFormat, const VARIANT& ReplaceFormat);
 LPDISPATCH GetResize(const VARIANT& RowSize, const VARIANT& ColumnSize);
 long GetRow();
 LPDISPATCH RowDifferences(const VARIANT& Comparison);
 VARIANT GetRowHeight();
 void SetRowHeight(const VARIANT& newValue);
 LPDISPATCH GetRows();
 VARIANT Run(const VARIANT& Arg1, const VARIANT& Arg2, const VARIANT& Arg3, const VARIANT& Arg4, const VARIANT& Arg5, const VARIANT& Arg6, const VARIANT& Arg7, const VARIANT& Arg8, const VARIANT& Arg9, const VARIANT& Arg10,
  const VARIANT& Arg11, const VARIANT& Arg12, const VARIANT& Arg13, const VARIANT& Arg14, const VARIANT& Arg15, const VARIANT& Arg16, const VARIANT& Arg17, const VARIANT& Arg18, const VARIANT& Arg19, const VARIANT& Arg20,
  const VARIANT& Arg21, const VARIANT& Arg22, const VARIANT& Arg23, const VARIANT& Arg24, const VARIANT& Arg25, const VARIANT& Arg26, const VARIANT& Arg27, const VARIANT& Arg28, const VARIANT& Arg29, const VARIANT& Arg30);
 VARIANT Select();
 VARIANT Show();
 VARIANT ShowDependents(const VARIANT& Remove);
 VARIANT GetShowDetail();
 void SetShowDetail(const VARIANT& newValue);
 VARIANT ShowErrors();
 VARIANT ShowPrecedents(const VARIANT& Remove);
 VARIANT GetShrinkToFit();
 void SetShrinkToFit(const VARIANT& newValue);
 VARIANT Sort(const VARIANT& Key1, long Order1, const VARIANT& Key2, const VARIANT& Type, long Order2, const VARIANT& Key3, long Order3, long Header, const VARIANT& OrderCustom, const VARIANT& MatchCase, long Orientation, long SortMethod,
  long DataOption1, long DataOption2, long DataOption3);
 VARIANT SortSpecial(long SortMethod, const VARIANT& Key1, long Order1, const VARIANT& Type, const VARIANT& Key2, long Order2, const VARIANT& Key3, long Order3, long Header, const VARIANT& OrderCustom, const VARIANT& MatchCase,
  long Orientation, long DataOption1, long DataOption2, long DataOption3);
 LPDISPATCH GetSoundNote();
 LPDISPATCH SpecialCells(long Type, const VARIANT& Value);
 VARIANT GetStyle();
 void SetStyle(const VARIANT& newValue);
 VARIANT SubscribeTo(LPCTSTR Edition, long Format);
 VARIANT Subtotal(long GroupBy, long Function, const VARIANT& TotalList, const VARIANT& Replace, const VARIANT& PageBreaks, long SummaryBelowData);
 VARIANT GetSummary();
 VARIANT Table(const VARIANT& RowInput, const VARIANT& ColumnInput);
 VARIANT GetText();
 VARIANT TextToColumns(const VARIANT& Destination, long DataType, long TextQualifier, const VARIANT& ConsecutiveDelimiter, const VARIANT& Tab, const VARIANT& Semicolon, const VARIANT& Comma, const VARIANT& Space, const VARIANT& Other,
  const VARIANT& OtherChar, const VARIANT& FieldInfo, const VARIANT& DecimalSeparator, const VARIANT& ThousandsSeparator, const VARIANT& TrailingMinusNumbers);
 VARIANT GetTop();
 VARIANT Ungroup();
 VARIANT GetUseStandardHeight();
 void SetUseStandardHeight(const VARIANT& newValue);
 VARIANT GetUseStandardWidth();
 void SetUseStandardWidth(const VARIANT& newValue);
 LPDISPATCH GetValidation();
 VARIANT GetValue(const VARIANT& RangeValueDataType);
 void SetValue(const VARIANT& RangeValueDataType, const VARIANT& newValue);
 VARIANT GetValue2();
 void SetValue2(const VARIANT& newValue);
 VARIANT GetVerticalAlignment();
 void SetVerticalAlignment(const VARIANT& newValue);
 VARIANT GetWidth();
 LPDISPATCH GetWorksheet();
 VARIANT GetWrapText();
 void SetWrapText(const VARIANT& newValue);
 LPDISPATCH AddComment(const VARIANT& Text);
 LPDISPATCH GetComment();
 void ClearComments();
 LPDISPATCH GetPhonetic();
 LPDISPATCH GetFormatConditions();
 long GetReadingOrder();
 void SetReadingOrder(long nNewValue);
 LPDISPATCH GetHyperlinks();
 LPDISPATCH GetPhonetics();
 void SetPhonetic();
 CString GetId();
 void SetId(LPCTSTR lpszNewValue);
 VARIANT PrintOut(const VARIANT& From, const VARIANT& To, const VARIANT& Copies, const VARIANT& Preview, const VARIANT& ActivePrinter, const VARIANT& PrintToFile, const VARIANT& Collate, const VARIANT& PrToFileName);
 LPDISPATCH GetPivotCell();
 void Dirty();
 LPDISPATCH GetErrors();
 LPDISPATCH GetSmartTags();
 void Speak(const VARIANT& SpeakDirection, const VARIANT& SpeakFormulas);
 VARIANT PasteSpecial(long Paste, long Operation, const VARIANT& SkipBlanks, const VARIANT& Transpose);
 BOOL GetAllowEdit();
 LPDISPATCH GetListObject();
 LPDISPATCH GetXPath();
};
/
// AddIn wrapper class

class AddIn : public COleDispatchDriver
{
public:
 AddIn() {}  // Calls COleDispatchDriver default constructor
 AddIn(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
 AddIn(const AddIn& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}

// Attributes
public:

// Operations
public:
 LPDISPATCH GetApplication();
 long GetCreator();
 LPDISPATCH GetParent();
 CString GetFullName();
 BOOL GetInstalled();
 void SetInstalled(BOOL bNewValue);
 CString GetName();
 CString GetPath();
 CString GetProgID();
 CString GetClsid();
};
/
// AddIns wrapper class

class AddIns : public COleDispatchDriver
{
public:
 AddIns() {}  // Calls COleDispatchDriver default constructor
 AddIns(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
 AddIns(const AddIns& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}

// Attributes
public:

// Operations
public:
 LPDISPATCH GetApplication();
 long GetCreator();
 LPDISPATCH GetParent();
 LPDISPATCH Add(LPCTSTR Filename, const VARIANT& CopyFile);
 long GetCount();
 LPDISPATCH GetItem(const VARIANT& Index);
 LPUNKNOWN Get_NewEnum();
 LPDISPATCH Get_Default(const VARIANT& Index);
};
/
// Worksheets wrapper class

class Worksheets : public COleDispatchDriver
{
public:
 Worksheets() {}  // Calls COleDispatchDriver default constructor
 Worksheets(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
 Worksheets(const Worksheets& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}

// Attributes
public:

// Operations
public:
 LPDISPATCH GetApplication();
 long GetCreator();
 LPDISPATCH GetParent();
 LPDISPATCH Add(const VARIANT& Before, const VARIANT& After, const VARIANT& Count, const VARIANT& Type);
 void Copy(const VARIANT& Before, const VARIANT& After);
 long GetCount();
 void Delete();
 void FillAcrossSheets(LPDISPATCH Range, long Type);
 LPDISPATCH GetItem(const VARIANT& Index);
 void Move(const VARIANT& Before, const VARIANT& After);
 LPUNKNOWN Get_NewEnum();
 void PrintPreview(const VARIANT& EnableChanges);
 void Select(const VARIANT& Replace);
 LPDISPATCH GetHPageBreaks();
 LPDISPATCH GetVPageBreaks();
 VARIANT GetVisible();
 void SetVisible(const VARIANT& newValue);
 LPDISPATCH Get_Default(const VARIANT& Index);
 void PrintOut(const VARIANT& From, const VARIANT& To, const VARIANT& Copies, const VARIANT& Preview, const VARIANT& ActivePrinter, const VARIANT& PrintToFile, const VARIANT& Collate, const VARIANT& PrToFileName);
};


亍丌兀丐廿卅丕亘丞鬲孬噩丨禺丿匕乇夭爻卮氐囟胤馗毓睾鼗丶亟鼐乜乩亓芈孛啬嘏仄厍厝厣厥厮靥赝匚叵匦匮匾赜卦卣刂刈刎刭刳刿剀剌剞剡剜蒯剽劂劁劐劓冂罔亻仃仉仂仨仡仫仞伛仳伢佤仵伥伧伉伫佞佧攸佚佝
佟佗伲伽佶佴侑侉侃侏佾佻侪佼侬侔俦俨俪俅俚俣俜俑俟俸倩偌俳倬倏倮倭俾倜倌倥倨偾偃偕偈偎偬偻傥傧傩傺僖儆僭僬僦僮儇儋仝氽佘佥俎龠汆籴兮巽黉馘冁夔勹匍訇匐凫夙兕亠兖亳衮袤亵脔裒禀嬴蠃羸冫冱冽冼
凇冖冢冥讠讦讧讪讴讵讷诂诃诋诏诎诒诓诔诖诘诙诜诟诠诤诨诩诮诰诳诶诹诼诿谀谂谄谇谌谏谑谒谔谕谖谙谛谘谝谟谠谡谥谧谪谫谮谯谲谳谵谶卩卺阝阢阡阱阪阽阼陂陉陔陟陧陬陲陴隈隍隗隰邗邛邝邙邬邡邴邳邶邺
邸邰郏郅邾郐郄郇郓郦郢郜郗郛郫郯郾鄄鄢鄞鄣鄱鄯鄹酃酆刍奂劢劬劭劾哿勐勖勰叟燮矍廴凵凼鬯厶弁畚巯坌垩垡塾墼壅壑圩圬圪圳圹圮圯坜圻坂坩垅坫垆坼坻坨坭坶坳垭垤垌垲埏垧垴垓垠埕埘埚埙埒垸埴埯埸埤埝
堋堍埽埭堀堞堙塄堠塥塬墁墉墚墀馨鼙懿艹艽艿芏芊芨芄芎芑芗芙芫芸芾芰苈苊苣芘芷芮苋苌苁芩芴芡芪芟苄苎芤苡茉苷苤茏茇苜苴苒苘茌苻苓茑茚茆茔茕苠苕茜荑荛荜茈莒茼茴茱莛荞茯荏荇荃荟荀茗荠茭茺茳荦荥
荨茛荩荬荪荭荮莰荸莳莴莠莪莓莜莅荼莶莩荽莸荻莘莞莨莺莼菁萁菥菘堇萘萋菝菽菖萜萸萑萆菔菟萏萃菸菹菪菅菀萦菰菡葜葑葚葙葳蒇蒈葺蒉葸萼葆葩葶蒌蒎萱葭蓁蓍蓐蓦蒽蓓蓊蒿蒺蓠蒡蒹蒴蒗蓥蓣蔌甍蔸蓰蔹蔟蔺
蕖蔻蓿蓼蕙蕈蕨蕤蕞蕺瞢蕃蕲蕻薤薨薇薏蕹薮薜薅薹薷薰藓藁藜藿蘧蘅蘩蘖蘼廾弈夼奁耷奕奚奘匏尢尥尬尴扌扪抟抻拊拚拗拮挢拶挹捋捃掭揶捱捺掎掴捭掬掊捩掮掼揲揸揠揿揄揞揎摒揆掾摅摁搋搛搠搌搦搡摞撄摭撖
摺撷撸撙撺擀擐擗擤擢攉攥攮弋忒甙弑卟叱叽叩叨叻吒吖吆呋呒呓呔呖呃吡呗呙吣吲咂咔呷呱呤咚咛咄呶呦咝哐咭哂咴哒咧咦哓哔呲咣哕咻咿哌哙哚哜咩咪咤哝哏哞唛哧唠哽唔哳唢唣唏唑唧唪啧喏喵啉啭啁啕唿啐唼
唷啖啵啶啷唳唰啜喋嗒喃喱喹喈喁喟啾嗖喑啻嗟喽喾喔喙嗪嗷嗉嘟嗑嗫嗬嗔嗦嗝嗄嗯嗥嗲嗳嗌嗍嗨嗵嗤辔嘞嘈嘌嘁嘤嘣嗾嘀嘧嘭噘嘹噗嘬噍噢噙噜噌噔嚆噤噱噫噻噼嚅嚓嚯囔囗囝囡囵囫囹囿圄圊圉圜帏帙帔帑帱帻帼
帷幄幔幛幞幡岌屺岍岐岖岈岘岙岑岚岜岵岢岽岬岫岱岣峁岷峄峒峤峋峥崂崃崧崦崮崤崞崆崛嵘崾崴崽嵬嵛嵯嵝嵫嵋嵊嵩嵴嶂嶙嶝豳嶷巅彳彷徂徇徉後徕徙徜徨徭徵徼衢彡犭犰犴犷犸狃狁狎狍狒狨狯狩狲狴狷猁狳猃狺
狻猗猓猡猊猞猝猕猢猹猥猬猸猱獐獍獗獠獬獯獾舛夥飧夤夂饣饧饨饩饪饫饬饴饷饽馀馄馇馊馍馐馑馓馔馕庀庑庋庖庥庠庹庵庾庳赓廒廑廛廨廪膺忄忉忖忏怃忮怄忡忤忾怅怆忪忭忸怙怵怦怛怏怍怩怫怊怿怡恸恹恻恺恂
恪恽悖悚悭悝悃悒悌悛惬悻悱惝惘惆惚悴愠愦愕愣惴愀愎愫慊慵憬憔憧憷懔懵忝隳闩闫闱闳闵闶闼闾阃阄阆阈阊阋阌阍阏阒阕阖阗阙阚丬爿戕氵汔汜汊沣沅沐沔沌汨汩汴汶沆沩泐泔沭泷泸泱泗沲泠泖泺泫泮沱泓泯泾
洹洧洌浃浈洇洄洙洎洫浍洮洵洚浏浒浔洳涑浯涞涠浞涓涔浜浠浼浣渚淇淅淞渎涿淠渑淦淝淙渖涫渌涮渫湮湎湫溲湟溆湓湔渲渥湄滟溱溘滠漭滢溥溧溽溻溷滗溴滏溏滂溟潢潆潇漤漕滹漯漶潋潴漪漉漩澉澍澌潸潲潼潺濑
濉澧澹澶濂濡濮濞濠濯瀚瀣瀛瀹瀵灏灞宀宄宕宓宥宸甯骞搴寤寮褰寰蹇謇辶迓迕迥迮迤迩迦迳迨逅逄逋逦逑逍逖逡逵逶逭逯遄遑遒遐遨遘遢遛暹遴遽邂邈邃邋彐彗彖彘尻咫屐屙孱屣屦羼弪弩弭艴弼鬻屮妁妃妍妩妪妣
妗姊妫妞妤姒妲妯姗妾娅娆姝娈姣姘姹娌娉娲娴娑娣娓婀婧婊婕娼婢婵胬媪媛婷婺媾嫫媲嫒嫔媸嫠嫣嫱嫖嫦嫘嫜嬉嬗嬖嬲嬷孀尕尜孚孥孳孑孓孢驵驷驸驺驿驽骀骁骅骈骊骐骒骓骖骘骛骜骝骟骠骢骣骥骧纟纡纣纥纨纩
纭纰纾绀绁绂绉绋绌绐绔绗绛绠绡绨绫绮绯绱绲缍绶绺绻绾缁缂缃缇缈缋缌缏缑缒缗缙缜缛缟缡缢缣缤缥缦缧缪缫缬缭缯缰缱缲缳缵幺畿巛甾邕玎玑玮玢玟珏珂珑玷玳珀珉珈珥珙顼琊珩珧珞玺珲琏琪瑛琦琥琨琰琮琬
琛琚瑁瑜瑗瑕瑙瑷瑭瑾璜璎璀璁璇璋璞璨璩璐璧瓒璺韪韫韬杌杓杞杈杩枥枇杪杳枘枧杵枨枞枭枋杷杼柰栉柘栊柩枰栌柙枵柚枳柝栀柃枸柢栎柁柽栲栳桠桡桎桢桄桤梃栝桕桦桁桧桀栾桊桉栩梵梏桴桷梓桫棂楮棼椟椠棹
椤棰椋椁楗棣椐楱椹楠楂楝榄楫榀榘楸椴槌榇榈槎榉楦楣楹榛榧榻榫榭槔榱槁槊槟榕槠榍槿樯槭樗樘橥槲橄樾檠橐橛樵檎橹樽樨橘橼檑檐檩檗檫猷獒殁殂殇殄殒殓殍殚殛殡殪轫轭轱轲轳轵轶轸轷轹轺轼轾辁辂辄辇辋
辍辎辏辘辚軎戋戗戛戟戢戡戥戤戬臧瓯瓴瓿甏甑甓攴旮旯旰昊昙杲昃昕昀炅曷昝昴昱昶昵耆晟晔晁晏晖晡晗晷暄暌暧暝暾曛曜曦曩贲贳贶贻贽赀赅赆赈赉赇赍赕赙觇觊觋觌觎觏觐觑牮犟牝牦牯牾牿犄犋犍犏犒挈挲掰
搿擘耄毪毳毽毵毹氅氇氆氍氕氘氙氚氡氩氤氪氲攵敕敫牍牒牖爰虢刖肟肜肓肼朊肽肱肫肭肴肷胧胨胩胪胛胂胄胙胍胗朐胝胫胱胴胭脍脎胲胼朕脒豚脶脞脬脘脲腈腌腓腴腙腚腱腠腩腼腽腭腧塍媵膈膂膑滕膣膪臌朦臊膻
臁膦欤欷欹歃歆歙飑飒飓飕飙飚殳彀毂觳斐齑斓於旆旄旃旌旎旒旖炀炜炖炝炻烀炷炫炱烨烊焐焓焖焯焱煳煜煨煅煲煊煸煺熘熳熵熨熠燠燔燧燹爝爨灬焘煦熹戾戽扃扈扉礻祀祆祉祛祜祓祚祢祗祠祯祧祺禅禊禚禧禳忑忐
怼恝恚恧恁恙恣悫愆愍慝憩憝懋懑戆肀聿沓泶淼矶矸砀砉砗砘砑斫砭砜砝砹砺砻砟砼砥砬砣砩硎硭硖硗砦硐硇硌硪碛碓碚碇碜碡碣碲碹碥磔磙磉磬磲礅磴礓礤礞礴龛黹黻黼盱眄眍盹眇眈眚眢眙眭眦眵眸睐睑睇睃睚睨
睢睥睿瞍睽瞀瞌瞑瞟瞠瞰瞵瞽町畀畎畋畈畛畲畹疃罘罡罟詈罨罴罱罹羁罾盍盥蠲钅钆钇钋钊钌钍钏钐钔钗钕钚钛钜钣钤钫钪钭钬钯钰钲钴钶钷钸钹钺钼钽钿铄铈铉铊铋铌铍铎铐铑铒铕铖铗铙铘铛铞铟铠铢铤铥铧铨铪
铩铫铮铯铳铴铵铷铹铼铽铿锃锂锆锇锉锊锍锎锏锒锓锔锕锖锘锛锝锞锟锢锪锫锩锬锱锲锴锶锷锸锼锾锿镂锵镄镅镆镉镌镎镏镒镓镔镖镗镘镙镛镞镟镝镡镢镤镥镦镧镨镩镪镫镬镯镱镲镳锺矧矬雉秕秭秣秫稆嵇稃稂稞稔
稹稷穑黏馥穰皈皎皓皙皤瓞瓠甬鸠鸢鸨鸩鸪鸫鸬鸲鸱鸶鸸鸷鸹鸺鸾鹁鹂鹄鹆鹇鹈鹉鹋鹌鹎鹑鹕鹗鹚鹛鹜鹞鹣鹦鹧鹨鹩鹪鹫鹬鹱鹭鹳疒疔疖疠疝疬疣疳疴疸痄疱疰痃痂痖痍痣痨痦痤痫痧瘃痱痼痿瘐瘀瘅瘌瘗瘊瘥瘘瘕瘙
瘛瘼瘢瘠癀瘭瘰瘿瘵癃瘾瘳癍癞癔癜癖癫癯翊竦穸穹窀窆窈窕窦窠窬窨窭窳衤衩衲衽衿袂袢裆袷袼裉裢裎裣裥裱褚裼裨裾裰褡褙褓褛褊褴褫褶襁襦襻疋胥皲皴矜耒耔耖耜耠耢耥耦耧耩耨耱耋耵聃聆聍聒聩聱覃顸颀颃
颉颌颍颏颔颚颛颞颟颡颢颥颦虍虔虬虮虿虺虼虻蚨蚍蚋蚬蚝蚧蚣蚪蚓蚩蚶蛄蚵蛎蚰蚺蚱蚯蛉蛏蚴蛩蛱蛲蛭蛳蛐蜓蛞蛴蛟蛘蛑蜃蜇蛸蜈蜊蜍蜉蜣蜻蜞蜥蜮蜚蜾蝈蜴蜱蜩蜷蜿螂蜢蝽蝾蝻蝠蝰蝌蝮螋蝓蝣蝼蝤蝙蝥螓螯螨蟒
蟆螈螅螭螗螃螫蟥螬螵螳蟋蟓螽蟑蟀蟊蟛蟪蟠蟮蠖蠓蟾蠊蠛蠡蠹蠼缶罂罄罅舐竺竽笈笃笄笕笊笫笏筇笸笪笙笮笱笠笥笤笳笾笞筘筚筅筵筌筝筠筮筻筢筲筱箐箦箧箸箬箝箨箅箪箜箢箫箴篑篁篌篝篚篥篦篪簌篾篼簏簖簋
簟簪簦簸籁籀臾舁舂舄臬衄舡舢舣舭舯舨舫舸舻舳舴舾艄艉艋艏艚艟艨衾袅袈裘裟襞羝羟羧羯羰羲籼敉粑粝粜粞粢粲粼粽糁糇糌糍糈糅糗糨艮暨羿翎翕翥翡翦翩翮翳糸絷綦綮繇纛麸麴赳趄趔趑趱赧赭豇豉酊酐酎酏酤
酢酡酰酩酯酽酾酲酴酹醌醅醐醍醑醢醣醪醭醮醯醵醴醺豕鹾趸跫踅蹙蹩趵趿趼趺跄跖跗跚跞跎跏跛跆跬跷跸跣跹跻跤踉跽踔踝踟踬踮踣踯踺蹀踹踵踽踱蹉蹁蹂蹑蹒蹊蹰蹶蹼蹯蹴躅躏躔躐躜躞豸貂貊貅貘貔斛觖觞觚觜
觥觫觯訾謦靓雩雳雯霆霁霈霏霎霪霭霰霾龀龃龅龆龇龈龉龊龌黾鼋鼍隹隼隽雎雒瞿雠銎銮鋈錾鍪鏊鎏鐾鑫鱿鲂鲅鲆鲇鲈稣鲋鲎鲐鲑鲒鲔鲕鲚鲛鲞鲟鲠鲡鲢鲣鲥鲦鲧鲨鲩鲫鲭鲮鲰鲱鲲鲳鲴鲵鲶鲷鲺鲻鲼鲽鳄鳅鳆鳇鳊鳋
鳌鳍鳎鳏鳐鳓鳔鳕鳗鳘鳙鳜鳝鳟鳢靼鞅鞑鞒鞔鞯鞫鞣鞲鞴骱骰骷鹘骶骺骼髁髀髅髂髋髌髑魅魃魇魉魈魍魑飨餍餮饕饔髟髡髦髯髫髻髭髹鬈鬏鬓鬟鬣麽麾縻麂麇麈麋麒鏖麝麟黛黜黝黠黟黢黩黧黥黪黯鼢鼬鼯鼹鼷鼽鼾齄


yt_geniu
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
GB2312一二级字库6729个.txt
03-11
GB2312一二级字库共6729个汉字，txt格式
二级字库拼音表
03-25
二级字库拼音表
国标一二级字库12*12,16*16字模，区位码，国标码，内码对照
03-07
excel文档，包含国标一二级字库12*12,16*16字模，区位码，国标码，内码对照，其中各种汉字编码带计算公式，对嵌入式GUI开发很有用
GB2312 一二级中文汉字字库（带拼音）
热门推荐
qq_40443024的博客
05-05 1万+
GB2312 一二级汉字字库 带拼音 单字换行 用于自定义键盘
MFC操作Excel表，excel.h,excel.cpp源码
07-28
MFC操作Excel表，excel.h,excel.cpp源码
MFC操作EXCEL.zip
12-13
在描述中提到的`Excel2010Helper.cpp`和`Excel2010Helper.h`文件中，很可能包含了用于操作Excel的类和方法。这些辅助类通常会封装COM接口，使得调用更简洁、易于管理。 在具体实现中，我们可能会创建一个`...
vs2019直接可以编译执行的mfc操作excel类库
11-01
而“mfc vs2019 excel”这个标签表明我们将讨论如何使用MFC在VS2019中操作Excel。 Excel是Microsoft Office套件中的电子表格应用程序，广泛用于数据处理和分析。通过MFC，我们可以编写C++代码来自动化Excel任务，...
VS使用MFC操作EXCEL,新建编辑保存等操作
10-19
VS 使用 MFC 操作 EXCEL 新建编辑保存等操作 在本文档中，我们将学习如何使用 MFC 操作 EXCEL 文件，实现新建、编辑、保存等操作。我们将使用 Visual Studio 6.0 和 MFC 来实现这些操作。 Step 1: 建立一个自动化...
MFC 操作excel
08-20
本项目重点是利用MFC来操作Excel，同时也涉及到其他一些关键功能，如ListControl、RichEdit2、普通Edit控件、文件遍历、查找文件以及模态与非模态对话框的使用。下面将详细讲解这些知识点。 1. **MFC操作Excel**： ...
汉字二级字库3008txt
07-20
汉字二级字库，一共3008个，txt格式。
完整的一级字库和二级字库
11-20
其中一级字库的最后多了5个座字，是为了方便索引需要，不需要的朋友可删除
excel9.cpp和excel9.h
10-17
win7下OFFCIE2007测试使用可以操作EXCEL表
汉字一级字库与二级字库
rxr1st的专栏
03-14 8655
最近在项目中碰到利用java默认的Collator.getInstance(Locale.China)进行默认的拼音排序时有一部分汉字无法正确的通过默认的排序方式自动进行排序。查询了一下资料，原来问题出现在中文字库上面，默认的一级字库是采用的拼音排序方式，而二级字库中的汉字默认却是采用的部首笔划的顺序排列的。在此将网络上关于汉字的一级字库和二级字库信息的资料做一个小小的总结。 为了使每一个汉字有
MFC 读取EXCEL中数据
wangzhiyang925的专栏
07-08 5104
MFC读取Excel例子 (2013-01-12 00:04:24) 转载▼ 标签： 365 mfc it 分类： MFC-office操作 1.        首先要将excel类添加到工程中。 在ClassWizard中，【Add Class】，在Excel的安装目录找到Excel.exe（Microsoft2003是Excel
VC操作Excel
huozheleisi
07-17 137
VC操作Excel 1、Excel的层次结构： Application Workbooks Workbook ...... Worksheets Worksheet ...... Range Font Borders ...... ....... 2、插入类型库 （1）、在一个已有的MFC工程按Ctrl + W 弹出ClassWizard对话框。 （2）、Add C...
使用MFC操作EXCEL文件
gamestory的专栏
01-07 1003
本文档适用于： Microsoft Foundation Classes (MFC), Microsoft Visual C++, 32-bit Editions, version 6.0 以上 Microsoft OLE 库 第一步：建立一个自动化工程 启动VC 6.0，打开新建对话框，新建一个MFC AppWizard(exe)工程，这里工程明设置为Te
基于excel9.h的excel处理
weixin_33985679的博客
05-16 599
基于excel9.h的excel处理; #include "excel9.h" #include <iostream> using namespace std; class excel_lwn { public: excel_lwn() { CoInitialize(NULL); if(!app.Creat...
MFC第四课 使用ODBC操作EXCEL表
weixin_33698823的博客
08-12 167
方案一：利用现成的第三方库：CSpreadSheet使用CSpreadSheet操作EXCEL的局限性：你只能够在EXCEL中创建表，然后才能够采用ODBC的方式操作EXCEL表，否则查询语句中FROM后面的表名称无法填写.限制该控件需要MFC(微软基础类库)支持.未测试是否支持Unicode编码.控件以ODBC读写Excel文件，需要ODBC驱动程序.Excel文件必须列标...
vs2019 mfc操作excel
最新发布
07-02
### 回答1： VS2019 MFC操作Excel是一种常用的开发技术，可以通过使用MFC库中的一些功能和类来实现对Excel文件的读写操作。 首先，需要在工程中引入MFC库和所需的头文件，如afxwin.h、afxdisp.h等。 接下来，使用COleVariant类型的变量来打开Excel应用程序，并创建一个工作簿（Workbook）对象。例如： ```cpp CApplication excelApp; if (!excelApp.CreateDispatch(_T("Excel.Application"))) { AfxMessageBox(_T("Excel应用程序创建失败！")); return; } CWorkbooks workbooks = excelApp.GetWorkbooks(); CWorkbook workbook = workbooks.Add(); ``` 然后，通过获取工作簿中的工作表（Worksheets）对象，可以进行对工作簿的操作。例如： ```cpp CWorksheets worksheets = workbook.GetWorksheets(); CWorksheet worksheet = worksheets.GetItem(COleVariant((short)1)); //获取第一个工作表 Range range; //定义一个区域对象 range.AttachDispatch(worksheet.GetRange(COleVariant(L"A1"), COleVariant(L"C3"))); //获取A1到C3的单元格区域 COleVariant data(_T("Hello, Excel!")); //准备要写入的数据 range.put_Value2(data); //将数据写入区域 ``` 当需要读取Excel数据时，可以借助Worksheet对象的Cells属性和Range对象进行操作。例如： ```cpp CRange usedRange = worksheet.GetUsedRange(); //获取已使用的单元格范围 int rowCount = usedRange.GetRows().GetCount(); //获取行数 int columnCount = usedRange.GetColumns().GetCount(); //获取列数 for (int i = 1; i <= rowCount; i++) { for (int j = 1; j <= columnCount; j++) { CRange cell = worksheet.GetCells().GetItem(COleVariant(i), COleVariant(j)); //获取指定单元格 CString value = cell.GetValue(); //获取单元格的值 //对获取到的数据进行处理 } } ``` 最后，记得在不需要使用Excel时，调用相关的关闭和释放函数，以结束Excel应用程序的运行。例如： ```cpp workbook.SaveAs(COleVariant(L"test.xlsx")); //保存工作簿到文件 workbook.Close(); excelApp.Quit(); ``` 以上是使用VS2019 MFC操作Excel的基本方法，通过这些方法可以方便地对Excel文件进行读写操作，实现各种需求。 ### 回答2： VS2019 MFC操作Excel的基本步骤如下： 首先，我们需要在项目中引入MFC类库。在新建项目时，选择MFC应用程序，并在创建向导中勾选"使用MFC功能"。 接下来，我们需要添加Excel的头文件和库文件。在项目的stdafx.h文件中添加以下代码： ``` #include "afxdb.h" #include "afxdao.h" ``` 然后，在需要操作Excel的代码文件中，包含afxdao.h头文件，并定义以下变量： ``` CDatabase db; CDaoWorkspace workspace; CDaoDatabase* pDaoDB; CDaoRecordset rs; ``` 接着，我们需要创建一个Excel数据源。通过以下代码连接数据库： ``` CString strExcelFile = _T("C:\\path\\to\\excel.xls"); // 替换为实际的Excel文件路径 CString strConnect = _T("Excel 8.0;HDR=YES;IMEX=1;"); // 数据源连接字符串 db.Open(NULL, FALSE, FALSE, strConnect); pDaoDB = db.m_pDaoDatabase; ``` 通过以上代码，我们成功地连接了Excel文件，现在可以开始操作Excel表格了。 例如，我们可以执行下列操作来读取Excel文件中的数据： ``` rs.Open(db.OpenRecordset(_T("SELECT * FROM Sheet1")));//替换Sheet1为实际的工作表名称 while (!rs.IsEOF()) { CString strName; rs.GetFieldValue(_T("Name"), strName); // 读取Name列的数据 // 在这里处理读取到的数据 rs.MoveNext(); } rs.Close(); ``` 类似地，我们可以编写代码实现写入数据、修改数据等其他操作。操作完成后，务必关闭数据库连接： ``` db.Close(); ``` 这样，我们就完成了在VS2019 MFC中操作Excel的基本步骤。当然，在实际应用中，还可以根据具体需求进一步扩展功能。 ### 回答3： VS2019 MFC操作Excel的主要步骤如下： 首先，我们需要添加必要的头文件和库文件。在MFC应用程序的代码中，包含<afxdisp.h>和<atlbase.h>这两个头文件。此外，还需要在项目的属性中添加Microsoft.Office.Interop.Excel作为附加依赖项。 接下来，我们可以使用Excel应用程序对象进行操作。可以通过以下代码进行初始化： ``` _Application excelApp; if (!excelApp.CreateDispatch(L"Excel.Application")) { AfxMessageBox(L"无法启动Excel应用程序。"); return; } excelApp.put_Visible(TRUE); ``` 然后，我们可以打开一个工作簿并选择一个工作表进行操作。可以使用以下代码打开工作簿： ``` _Workbook excelWorkbook; excelWorkbook = excelApp.get_Workbooks().Open(L"C:\\Path\\To\\Workbook.xlsx"); ``` 接着，我们可以访问工作表中的单元格数据，并进行读取或写入操作。例如，可以使用下面的代码来读取A1单元格的数据并将其显示在MessageBox中： ``` _Range excelRange; excelRange = excelWorkbook.get_Worksheets().get_Item(1).get_Range(COleVariant(L"A1"), COleVariant(L"A1")); CString value = (LPCTSTR)excelRange.get_Value2().bstrVal; AfxMessageBox(value); ``` 最后，在完成操作后，我们应该关闭工作簿和Excel应用程序，释放相关资源。可以使用以下代码来关闭工作簿和Excel应用程序： ``` excelWorkbook.Close(FALSE); excelApp.Quit(); ``` 以上是使用VS2019 MFC操作Excel的基本步骤。在实际开发中，根据具体需求，还可以进行更多的操作，如新增工作表、格式化单元格、插入图表等。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值