excel8.h 40 KB

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