excel9.h 42 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979
  1. // Machine generated IDispatch wrapper class(es) created with ClassWizard
  2. /////////////////////////////////////////////////////////////////////////////
  3. // _Application wrapper class
  4. class _Application : public COleDispatchDriver
  5. {
  6. public:
  7. _Application() {} // Calls COleDispatchDriver default constructor
  8. _Application(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
  9. _Application(const _Application& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
  10. // Attributes
  11. public:
  12. // Operations
  13. public:
  14. LPDISPATCH GetApplication();
  15. long GetCreator();
  16. LPDISPATCH GetParent();
  17. LPDISPATCH GetActiveCell();
  18. LPDISPATCH GetActiveChart();
  19. CString GetActivePrinter();
  20. void SetActivePrinter(LPCTSTR lpszNewValue);
  21. LPDISPATCH GetActiveSheet();
  22. LPDISPATCH GetActiveWindow();
  23. LPDISPATCH GetActiveWorkbook();
  24. LPDISPATCH GetAddIns();
  25. LPDISPATCH GetAssistant();
  26. void Calculate();
  27. LPDISPATCH GetCells();
  28. LPDISPATCH GetCharts();
  29. LPDISPATCH GetColumns();
  30. LPDISPATCH GetCommandBars();
  31. long GetDDEAppReturnCode();
  32. void DDEExecute(long Channel, LPCTSTR String);
  33. long DDEInitiate(LPCTSTR App, LPCTSTR Topic);
  34. void DDEPoke(long Channel, const VARIANT& Item, const VARIANT& Data);
  35. VARIANT DDERequest(long Channel, LPCTSTR Item);
  36. void DDETerminate(long Channel);
  37. VARIANT Evaluate(const VARIANT& Name);
  38. VARIANT _Evaluate(const VARIANT& Name);
  39. VARIANT ExecuteExcel4Macro(LPCTSTR String);
  40. 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,
  41. 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,
  42. 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);
  43. LPDISPATCH GetNames();
  44. LPDISPATCH GetRange(const VARIANT& Cell1, const VARIANT& Cell2);
  45. LPDISPATCH GetRows();
  46. 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,
  47. 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,
  48. 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,
  49. const VARIANT& Arg30);
  50. 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,
  51. 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,
  52. 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,
  53. const VARIANT& Arg30);
  54. LPDISPATCH GetSelection();
  55. void SendKeys(const VARIANT& Keys, const VARIANT& Wait);
  56. LPDISPATCH GetSheets();
  57. LPDISPATCH GetThisWorkbook();
  58. 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,
  59. 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,
  60. 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);
  61. LPDISPATCH GetWindows();
  62. LPDISPATCH GetWorkbooks();
  63. LPDISPATCH GetWorksheetFunction();
  64. LPDISPATCH GetWorksheets();
  65. LPDISPATCH GetExcel4IntlMacroSheets();
  66. LPDISPATCH GetExcel4MacroSheets();
  67. void ActivateMicrosoftApp(long Index);
  68. void AddChartAutoFormat(const VARIANT& Chart, LPCTSTR Name, const VARIANT& Description);
  69. void AddCustomList(const VARIANT& ListArray, const VARIANT& ByRow);
  70. BOOL GetAlertBeforeOverwriting();
  71. void SetAlertBeforeOverwriting(BOOL bNewValue);
  72. CString GetAltStartupPath();
  73. void SetAltStartupPath(LPCTSTR lpszNewValue);
  74. BOOL GetAskToUpdateLinks();
  75. void SetAskToUpdateLinks(BOOL bNewValue);
  76. BOOL GetEnableAnimations();
  77. void SetEnableAnimations(BOOL bNewValue);
  78. LPDISPATCH GetAutoCorrect();
  79. long GetBuild();
  80. BOOL GetCalculateBeforeSave();
  81. void SetCalculateBeforeSave(BOOL bNewValue);
  82. long GetCalculation();
  83. void SetCalculation(long nNewValue);
  84. VARIANT GetCaller(const VARIANT& Index);
  85. BOOL GetCanPlaySounds();
  86. BOOL GetCanRecordSounds();
  87. CString GetCaption();
  88. void SetCaption(LPCTSTR lpszNewValue);
  89. BOOL GetCellDragAndDrop();
  90. void SetCellDragAndDrop(BOOL bNewValue);
  91. double CentimetersToPoints(double Centimeters);
  92. BOOL CheckSpelling(LPCTSTR Word, const VARIANT& CustomDictionary, const VARIANT& IgnoreUppercase);
  93. VARIANT GetClipboardFormats(const VARIANT& Index);
  94. BOOL GetDisplayClipboardWindow();
  95. void SetDisplayClipboardWindow(BOOL bNewValue);
  96. long GetCommandUnderlines();
  97. void SetCommandUnderlines(long nNewValue);
  98. BOOL GetConstrainNumeric();
  99. void SetConstrainNumeric(BOOL bNewValue);
  100. VARIANT ConvertFormula(const VARIANT& Formula, long FromReferenceStyle, const VARIANT& ToReferenceStyle, const VARIANT& ToAbsolute, const VARIANT& RelativeTo);
  101. BOOL GetCopyObjectsWithCells();
  102. void SetCopyObjectsWithCells(BOOL bNewValue);
  103. long GetCursor();
  104. void SetCursor(long nNewValue);
  105. long GetCustomListCount();
  106. long GetCutCopyMode();
  107. void SetCutCopyMode(long nNewValue);
  108. long GetDataEntryMode();
  109. void SetDataEntryMode(long nNewValue);
  110. CString Get_Default();
  111. CString GetDefaultFilePath();
  112. void SetDefaultFilePath(LPCTSTR lpszNewValue);
  113. void DeleteChartAutoFormat(LPCTSTR Name);
  114. void DeleteCustomList(long ListNum);
  115. LPDISPATCH GetDialogs();
  116. BOOL GetDisplayAlerts();
  117. void SetDisplayAlerts(BOOL bNewValue);
  118. BOOL GetDisplayFormulaBar();
  119. void SetDisplayFormulaBar(BOOL bNewValue);
  120. BOOL GetDisplayFullScreen();
  121. void SetDisplayFullScreen(BOOL bNewValue);
  122. BOOL GetDisplayNoteIndicator();
  123. void SetDisplayNoteIndicator(BOOL bNewValue);
  124. long GetDisplayCommentIndicator();
  125. void SetDisplayCommentIndicator(long nNewValue);
  126. BOOL GetDisplayExcel4Menus();
  127. void SetDisplayExcel4Menus(BOOL bNewValue);
  128. BOOL GetDisplayRecentFiles();
  129. void SetDisplayRecentFiles(BOOL bNewValue);
  130. BOOL GetDisplayScrollBars();
  131. void SetDisplayScrollBars(BOOL bNewValue);
  132. BOOL GetDisplayStatusBar();
  133. void SetDisplayStatusBar(BOOL bNewValue);
  134. void DoubleClick();
  135. BOOL GetEditDirectlyInCell();
  136. void SetEditDirectlyInCell(BOOL bNewValue);
  137. BOOL GetEnableAutoComplete();
  138. void SetEnableAutoComplete(BOOL bNewValue);
  139. long GetEnableCancelKey();
  140. void SetEnableCancelKey(long nNewValue);
  141. BOOL GetEnableSound();
  142. void SetEnableSound(BOOL bNewValue);
  143. VARIANT GetFileConverters(const VARIANT& Index1, const VARIANT& Index2);
  144. LPDISPATCH GetFileSearch();
  145. LPDISPATCH GetFileFind();
  146. BOOL GetFixedDecimal();
  147. void SetFixedDecimal(BOOL bNewValue);
  148. long GetFixedDecimalPlaces();
  149. void SetFixedDecimalPlaces(long nNewValue);
  150. VARIANT GetCustomListContents(long ListNum);
  151. long GetCustomListNum(const VARIANT& ListArray);
  152. VARIANT GetOpenFilename(const VARIANT& FileFilter, const VARIANT& FilterIndex, const VARIANT& Title, const VARIANT& ButtonText, const VARIANT& MultiSelect);
  153. VARIANT GetSaveAsFilename(const VARIANT& InitialFilename, const VARIANT& FileFilter, const VARIANT& FilterIndex, const VARIANT& Title, const VARIANT& ButtonText);
  154. void Goto(const VARIANT& Reference, const VARIANT& Scroll);
  155. double GetHeight();
  156. void SetHeight(double newValue);
  157. void Help(const VARIANT& HelpFile, const VARIANT& HelpContextID);
  158. BOOL GetIgnoreRemoteRequests();
  159. void SetIgnoreRemoteRequests(BOOL bNewValue);
  160. double InchesToPoints(double Inches);
  161. 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);
  162. BOOL GetInteractive();
  163. void SetInteractive(BOOL bNewValue);
  164. VARIANT GetInternational(const VARIANT& Index);
  165. BOOL GetIteration();
  166. void SetIteration(BOOL bNewValue);
  167. double GetLeft();
  168. void SetLeft(double newValue);
  169. CString GetLibraryPath();
  170. 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,
  171. const VARIANT& HelpContextID, const VARIANT& HelpFile);
  172. void MailLogoff();
  173. void MailLogon(const VARIANT& Name, const VARIANT& Password, const VARIANT& DownloadNewMail);
  174. VARIANT GetMailSession();
  175. long GetMailSystem();
  176. BOOL GetMathCoprocessorAvailable();
  177. double GetMaxChange();
  178. void SetMaxChange(double newValue);
  179. long GetMaxIterations();
  180. void SetMaxIterations(long nNewValue);
  181. long GetMemoryFree();
  182. long GetMemoryTotal();
  183. long GetMemoryUsed();
  184. BOOL GetMouseAvailable();
  185. BOOL GetMoveAfterReturn();
  186. void SetMoveAfterReturn(BOOL bNewValue);
  187. long GetMoveAfterReturnDirection();
  188. void SetMoveAfterReturnDirection(long nNewValue);
  189. LPDISPATCH GetRecentFiles();
  190. CString GetName();
  191. LPDISPATCH NextLetter();
  192. CString GetNetworkTemplatesPath();
  193. LPDISPATCH GetODBCErrors();
  194. long GetODBCTimeout();
  195. void SetODBCTimeout(long nNewValue);
  196. void OnKey(LPCTSTR Key, const VARIANT& Procedure);
  197. void OnRepeat(LPCTSTR Text, LPCTSTR Procedure);
  198. void OnTime(const VARIANT& EarliestTime, LPCTSTR Procedure, const VARIANT& LatestTime, const VARIANT& Schedule);
  199. void OnUndo(LPCTSTR Text, LPCTSTR Procedure);
  200. CString GetOnWindow();
  201. void SetOnWindow(LPCTSTR lpszNewValue);
  202. CString GetOperatingSystem();
  203. CString GetOrganizationName();
  204. CString GetPath();
  205. CString GetPathSeparator();
  206. VARIANT GetPreviousSelections(const VARIANT& Index);
  207. BOOL GetPivotTableSelection();
  208. void SetPivotTableSelection(BOOL bNewValue);
  209. BOOL GetPromptForSummaryInfo();
  210. void SetPromptForSummaryInfo(BOOL bNewValue);
  211. void Quit();
  212. void RecordMacro(const VARIANT& BasicCode, const VARIANT& XlmCode);
  213. BOOL GetRecordRelative();
  214. long GetReferenceStyle();
  215. void SetReferenceStyle(long nNewValue);
  216. VARIANT GetRegisteredFunctions(const VARIANT& Index1, const VARIANT& Index2);
  217. BOOL RegisterXLL(LPCTSTR Filename);
  218. void Repeat();
  219. BOOL GetRollZoom();
  220. void SetRollZoom(BOOL bNewValue);
  221. void SaveWorkspace(const VARIANT& Filename);
  222. BOOL GetScreenUpdating();
  223. void SetScreenUpdating(BOOL bNewValue);
  224. void SetDefaultChart(const VARIANT& FormatName, const VARIANT& Gallery);
  225. long GetSheetsInNewWorkbook();
  226. void SetSheetsInNewWorkbook(long nNewValue);
  227. BOOL GetShowChartTipNames();
  228. void SetShowChartTipNames(BOOL bNewValue);
  229. BOOL GetShowChartTipValues();
  230. void SetShowChartTipValues(BOOL bNewValue);
  231. CString GetStandardFont();
  232. void SetStandardFont(LPCTSTR lpszNewValue);
  233. double GetStandardFontSize();
  234. void SetStandardFontSize(double newValue);
  235. CString GetStartupPath();
  236. VARIANT GetStatusBar();
  237. void SetStatusBar(const VARIANT& newValue);
  238. CString GetTemplatesPath();
  239. BOOL GetShowToolTips();
  240. void SetShowToolTips(BOOL bNewValue);
  241. double GetTop();
  242. void SetTop(double newValue);
  243. long GetDefaultSaveFormat();
  244. void SetDefaultSaveFormat(long nNewValue);
  245. CString GetTransitionMenuKey();
  246. void SetTransitionMenuKey(LPCTSTR lpszNewValue);
  247. long GetTransitionMenuKeyAction();
  248. void SetTransitionMenuKeyAction(long nNewValue);
  249. BOOL GetTransitionNavigKeys();
  250. void SetTransitionNavigKeys(BOOL bNewValue);
  251. void Undo();
  252. double GetUsableHeight();
  253. double GetUsableWidth();
  254. BOOL GetUserControl();
  255. void SetUserControl(BOOL bNewValue);
  256. CString GetUserName_();
  257. void SetUserName(LPCTSTR lpszNewValue);
  258. CString GetValue();
  259. LPDISPATCH GetVbe();
  260. CString GetVersion();
  261. BOOL GetVisible();
  262. void SetVisible(BOOL bNewValue);
  263. void Volatile(const VARIANT& Volatile);
  264. double GetWidth();
  265. void SetWidth(double newValue);
  266. BOOL GetWindowsForPens();
  267. long GetWindowState();
  268. void SetWindowState(long nNewValue);
  269. long GetDefaultSheetDirection();
  270. void SetDefaultSheetDirection(long nNewValue);
  271. long GetCursorMovement();
  272. void SetCursorMovement(long nNewValue);
  273. BOOL GetControlCharacters();
  274. void SetControlCharacters(BOOL bNewValue);
  275. BOOL GetEnableEvents();
  276. void SetEnableEvents(BOOL bNewValue);
  277. BOOL Wait(const VARIANT& Time);
  278. BOOL GetExtendList();
  279. void SetExtendList(BOOL bNewValue);
  280. LPDISPATCH GetOLEDBErrors();
  281. CString GetPhonetic(const VARIANT& Text);
  282. LPDISPATCH GetCOMAddIns();
  283. LPDISPATCH GetDefaultWebOptions();
  284. CString GetProductCode();
  285. CString GetUserLibraryPath();
  286. BOOL GetAutoPercentEntry();
  287. void SetAutoPercentEntry(BOOL bNewValue);
  288. LPDISPATCH GetLanguageSettings();
  289. LPDISPATCH GetAnswerWizard();
  290. void CalculateFull();
  291. BOOL FindFile();
  292. long GetCalculationVersion();
  293. BOOL GetShowWindowsInTaskbar();
  294. void SetShowWindowsInTaskbar(BOOL bNewValue);
  295. long GetFeatureInstall();
  296. void SetFeatureInstall(long nNewValue);
  297. };
  298. /////////////////////////////////////////////////////////////////////////////
  299. // _Worksheet wrapper class
  300. class _Worksheet : public COleDispatchDriver
  301. {
  302. public:
  303. _Worksheet() {} // Calls COleDispatchDriver default constructor
  304. _Worksheet(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
  305. _Worksheet(const _Worksheet& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
  306. // Attributes
  307. public:
  308. // Operations
  309. public:
  310. LPDISPATCH GetApplication();
  311. long GetCreator();
  312. LPDISPATCH GetParent();
  313. void Activate();
  314. void Copy(const VARIANT& Before, const VARIANT& After);
  315. void Delete();
  316. CString GetCodeName();
  317. CString Get_CodeName();
  318. void Set_CodeName(LPCTSTR lpszNewValue);
  319. long GetIndex();
  320. void Move(const VARIANT& Before, const VARIANT& After);
  321. CString GetName();
  322. void SetName(LPCTSTR lpszNewValue);
  323. LPDISPATCH GetNext();
  324. LPDISPATCH GetPageSetup();
  325. LPDISPATCH GetPrevious();
  326. void PrintPreview(const VARIANT& EnableChanges);
  327. void Protect(const VARIANT& Password, const VARIANT& DrawingObjects, const VARIANT& Contents, const VARIANT& Scenarios, const VARIANT& UserInterfaceOnly);
  328. BOOL GetProtectContents();
  329. BOOL GetProtectDrawingObjects();
  330. BOOL GetProtectionMode();
  331. BOOL GetProtectScenarios();
  332. 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,
  333. const VARIANT& TextVisualLayout);
  334. void Select(const VARIANT& Replace);
  335. void Unprotect(const VARIANT& Password);
  336. long GetVisible();
  337. void SetVisible(long nNewValue);
  338. LPDISPATCH GetShapes();
  339. BOOL GetTransitionExpEval();
  340. void SetTransitionExpEval(BOOL bNewValue);
  341. BOOL GetAutoFilterMode();
  342. void SetAutoFilterMode(BOOL bNewValue);
  343. void SetBackgroundPicture(LPCTSTR Filename);
  344. void Calculate();
  345. BOOL GetEnableCalculation();
  346. void SetEnableCalculation(BOOL bNewValue);
  347. LPDISPATCH GetCells();
  348. LPDISPATCH ChartObjects(const VARIANT& Index);
  349. void CheckSpelling(const VARIANT& CustomDictionary, const VARIANT& IgnoreUppercase, const VARIANT& AlwaysSuggest, const VARIANT& SpellLang);
  350. LPDISPATCH GetCircularReference();
  351. void ClearArrows();
  352. LPDISPATCH GetColumns();
  353. long GetConsolidationFunction();
  354. VARIANT GetConsolidationOptions();
  355. VARIANT GetConsolidationSources();
  356. BOOL GetEnableAutoFilter();
  357. void SetEnableAutoFilter(BOOL bNewValue);
  358. long GetEnableSelection();
  359. void SetEnableSelection(long nNewValue);
  360. BOOL GetEnableOutlining();
  361. void SetEnableOutlining(BOOL bNewValue);
  362. BOOL GetEnablePivotTable();
  363. void SetEnablePivotTable(BOOL bNewValue);
  364. VARIANT Evaluate(const VARIANT& Name);
  365. VARIANT _Evaluate(const VARIANT& Name);
  366. BOOL GetFilterMode();
  367. void ResetAllPageBreaks();
  368. LPDISPATCH GetNames();
  369. LPDISPATCH OLEObjects(const VARIANT& Index);
  370. LPDISPATCH GetOutline();
  371. void Paste(const VARIANT& Destination, const VARIANT& Link);
  372. void PasteSpecial(const VARIANT& Format, const VARIANT& Link, const VARIANT& DisplayAsIcon, const VARIANT& IconFileName, const VARIANT& IconIndex, const VARIANT& IconLabel);
  373. LPDISPATCH PivotTables(const VARIANT& Index);
  374. LPDISPATCH PivotTableWizard(const VARIANT& SourceType, const VARIANT& SourceData, const VARIANT& TableDestination, const VARIANT& TableName, const VARIANT& RowGrand, const VARIANT& ColumnGrand, const VARIANT& SaveData,
  375. const VARIANT& HasAutoFormat, const VARIANT& AutoPage, const VARIANT& Reserved, const VARIANT& BackgroundQuery, const VARIANT& OptimizeCache, const VARIANT& PageFieldOrder, const VARIANT& PageFieldWrapCount, const VARIANT& ReadData,
  376. const VARIANT& Connection);
  377. LPDISPATCH GetRange(const VARIANT& Cell1, const VARIANT& Cell2);
  378. LPDISPATCH GetRows();
  379. LPDISPATCH Scenarios(const VARIANT& Index);
  380. CString GetScrollArea();
  381. void SetScrollArea(LPCTSTR lpszNewValue);
  382. void ShowAllData();
  383. void ShowDataForm();
  384. double GetStandardHeight();
  385. double GetStandardWidth();
  386. void SetStandardWidth(double newValue);
  387. BOOL GetTransitionFormEntry();
  388. void SetTransitionFormEntry(BOOL bNewValue);
  389. long GetType();
  390. LPDISPATCH GetUsedRange();
  391. LPDISPATCH GetHPageBreaks();
  392. LPDISPATCH GetVPageBreaks();
  393. LPDISPATCH GetQueryTables();
  394. BOOL GetDisplayPageBreaks();
  395. void SetDisplayPageBreaks(BOOL bNewValue);
  396. LPDISPATCH GetComments();
  397. LPDISPATCH GetHyperlinks();
  398. void ClearCircles();
  399. void CircleInvalid();
  400. LPDISPATCH GetAutoFilter();
  401. BOOL GetDisplayRightToLeft();
  402. void SetDisplayRightToLeft(BOOL bNewValue);
  403. LPDISPATCH GetScripts();
  404. 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);
  405. };
  406. /////////////////////////////////////////////////////////////////////////////
  407. // _Workbook wrapper class
  408. class _Workbook : public COleDispatchDriver
  409. {
  410. public:
  411. _Workbook() {} // Calls COleDispatchDriver default constructor
  412. _Workbook(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
  413. _Workbook(const _Workbook& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
  414. // Attributes
  415. public:
  416. // Operations
  417. public:
  418. LPDISPATCH GetApplication();
  419. long GetCreator();
  420. LPDISPATCH GetParent();
  421. BOOL GetAcceptLabelsInFormulas();
  422. void SetAcceptLabelsInFormulas(BOOL bNewValue);
  423. void Activate();
  424. LPDISPATCH GetActiveChart();
  425. LPDISPATCH GetActiveSheet();
  426. long GetAutoUpdateFrequency();
  427. void SetAutoUpdateFrequency(long nNewValue);
  428. BOOL GetAutoUpdateSaveChanges();
  429. void SetAutoUpdateSaveChanges(BOOL bNewValue);
  430. long GetChangeHistoryDuration();
  431. void SetChangeHistoryDuration(long nNewValue);
  432. LPDISPATCH GetBuiltinDocumentProperties();
  433. void ChangeFileAccess(long Mode, const VARIANT& WritePassword, const VARIANT& Notify);
  434. void ChangeLink(LPCTSTR Name, LPCTSTR NewName, long Type);
  435. LPDISPATCH GetCharts();
  436. void Close(const VARIANT& SaveChanges, const VARIANT& Filename, const VARIANT& RouteWorkbook);
  437. CString GetCodeName();
  438. CString Get_CodeName();
  439. void Set_CodeName(LPCTSTR lpszNewValue);
  440. VARIANT GetColors(const VARIANT& Index);
  441. void SetColors(const VARIANT& Index, const VARIANT& newValue);
  442. LPDISPATCH GetCommandBars();
  443. long GetConflictResolution();
  444. void SetConflictResolution(long nNewValue);
  445. LPDISPATCH GetContainer();
  446. BOOL GetCreateBackup();
  447. LPDISPATCH GetCustomDocumentProperties();
  448. BOOL GetDate1904();
  449. void SetDate1904(BOOL bNewValue);
  450. void DeleteNumberFormat(LPCTSTR NumberFormat);
  451. long GetDisplayDrawingObjects();
  452. void SetDisplayDrawingObjects(long nNewValue);
  453. BOOL ExclusiveAccess();
  454. long GetFileFormat();
  455. void ForwardMailer();
  456. CString GetFullName();
  457. BOOL GetHasPassword();
  458. BOOL GetHasRoutingSlip();
  459. void SetHasRoutingSlip(BOOL bNewValue);
  460. BOOL GetIsAddin();
  461. void SetIsAddin(BOOL bNewValue);
  462. VARIANT LinkInfo(LPCTSTR Name, long LinkInfo, const VARIANT& Type, const VARIANT& EditionRef);
  463. VARIANT LinkSources(const VARIANT& Type);
  464. LPDISPATCH GetMailer();
  465. void MergeWorkbook(const VARIANT& Filename);
  466. BOOL GetMultiUserEditing();
  467. CString GetName();
  468. LPDISPATCH GetNames();
  469. LPDISPATCH NewWindow();
  470. void OpenLinks(LPCTSTR Name, const VARIANT& ReadOnly, const VARIANT& Type);
  471. CString GetPath();
  472. BOOL GetPersonalViewListSettings();
  473. void SetPersonalViewListSettings(BOOL bNewValue);
  474. BOOL GetPersonalViewPrintSettings();
  475. void SetPersonalViewPrintSettings(BOOL bNewValue);
  476. LPDISPATCH PivotCaches();
  477. void Post(const VARIANT& DestName);
  478. BOOL GetPrecisionAsDisplayed();
  479. void SetPrecisionAsDisplayed(BOOL bNewValue);
  480. void PrintPreview(const VARIANT& EnableChanges);
  481. void Protect(const VARIANT& Password, const VARIANT& Structure, const VARIANT& Windows);
  482. void ProtectSharing(const VARIANT& Filename, const VARIANT& Password, const VARIANT& WriteResPassword, const VARIANT& ReadOnlyRecommended, const VARIANT& CreateBackup, const VARIANT& SharingPassword);
  483. BOOL GetProtectStructure();
  484. BOOL GetProtectWindows();
  485. BOOL GetReadOnly();
  486. BOOL GetReadOnlyRecommended();
  487. void RefreshAll();
  488. void Reply();
  489. void ReplyAll();
  490. void RemoveUser(long Index);
  491. long GetRevisionNumber();
  492. void Route();
  493. BOOL GetRouted();
  494. LPDISPATCH GetRoutingSlip();
  495. void RunAutoMacros(long Which);
  496. void Save();
  497. 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,
  498. const VARIANT& AddToMru, const VARIANT& TextCodepage, const VARIANT& TextVisualLayout);
  499. void SaveCopyAs(const VARIANT& Filename);
  500. BOOL GetSaved();
  501. void SetSaved(BOOL bNewValue);
  502. BOOL GetSaveLinkValues();
  503. void SetSaveLinkValues(BOOL bNewValue);
  504. void SendMail(const VARIANT& Recipients, const VARIANT& Subject, const VARIANT& ReturnReceipt);
  505. void SendMailer(const VARIANT& FileFormat, long Priority);
  506. void SetLinkOnData(LPCTSTR Name, const VARIANT& Procedure);
  507. LPDISPATCH GetSheets();
  508. BOOL GetShowConflictHistory();
  509. void SetShowConflictHistory(BOOL bNewValue);
  510. LPDISPATCH GetStyles();
  511. void Unprotect(const VARIANT& Password);
  512. void UnprotectSharing(const VARIANT& SharingPassword);
  513. void UpdateFromFile();
  514. void UpdateLink(const VARIANT& Name, const VARIANT& Type);
  515. BOOL GetUpdateRemoteReferences();
  516. void SetUpdateRemoteReferences(BOOL bNewValue);
  517. VARIANT GetUserStatus();
  518. LPDISPATCH GetCustomViews();
  519. LPDISPATCH GetWindows();
  520. LPDISPATCH GetWorksheets();
  521. BOOL GetWriteReserved();
  522. CString GetWriteReservedBy();
  523. LPDISPATCH GetExcel4IntlMacroSheets();
  524. LPDISPATCH GetExcel4MacroSheets();
  525. BOOL GetTemplateRemoveExtData();
  526. void SetTemplateRemoveExtData(BOOL bNewValue);
  527. void HighlightChangesOptions(const VARIANT& When, const VARIANT& Who, const VARIANT& Where);
  528. BOOL GetHighlightChangesOnScreen();
  529. void SetHighlightChangesOnScreen(BOOL bNewValue);
  530. BOOL GetKeepChangeHistory();
  531. void SetKeepChangeHistory(BOOL bNewValue);
  532. BOOL GetListChangesOnNewSheet();
  533. void SetListChangesOnNewSheet(BOOL bNewValue);
  534. void PurgeChangeHistoryNow(long Days, const VARIANT& SharingPassword);
  535. void AcceptAllChanges(const VARIANT& When, const VARIANT& Who, const VARIANT& Where);
  536. void RejectAllChanges(const VARIANT& When, const VARIANT& Who, const VARIANT& Where);
  537. void ResetColors();
  538. LPDISPATCH GetVBProject();
  539. void FollowHyperlink(LPCTSTR Address, const VARIANT& SubAddress, const VARIANT& NewWindow, const VARIANT& AddHistory, const VARIANT& ExtraInfo, const VARIANT& Method, const VARIANT& HeaderInfo);
  540. void AddToFavorites();
  541. BOOL GetIsInplace();
  542. 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);
  543. void WebPagePreview();
  544. LPDISPATCH GetPublishObjects();
  545. LPDISPATCH GetWebOptions();
  546. void ReloadAs(long Encoding);
  547. LPDISPATCH GetHTMLProject();
  548. BOOL GetEnvelopeVisible();
  549. void SetEnvelopeVisible(BOOL bNewValue);
  550. long GetCalculationVersion();
  551. BOOL GetVBASigned();
  552. };
  553. /////////////////////////////////////////////////////////////////////////////
  554. // Workbooks wrapper class
  555. class Workbooks : public COleDispatchDriver
  556. {
  557. public:
  558. Workbooks() {} // Calls COleDispatchDriver default constructor
  559. Workbooks(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
  560. Workbooks(const Workbooks& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
  561. // Attributes
  562. public:
  563. // Operations
  564. public:
  565. LPDISPATCH GetApplication();
  566. long GetCreator();
  567. LPDISPATCH GetParent();
  568. LPDISPATCH Add(const VARIANT& Template);
  569. void Close();
  570. long GetCount();
  571. LPDISPATCH GetItem(const VARIANT& Index);
  572. LPUNKNOWN Get_NewEnum();
  573. 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,
  574. const VARIANT& Delimiter, const VARIANT& Editable, const VARIANT& Notify, const VARIANT& Converter, const VARIANT& AddToMru);
  575. LPDISPATCH Get_Default(const VARIANT& Index);
  576. 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,
  577. const VARIANT& Space, const VARIANT& Other, const VARIANT& OtherChar, const VARIANT& FieldInfo, const VARIANT& TextVisualLayout, const VARIANT& DecimalSeparator, const VARIANT& ThousandsSeparator);
  578. };
  579. /////////////////////////////////////////////////////////////////////////////
  580. // FontExcel wrapper class
  581. class FontExcel : public COleDispatchDriver
  582. {
  583. public:
  584. FontExcel() {} // Calls COleDispatchDriver default constructor
  585. FontExcel(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
  586. FontExcel(const FontExcel& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
  587. // Attributes
  588. public:
  589. // Operations
  590. public:
  591. LPDISPATCH GetApplication();
  592. long GetCreator();
  593. LPDISPATCH GetParent();
  594. VARIANT GetBackground();
  595. void SetBackground(const VARIANT& newValue);
  596. VARIANT GetBold();
  597. void SetBold(const VARIANT& newValue);
  598. VARIANT GetColor();
  599. void SetColor(const VARIANT& newValue);
  600. VARIANT GetColorIndex();
  601. void SetColorIndex(const VARIANT& newValue);
  602. VARIANT GetFontStyle();
  603. void SetFontStyle(const VARIANT& newValue);
  604. VARIANT GetItalic();
  605. void SetItalic(const VARIANT& newValue);
  606. VARIANT GetName();
  607. void SetName(const VARIANT& newValue);
  608. VARIANT GetOutlineFont();
  609. void SetOutlineFont(const VARIANT& newValue);
  610. VARIANT GetShadow();
  611. void SetShadow(const VARIANT& newValue);
  612. VARIANT GetSize();
  613. void SetSize(const VARIANT& newValue);
  614. VARIANT GetStrikethrough();
  615. void SetStrikethrough(const VARIANT& newValue);
  616. VARIANT GetSubscript();
  617. void SetSubscript(const VARIANT& newValue);
  618. VARIANT GetSuperscript();
  619. void SetSuperscript(const VARIANT& newValue);
  620. VARIANT GetUnderline();
  621. void SetUnderline(const VARIANT& newValue);
  622. };
  623. /////////////////////////////////////////////////////////////////////////////
  624. // Range wrapper class
  625. class Range : public COleDispatchDriver
  626. {
  627. public:
  628. Range() {} // Calls COleDispatchDriver default constructor
  629. Range(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
  630. Range(const Range& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
  631. // Attributes
  632. public:
  633. // Operations
  634. public:
  635. LPDISPATCH GetApplication();
  636. long GetCreator();
  637. LPDISPATCH GetParent();
  638. VARIANT Activate();
  639. VARIANT GetAddIndent();
  640. void SetAddIndent(const VARIANT& newValue);
  641. CString GetAddress(const VARIANT& RowAbsolute, const VARIANT& ColumnAbsolute, long ReferenceStyle, const VARIANT& External, const VARIANT& RelativeTo);
  642. CString GetAddressLocal(const VARIANT& RowAbsolute, const VARIANT& ColumnAbsolute, long ReferenceStyle, const VARIANT& External, const VARIANT& RelativeTo);
  643. VARIANT AdvancedFilter(long Action, const VARIANT& CriteriaRange, const VARIANT& CopyToRange, const VARIANT& Unique);
  644. VARIANT ApplyNames(const VARIANT& Names, const VARIANT& IgnoreRelativeAbsolute, const VARIANT& UseRowColumnNames, const VARIANT& OmitColumn, const VARIANT& OmitRow, long Order, const VARIANT& AppendLast);
  645. VARIANT ApplyOutlineStyles();
  646. LPDISPATCH GetAreas();
  647. CString AutoComplete(LPCTSTR String);
  648. VARIANT AutoFill(LPDISPATCH Destination, long Type);
  649. VARIANT AutoFilter(const VARIANT& Field, const VARIANT& Criteria1, long Operator, const VARIANT& Criteria2, const VARIANT& VisibleDropDown);
  650. VARIANT AutoFit();
  651. VARIANT AutoFormat(long Format, const VARIANT& Number, const VARIANT& FontExcel, const VARIANT& Alignment, const VARIANT& Border, const VARIANT& Pattern, const VARIANT& Width);
  652. VARIANT AutoOutline();
  653. VARIANT BorderAround(const VARIANT& LineStyle, long Weight, long ColorIndex, const VARIANT& Color);
  654. LPDISPATCH GetBorders();
  655. VARIANT Calculate();
  656. LPDISPATCH GetCells();
  657. LPDISPATCH GetCharacters(const VARIANT& Start, const VARIANT& Length);
  658. VARIANT CheckSpelling(const VARIANT& CustomDictionary, const VARIANT& IgnoreUppercase, const VARIANT& AlwaysSuggest, const VARIANT& SpellLang);
  659. VARIANT Clear();
  660. VARIANT ClearContents();
  661. VARIANT ClearFormats();
  662. VARIANT ClearNotes();
  663. VARIANT ClearOutline();
  664. long GetColumn();
  665. LPDISPATCH ColumnDifferences(const VARIANT& Comparison);
  666. LPDISPATCH GetColumns();
  667. VARIANT GetColumnWidth();
  668. void SetColumnWidth(const VARIANT& newValue);
  669. VARIANT Consolidate(const VARIANT& Sources, const VARIANT& Function, const VARIANT& TopRow, const VARIANT& LeftColumn, const VARIANT& CreateLinks);
  670. VARIANT Copy(const VARIANT& Destination);
  671. long CopyFromRecordset(LPUNKNOWN Data, const VARIANT& MaxRows, const VARIANT& MaxColumns);
  672. VARIANT CopyPicture(long Appearance, long Format);
  673. long GetCount();
  674. VARIANT CreateNames(const VARIANT& Top, const VARIANT& Left, const VARIANT& Bottom, const VARIANT& Right);
  675. VARIANT CreatePublisher(const VARIANT& Edition, long Appearance, const VARIANT& ContainsPICT, const VARIANT& ContainsBIFF, const VARIANT& ContainsRTF, const VARIANT& ContainsVALU);
  676. LPDISPATCH GetCurrentArray();
  677. LPDISPATCH GetCurrentRegion();
  678. VARIANT Cut(const VARIANT& Destination);
  679. VARIANT DataSeries(const VARIANT& Rowcol, long Type, long Date, const VARIANT& Step, const VARIANT& Stop, const VARIANT& Trend);
  680. VARIANT Get_Default(const VARIANT& RowIndex, const VARIANT& ColumnIndex);
  681. void Set_Default(const VARIANT& RowIndex, const VARIANT& ColumnIndex, const VARIANT& newValue);
  682. VARIANT Delete(const VARIANT& Shift);
  683. LPDISPATCH GetDependents();
  684. VARIANT DialogBox_();
  685. LPDISPATCH GetDirectDependents();
  686. LPDISPATCH GetDirectPrecedents();
  687. VARIANT EditionOptions(long Type, long Option, const VARIANT& Name, const VARIANT& Reference, long Appearance, long ChartSize, const VARIANT& Format);
  688. LPDISPATCH GetEnd(long Direction);
  689. LPDISPATCH GetEntireColumn();
  690. LPDISPATCH GetEntireRow();
  691. VARIANT FillDown();
  692. VARIANT FillLeft();
  693. VARIANT FillRight();
  694. VARIANT FillUp();
  695. 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);
  696. LPDISPATCH FindNext(const VARIANT& After);
  697. LPDISPATCH FindPrevious(const VARIANT& After);
  698. LPDISPATCH GetFont();
  699. VARIANT GetFormula();
  700. void SetFormula(const VARIANT& newValue);
  701. VARIANT GetFormulaArray();
  702. void SetFormulaArray(const VARIANT& newValue);
  703. long GetFormulaLabel();
  704. void SetFormulaLabel(long nNewValue);
  705. VARIANT GetFormulaHidden();
  706. void SetFormulaHidden(const VARIANT& newValue);
  707. VARIANT GetFormulaLocal();
  708. void SetFormulaLocal(const VARIANT& newValue);
  709. VARIANT GetFormulaR1C1();
  710. void SetFormulaR1C1(const VARIANT& newValue);
  711. VARIANT GetFormulaR1C1Local();
  712. void SetFormulaR1C1Local(const VARIANT& newValue);
  713. VARIANT FunctionWizard();
  714. BOOL GoalSeek(const VARIANT& Goal, LPDISPATCH ChangingCell);
  715. VARIANT Group(const VARIANT& Start, const VARIANT& End, const VARIANT& By, const VARIANT& Periods);
  716. VARIANT GetHasArray();
  717. VARIANT GetHasFormula();
  718. VARIANT GetHeight();
  719. VARIANT GetHidden();
  720. void SetHidden(const VARIANT& newValue);
  721. VARIANT GetHorizontalAlignment();
  722. void SetHorizontalAlignment(const VARIANT& newValue);
  723. VARIANT GetIndentLevel();
  724. void SetIndentLevel(const VARIANT& newValue);
  725. void InsertIndent(long InsertAmount);
  726. VARIANT Insert(const VARIANT& Shift);
  727. LPDISPATCH GetInterior();
  728. VARIANT GetItem(const VARIANT& RowIndex, const VARIANT& ColumnIndex);
  729. void SetItem(const VARIANT& RowIndex, const VARIANT& ColumnIndex, const VARIANT& newValue);
  730. VARIANT Justify();
  731. VARIANT GetLeft();
  732. long GetListHeaderRows();
  733. VARIANT ListNames();
  734. long GetLocationInTable();
  735. VARIANT GetLocked();
  736. void SetLocked(const VARIANT& newValue);
  737. void Merge(const VARIANT& Across);
  738. void UnMerge();
  739. LPDISPATCH GetMergeArea();
  740. VARIANT GetMergeCells();
  741. void SetMergeCells(const VARIANT& newValue);
  742. VARIANT GetName();
  743. void SetName(const VARIANT& newValue);
  744. VARIANT NavigateArrow(const VARIANT& TowardPrecedent, const VARIANT& ArrowNumber, const VARIANT& LinkNumber);
  745. LPUNKNOWN Get_NewEnum();
  746. LPDISPATCH GetNext();
  747. CString NoteText(const VARIANT& Text, const VARIANT& Start, const VARIANT& Length);
  748. VARIANT GetNumberFormat();
  749. void SetNumberFormat(const VARIANT& newValue);
  750. VARIANT GetNumberFormatLocal();
  751. void SetNumberFormatLocal(const VARIANT& newValue);
  752. LPDISPATCH GetOffset(const VARIANT& RowOffset, const VARIANT& ColumnOffset);
  753. VARIANT GetOrientation();
  754. void SetOrientation(const VARIANT& newValue);
  755. VARIANT GetOutlineLevel();
  756. void SetOutlineLevel(const VARIANT& newValue);
  757. long GetPageBreak();
  758. void SetPageBreak(long nNewValue);
  759. VARIANT Parse(const VARIANT& ParseLine, const VARIANT& Destination);
  760. VARIANT PasteSpecial(long Paste, long Operation, const VARIANT& SkipBlanks, const VARIANT& Transpose);
  761. LPDISPATCH GetPivotField();
  762. LPDISPATCH GetPivotItem();
  763. LPDISPATCH GetPivotTable();
  764. LPDISPATCH GetPrecedents();
  765. VARIANT GetPrefixCharacter();
  766. LPDISPATCH GetPrevious();
  767. VARIANT _PrintOut(const VARIANT& From, const VARIANT& To, const VARIANT& Copies, const VARIANT& Preview, const VARIANT& ActivePrinter, const VARIANT& PrintToFile, const VARIANT& Collate);
  768. VARIANT PrintPreview(const VARIANT& EnableChanges);
  769. LPDISPATCH GetQueryTable();
  770. LPDISPATCH GetRange(const VARIANT& Cell1, const VARIANT& Cell2);
  771. VARIANT RemoveSubtotal();
  772. BOOL Replace(const VARIANT& What, const VARIANT& Replacement, const VARIANT& LookAt, const VARIANT& SearchOrder, const VARIANT& MatchCase, const VARIANT& MatchByte);
  773. LPDISPATCH GetResize(const VARIANT& RowSize, const VARIANT& ColumnSize);
  774. long GetRow();
  775. LPDISPATCH RowDifferences(const VARIANT& Comparison);
  776. VARIANT GetRowHeight();
  777. void SetRowHeight(const VARIANT& newValue);
  778. LPDISPATCH GetRows();
  779. 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,
  780. 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,
  781. 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);
  782. VARIANT Select();
  783. VARIANT Show();
  784. VARIANT ShowDependents(const VARIANT& Remove);
  785. VARIANT GetShowDetail();
  786. void SetShowDetail(const VARIANT& newValue);
  787. VARIANT ShowErrors();
  788. VARIANT ShowPrecedents(const VARIANT& Remove);
  789. VARIANT GetShrinkToFit();
  790. void SetShrinkToFit(const VARIANT& newValue);
  791. 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);
  792. 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,
  793. long Orientation);
  794. LPDISPATCH GetSoundNote();
  795. LPDISPATCH SpecialCells(long Type, const VARIANT& Value);
  796. VARIANT GetStyle();
  797. void SetStyle(const VARIANT& newValue);
  798. VARIANT SubscribeTo(LPCTSTR Edition, long Format);
  799. VARIANT Subtotal(long GroupBy, long Function, const VARIANT& TotalList, const VARIANT& Replace, const VARIANT& PageBreaks, long SummaryBelowData);
  800. VARIANT GetSummary();
  801. VARIANT Table(const VARIANT& RowInput, const VARIANT& ColumnInput);
  802. VARIANT GetText();
  803. 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,
  804. const VARIANT& OtherChar, const VARIANT& FieldInfo, const VARIANT& DecimalSeparator, const VARIANT& ThousandsSeparator);
  805. VARIANT GetTop();
  806. VARIANT Ungroup();
  807. VARIANT GetUseStandardHeight();
  808. void SetUseStandardHeight(const VARIANT& newValue);
  809. VARIANT GetUseStandardWidth();
  810. void SetUseStandardWidth(const VARIANT& newValue);
  811. LPDISPATCH GetValidation();
  812. VARIANT GetValue();
  813. void SetValue(const VARIANT& newValue);
  814. VARIANT GetValue2();
  815. void SetValue2(const VARIANT& newValue);
  816. VARIANT GetVerticalAlignment();
  817. void SetVerticalAlignment(const VARIANT& newValue);
  818. VARIANT GetWidth();
  819. LPDISPATCH GetWorksheet();
  820. VARIANT GetWrapText();
  821. void SetWrapText(const VARIANT& newValue);
  822. LPDISPATCH AddComment(const VARIANT& Text);
  823. LPDISPATCH GetComment();
  824. void ClearComments();
  825. LPDISPATCH GetPhonetic();
  826. LPDISPATCH GetFormatConditions();
  827. long GetReadingOrder();
  828. void SetReadingOrder(long nNewValue);
  829. LPDISPATCH GetHyperlinks();
  830. LPDISPATCH GetPhonetics();
  831. void SetPhonetic();
  832. CString GetId();
  833. void SetId(LPCTSTR lpszNewValue);
  834. 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);
  835. };
  836. /////////////////////////////////////////////////////////////////////////////
  837. // Borders wrapper class
  838. class Borders : public COleDispatchDriver
  839. {
  840. public:
  841. Borders() {} // Calls COleDispatchDriver default constructor
  842. Borders(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
  843. Borders(const Borders& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
  844. // Attributes
  845. public:
  846. // Operations
  847. public:
  848. LPDISPATCH GetApplication();
  849. long GetCreator();
  850. LPDISPATCH GetParent();
  851. VARIANT GetColor();
  852. void SetColor(const VARIANT& newValue);
  853. VARIANT GetColorIndex();
  854. void SetColorIndex(const VARIANT& newValue);
  855. long GetCount();
  856. LPDISPATCH GetItem(long Index);
  857. VARIANT GetLineStyle();
  858. void SetLineStyle(const VARIANT& newValue);
  859. LPUNKNOWN Get_NewEnum();
  860. VARIANT GetValue();
  861. void SetValue(const VARIANT& newValue);
  862. VARIANT GetWeight();
  863. void SetWeight(const VARIANT& newValue);
  864. LPDISPATCH Get_Default(long Index);
  865. };
  866. /////////////////////////////////////////////////////////////////////////////
  867. // Worksheets wrapper class
  868. class Worksheets : public COleDispatchDriver
  869. {
  870. public:
  871. Worksheets() {} // Calls COleDispatchDriver default constructor
  872. Worksheets(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
  873. Worksheets(const Worksheets& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
  874. // Attributes
  875. public:
  876. // Operations
  877. public:
  878. LPDISPATCH GetApplication();
  879. long GetCreator();
  880. LPDISPATCH GetParent();
  881. LPDISPATCH Add(const VARIANT& Before, const VARIANT& After, const VARIANT& Count, const VARIANT& Type);
  882. void Copy(const VARIANT& Before, const VARIANT& After);
  883. long GetCount();
  884. void Delete();
  885. void FillAcrossSheets(LPDISPATCH Range, long Type);
  886. LPDISPATCH GetItem(const VARIANT& Index);
  887. void Move(const VARIANT& Before, const VARIANT& After);
  888. LPUNKNOWN Get_NewEnum();
  889. void PrintPreview(const VARIANT& EnableChanges);
  890. void Select(const VARIANT& Replace);
  891. LPDISPATCH GetHPageBreaks();
  892. LPDISPATCH GetVPageBreaks();
  893. VARIANT GetVisible();
  894. void SetVisible(const VARIANT& newValue);
  895. LPDISPATCH Get_Default(const VARIANT& Index);
  896. 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);
  897. };
  898. /////////////////////////////////////////////////////////////////////////////
  899. // Interior wrapper class
  900. class Interior : public COleDispatchDriver
  901. {
  902. public:
  903. Interior() {} // Calls COleDispatchDriver default constructor
  904. Interior(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
  905. Interior(const Interior& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
  906. // Attributes
  907. public:
  908. // Operations
  909. public:
  910. LPDISPATCH GetApplication();
  911. long GetCreator();
  912. LPDISPATCH GetParent();
  913. VARIANT GetColor();
  914. void SetColor(const VARIANT& newValue);
  915. VARIANT GetColorIndex();
  916. void SetColorIndex(const VARIANT& newValue);
  917. VARIANT GetInvertIfNegative();
  918. void SetInvertIfNegative(const VARIANT& newValue);
  919. VARIANT GetPattern();
  920. void SetPattern(const VARIANT& newValue);
  921. VARIANT GetPatternColor();
  922. void SetPatternColor(const VARIANT& newValue);
  923. VARIANT GetPatternColorIndex();
  924. void SetPatternColorIndex(const VARIANT& newValue);
  925. };
  926. /////////////////////////////////////////////////////////////////////////////
  927. // Border wrapper class
  928. class Border : public COleDispatchDriver
  929. {
  930. public:
  931. Border() {} // Calls COleDispatchDriver default constructor
  932. Border(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
  933. Border(const Border& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
  934. // Attributes
  935. public:
  936. // Operations
  937. public:
  938. LPDISPATCH GetApplication();
  939. long GetCreator();
  940. LPDISPATCH GetParent();
  941. VARIANT GetColor();
  942. void SetColor(const VARIANT& newValue);
  943. VARIANT GetColorIndex();
  944. void SetColorIndex(const VARIANT& newValue);
  945. VARIANT GetLineStyle();
  946. void SetLineStyle(const VARIANT& newValue);
  947. VARIANT GetWeight();
  948. void SetWeight(const VARIANT& newValue);
  949. };