excel8.h 39 KB

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