CWorksheet.h 26 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830
  1. // Machine generated IDispatch wrapper class(es) created with Add Class from Typelib Wizard
  2. //#import "D:\\Program Files\\Microsoft Office\\OFFICE11\\EXCEL.EXE" no_namespace
  3. // CWorksheet wrapper class
  4. class CWorksheet : public COleDispatchDriver
  5. {
  6. public:
  7. CWorksheet(){} // Calls COleDispatchDriver default constructor
  8. CWorksheet(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
  9. CWorksheet(const CWorksheet& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
  10. // Attributes
  11. public:
  12. // Operations
  13. public:
  14. // _Worksheet methods
  15. public:
  16. LPDISPATCH get_Application()
  17. {
  18. LPDISPATCH result;
  19. InvokeHelper(0x94, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
  20. return result;
  21. }
  22. long get_Creator()
  23. {
  24. long result;
  25. InvokeHelper(0x95, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
  26. return result;
  27. }
  28. LPDISPATCH get_Parent()
  29. {
  30. LPDISPATCH result;
  31. InvokeHelper(0x96, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
  32. return result;
  33. }
  34. void Activate()
  35. {
  36. InvokeHelper(0x130, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
  37. }
  38. void Copy(VARIANT& Before, VARIANT& After)
  39. {
  40. static BYTE parms[] = VTS_VARIANT VTS_VARIANT ;
  41. InvokeHelper(0x227, DISPATCH_METHOD, VT_EMPTY, NULL, parms, &Before, &After);
  42. }
  43. void Delete()
  44. {
  45. InvokeHelper(0x75, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
  46. }
  47. CString get_CodeName()
  48. {
  49. CString result;
  50. InvokeHelper(0x55d, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
  51. return result;
  52. }
  53. CString get__CodeName()
  54. {
  55. CString result;
  56. InvokeHelper(0x80010000, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
  57. return result;
  58. }
  59. void put__CodeName(LPCTSTR newValue)
  60. {
  61. static BYTE parms[] = VTS_BSTR ;
  62. InvokeHelper(0x80010000, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, newValue);
  63. }
  64. long get_Index()
  65. {
  66. long result;
  67. InvokeHelper(0x1e6, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
  68. return result;
  69. }
  70. void Move(VARIANT& Before, VARIANT& After)
  71. {
  72. static BYTE parms[] = VTS_VARIANT VTS_VARIANT ;
  73. InvokeHelper(0x27d, DISPATCH_METHOD, VT_EMPTY, NULL, parms, &Before, &After);
  74. }
  75. CString get_Name()
  76. {
  77. CString result;
  78. InvokeHelper(0x6e, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
  79. return result;
  80. }
  81. void put_Name(LPCTSTR newValue)
  82. {
  83. static BYTE parms[] = VTS_BSTR ;
  84. InvokeHelper(0x6e, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, newValue);
  85. }
  86. LPDISPATCH get_Next()
  87. {
  88. LPDISPATCH result;
  89. InvokeHelper(0x1f6, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
  90. return result;
  91. }
  92. CString get_OnDoubleClick()
  93. {
  94. CString result;
  95. InvokeHelper(0x274, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
  96. return result;
  97. }
  98. void put_OnDoubleClick(LPCTSTR newValue)
  99. {
  100. static BYTE parms[] = VTS_BSTR ;
  101. InvokeHelper(0x274, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, newValue);
  102. }
  103. CString get_OnSheetActivate()
  104. {
  105. CString result;
  106. InvokeHelper(0x407, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
  107. return result;
  108. }
  109. void put_OnSheetActivate(LPCTSTR newValue)
  110. {
  111. static BYTE parms[] = VTS_BSTR ;
  112. InvokeHelper(0x407, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, newValue);
  113. }
  114. CString get_OnSheetDeactivate()
  115. {
  116. CString result;
  117. InvokeHelper(0x439, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
  118. return result;
  119. }
  120. void put_OnSheetDeactivate(LPCTSTR newValue)
  121. {
  122. static BYTE parms[] = VTS_BSTR ;
  123. InvokeHelper(0x439, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, newValue);
  124. }
  125. LPDISPATCH get_PageSetup()
  126. {
  127. LPDISPATCH result;
  128. InvokeHelper(0x3e6, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
  129. return result;
  130. }
  131. LPDISPATCH get_Previous()
  132. {
  133. LPDISPATCH result;
  134. InvokeHelper(0x1f7, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
  135. return result;
  136. }
  137. void _PrintOut(VARIANT& From, VARIANT& To, VARIANT& Copies, VARIANT& Preview, VARIANT& ActivePrinter, VARIANT& PrintToFile, VARIANT& Collate)
  138. {
  139. static BYTE parms[] = VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT ;
  140. InvokeHelper(0x389, DISPATCH_METHOD, VT_EMPTY, NULL, parms, &From, &To, &Copies, &Preview, &ActivePrinter, &PrintToFile, &Collate);
  141. }
  142. void PrintPreview(VARIANT& EnableChanges)
  143. {
  144. static BYTE parms[] = VTS_VARIANT ;
  145. InvokeHelper(0x119, DISPATCH_METHOD, VT_EMPTY, NULL, parms, &EnableChanges);
  146. }
  147. void _Protect(VARIANT& Password, VARIANT& DrawingObjects, VARIANT& Contents, VARIANT& Scenarios, VARIANT& UserInterfaceOnly)
  148. {
  149. static BYTE parms[] = VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT ;
  150. InvokeHelper(0x11a, DISPATCH_METHOD, VT_EMPTY, NULL, parms, &Password, &DrawingObjects, &Contents, &Scenarios, &UserInterfaceOnly);
  151. }
  152. BOOL get_ProtectContents()
  153. {
  154. BOOL result;
  155. InvokeHelper(0x124, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
  156. return result;
  157. }
  158. BOOL get_ProtectDrawingObjects()
  159. {
  160. BOOL result;
  161. InvokeHelper(0x125, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
  162. return result;
  163. }
  164. BOOL get_ProtectionMode()
  165. {
  166. BOOL result;
  167. InvokeHelper(0x487, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
  168. return result;
  169. }
  170. BOOL get_ProtectScenarios()
  171. {
  172. BOOL result;
  173. InvokeHelper(0x126, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
  174. return result;
  175. }
  176. void _SaveAs(LPCTSTR Filename, VARIANT& FileFormat, VARIANT& Password, VARIANT& WriteResPassword, VARIANT& ReadOnlyRecommended, VARIANT& CreateBackup, VARIANT& AddToMru, VARIANT& TextCodepage, VARIANT& TextVisualLayout)
  177. {
  178. static BYTE parms[] = VTS_BSTR VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT ;
  179. InvokeHelper(0x11c, DISPATCH_METHOD, VT_EMPTY, NULL, parms, Filename, &FileFormat, &Password, &WriteResPassword, &ReadOnlyRecommended, &CreateBackup, &AddToMru, &TextCodepage, &TextVisualLayout);
  180. }
  181. void Select(VARIANT& Replace)
  182. {
  183. static BYTE parms[] = VTS_VARIANT ;
  184. InvokeHelper(0xeb, DISPATCH_METHOD, VT_EMPTY, NULL, parms, &Replace);
  185. }
  186. void Unprotect(VARIANT& Password)
  187. {
  188. static BYTE parms[] = VTS_VARIANT ;
  189. InvokeHelper(0x11d, DISPATCH_METHOD, VT_EMPTY, NULL, parms, &Password);
  190. }
  191. long get_Visible()
  192. {
  193. long result;
  194. InvokeHelper(0x22e, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
  195. return result;
  196. }
  197. void put_Visible(long newValue)
  198. {
  199. static BYTE parms[] = VTS_I4 ;
  200. InvokeHelper(0x22e, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, newValue);
  201. }
  202. LPDISPATCH get_Shapes()
  203. {
  204. LPDISPATCH result;
  205. InvokeHelper(0x561, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
  206. return result;
  207. }
  208. BOOL get_TransitionExpEval()
  209. {
  210. BOOL result;
  211. InvokeHelper(0x191, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
  212. return result;
  213. }
  214. void put_TransitionExpEval(BOOL newValue)
  215. {
  216. static BYTE parms[] = VTS_BOOL ;
  217. InvokeHelper(0x191, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, newValue);
  218. }
  219. LPDISPATCH Arcs(VARIANT& Index)
  220. {
  221. LPDISPATCH result;
  222. static BYTE parms[] = VTS_VARIANT ;
  223. InvokeHelper(0x2f8, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms, &Index);
  224. return result;
  225. }
  226. BOOL get_AutoFilterMode()
  227. {
  228. BOOL result;
  229. InvokeHelper(0x318, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
  230. return result;
  231. }
  232. void put_AutoFilterMode(BOOL newValue)
  233. {
  234. static BYTE parms[] = VTS_BOOL ;
  235. InvokeHelper(0x318, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, newValue);
  236. }
  237. void SetBackgroundPicture(LPCTSTR Filename)
  238. {
  239. static BYTE parms[] = VTS_BSTR ;
  240. InvokeHelper(0x4a4, DISPATCH_METHOD, VT_EMPTY, NULL, parms, Filename);
  241. }
  242. LPDISPATCH Buttons(VARIANT& Index)
  243. {
  244. LPDISPATCH result;
  245. static BYTE parms[] = VTS_VARIANT ;
  246. InvokeHelper(0x22d, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms, &Index);
  247. return result;
  248. }
  249. void Calculate()
  250. {
  251. InvokeHelper(0x117, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
  252. }
  253. BOOL get_EnableCalculation()
  254. {
  255. BOOL result;
  256. InvokeHelper(0x590, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
  257. return result;
  258. }
  259. void put_EnableCalculation(BOOL newValue)
  260. {
  261. static BYTE parms[] = VTS_BOOL ;
  262. InvokeHelper(0x590, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, newValue);
  263. }
  264. LPDISPATCH get_Cells()
  265. {
  266. LPDISPATCH result;
  267. InvokeHelper(0xee, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
  268. return result;
  269. }
  270. LPDISPATCH ChartObjects(VARIANT& Index)
  271. {
  272. LPDISPATCH result;
  273. static BYTE parms[] = VTS_VARIANT ;
  274. InvokeHelper(0x424, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms, &Index);
  275. return result;
  276. }
  277. LPDISPATCH CheckBoxes(VARIANT& Index)
  278. {
  279. LPDISPATCH result;
  280. static BYTE parms[] = VTS_VARIANT ;
  281. InvokeHelper(0x338, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms, &Index);
  282. return result;
  283. }
  284. void CheckSpelling(VARIANT& CustomDictionary, VARIANT& IgnoreUppercase, VARIANT& AlwaysSuggest, VARIANT& SpellLang)
  285. {
  286. static BYTE parms[] = VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT ;
  287. InvokeHelper(0x1f9, DISPATCH_METHOD, VT_EMPTY, NULL, parms, &CustomDictionary, &IgnoreUppercase, &AlwaysSuggest, &SpellLang);
  288. }
  289. LPDISPATCH get_CircularReference()
  290. {
  291. LPDISPATCH result;
  292. InvokeHelper(0x42d, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
  293. return result;
  294. }
  295. void ClearArrows()
  296. {
  297. InvokeHelper(0x3ca, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
  298. }
  299. LPDISPATCH get_Columns()
  300. {
  301. LPDISPATCH result;
  302. InvokeHelper(0xf1, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
  303. return result;
  304. }
  305. long get_ConsolidationFunction()
  306. {
  307. long result;
  308. InvokeHelper(0x315, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
  309. return result;
  310. }
  311. VARIANT get_ConsolidationOptions()
  312. {
  313. VARIANT result;
  314. InvokeHelper(0x316, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
  315. return result;
  316. }
  317. VARIANT get_ConsolidationSources()
  318. {
  319. VARIANT result;
  320. InvokeHelper(0x317, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
  321. return result;
  322. }
  323. BOOL get_DisplayAutomaticPageBreaks()
  324. {
  325. BOOL result;
  326. InvokeHelper(0x283, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
  327. return result;
  328. }
  329. void put_DisplayAutomaticPageBreaks(BOOL newValue)
  330. {
  331. static BYTE parms[] = VTS_BOOL ;
  332. InvokeHelper(0x283, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, newValue);
  333. }
  334. LPDISPATCH Drawings(VARIANT& Index)
  335. {
  336. LPDISPATCH result;
  337. static BYTE parms[] = VTS_VARIANT ;
  338. InvokeHelper(0x304, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms, &Index);
  339. return result;
  340. }
  341. LPDISPATCH DrawingObjects(VARIANT& Index)
  342. {
  343. LPDISPATCH result;
  344. static BYTE parms[] = VTS_VARIANT ;
  345. InvokeHelper(0x58, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms, &Index);
  346. return result;
  347. }
  348. LPDISPATCH DropDowns(VARIANT& Index)
  349. {
  350. LPDISPATCH result;
  351. static BYTE parms[] = VTS_VARIANT ;
  352. InvokeHelper(0x344, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms, &Index);
  353. return result;
  354. }
  355. BOOL get_EnableAutoFilter()
  356. {
  357. BOOL result;
  358. InvokeHelper(0x484, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
  359. return result;
  360. }
  361. void put_EnableAutoFilter(BOOL newValue)
  362. {
  363. static BYTE parms[] = VTS_BOOL ;
  364. InvokeHelper(0x484, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, newValue);
  365. }
  366. long get_EnableSelection()
  367. {
  368. long result;
  369. InvokeHelper(0x591, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
  370. return result;
  371. }
  372. void put_EnableSelection(long newValue)
  373. {
  374. static BYTE parms[] = VTS_I4 ;
  375. InvokeHelper(0x591, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, newValue);
  376. }
  377. BOOL get_EnableOutlining()
  378. {
  379. BOOL result;
  380. InvokeHelper(0x485, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
  381. return result;
  382. }
  383. void put_EnableOutlining(BOOL newValue)
  384. {
  385. static BYTE parms[] = VTS_BOOL ;
  386. InvokeHelper(0x485, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, newValue);
  387. }
  388. BOOL get_EnablePivotTable()
  389. {
  390. BOOL result;
  391. InvokeHelper(0x486, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
  392. return result;
  393. }
  394. void put_EnablePivotTable(BOOL newValue)
  395. {
  396. static BYTE parms[] = VTS_BOOL ;
  397. InvokeHelper(0x486, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, newValue);
  398. }
  399. VARIANT Evaluate(VARIANT& Name)
  400. {
  401. VARIANT result;
  402. static BYTE parms[] = VTS_VARIANT ;
  403. InvokeHelper(0x1, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms, &Name);
  404. return result;
  405. }
  406. VARIANT _Evaluate(VARIANT& Name)
  407. {
  408. VARIANT result;
  409. static BYTE parms[] = VTS_VARIANT ;
  410. InvokeHelper(0xfffffffb, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms, &Name);
  411. return result;
  412. }
  413. BOOL get_FilterMode()
  414. {
  415. BOOL result;
  416. InvokeHelper(0x320, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
  417. return result;
  418. }
  419. void ResetAllPageBreaks()
  420. {
  421. InvokeHelper(0x592, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
  422. }
  423. LPDISPATCH GroupBoxes(VARIANT& Index)
  424. {
  425. LPDISPATCH result;
  426. static BYTE parms[] = VTS_VARIANT ;
  427. InvokeHelper(0x342, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms, &Index);
  428. return result;
  429. }
  430. LPDISPATCH GroupObjects(VARIANT& Index)
  431. {
  432. LPDISPATCH result;
  433. static BYTE parms[] = VTS_VARIANT ;
  434. InvokeHelper(0x459, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms, &Index);
  435. return result;
  436. }
  437. LPDISPATCH Labels(VARIANT& Index)
  438. {
  439. LPDISPATCH result;
  440. static BYTE parms[] = VTS_VARIANT ;
  441. InvokeHelper(0x349, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms, &Index);
  442. return result;
  443. }
  444. LPDISPATCH Lines(VARIANT& Index)
  445. {
  446. LPDISPATCH result;
  447. static BYTE parms[] = VTS_VARIANT ;
  448. InvokeHelper(0x2ff, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms, &Index);
  449. return result;
  450. }
  451. LPDISPATCH ListBoxes(VARIANT& Index)
  452. {
  453. LPDISPATCH result;
  454. static BYTE parms[] = VTS_VARIANT ;
  455. InvokeHelper(0x340, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms, &Index);
  456. return result;
  457. }
  458. LPDISPATCH get_Names()
  459. {
  460. LPDISPATCH result;
  461. InvokeHelper(0x1ba, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
  462. return result;
  463. }
  464. LPDISPATCH OLEObjects(VARIANT& Index)
  465. {
  466. LPDISPATCH result;
  467. static BYTE parms[] = VTS_VARIANT ;
  468. InvokeHelper(0x31f, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms, &Index);
  469. return result;
  470. }
  471. CString get_OnCalculate()
  472. {
  473. CString result;
  474. InvokeHelper(0x271, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
  475. return result;
  476. }
  477. void put_OnCalculate(LPCTSTR newValue)
  478. {
  479. static BYTE parms[] = VTS_BSTR ;
  480. InvokeHelper(0x271, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, newValue);
  481. }
  482. CString get_OnData()
  483. {
  484. CString result;
  485. InvokeHelper(0x275, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
  486. return result;
  487. }
  488. void put_OnData(LPCTSTR newValue)
  489. {
  490. static BYTE parms[] = VTS_BSTR ;
  491. InvokeHelper(0x275, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, newValue);
  492. }
  493. CString get_OnEntry()
  494. {
  495. CString result;
  496. InvokeHelper(0x273, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
  497. return result;
  498. }
  499. void put_OnEntry(LPCTSTR newValue)
  500. {
  501. static BYTE parms[] = VTS_BSTR ;
  502. InvokeHelper(0x273, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, newValue);
  503. }
  504. LPDISPATCH OptionButtons(VARIANT& Index)
  505. {
  506. LPDISPATCH result;
  507. static BYTE parms[] = VTS_VARIANT ;
  508. InvokeHelper(0x33a, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms, &Index);
  509. return result;
  510. }
  511. LPDISPATCH get_Outline()
  512. {
  513. LPDISPATCH result;
  514. InvokeHelper(0x66, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
  515. return result;
  516. }
  517. LPDISPATCH Ovals(VARIANT& Index)
  518. {
  519. LPDISPATCH result;
  520. static BYTE parms[] = VTS_VARIANT ;
  521. InvokeHelper(0x321, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms, &Index);
  522. return result;
  523. }
  524. void Paste(VARIANT& Destination, VARIANT& Link)
  525. {
  526. static BYTE parms[] = VTS_VARIANT VTS_VARIANT ;
  527. InvokeHelper(0xd3, DISPATCH_METHOD, VT_EMPTY, NULL, parms, &Destination, &Link);
  528. }
  529. void _PasteSpecial(VARIANT& Format, VARIANT& Link, VARIANT& DisplayAsIcon, VARIANT& IconFileName, VARIANT& IconIndex, VARIANT& IconLabel)
  530. {
  531. static BYTE parms[] = VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT ;
  532. InvokeHelper(0x403, DISPATCH_METHOD, VT_EMPTY, NULL, parms, &Format, &Link, &DisplayAsIcon, &IconFileName, &IconIndex, &IconLabel);
  533. }
  534. LPDISPATCH Pictures(VARIANT& Index)
  535. {
  536. LPDISPATCH result;
  537. static BYTE parms[] = VTS_VARIANT ;
  538. InvokeHelper(0x303, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms, &Index);
  539. return result;
  540. }
  541. LPDISPATCH PivotTables(VARIANT& Index)
  542. {
  543. LPDISPATCH result;
  544. static BYTE parms[] = VTS_VARIANT ;
  545. InvokeHelper(0x2b2, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms, &Index);
  546. return result;
  547. }
  548. LPDISPATCH PivotTableWizard(VARIANT& SourceType, VARIANT& SourceData, VARIANT& TableDestination, VARIANT& TableName, VARIANT& RowGrand, VARIANT& ColumnGrand, VARIANT& SaveData, VARIANT& HasAutoFormat, VARIANT& AutoPage, VARIANT& Reserved, VARIANT& BackgroundQuery, VARIANT& OptimizeCache, VARIANT& PageFieldOrder, VARIANT& PageFieldWrapCount, VARIANT& ReadData, VARIANT& Connection)
  549. {
  550. LPDISPATCH result;
  551. static BYTE parms[] = VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT ;
  552. InvokeHelper(0x2ac, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms, &SourceType, &SourceData, &TableDestination, &TableName, &RowGrand, &ColumnGrand, &SaveData, &HasAutoFormat, &AutoPage, &Reserved, &BackgroundQuery, &OptimizeCache, &PageFieldOrder, &PageFieldWrapCount, &ReadData, &Connection);
  553. return result;
  554. }
  555. LPDISPATCH get_Range(VARIANT& Cell1, VARIANT& Cell2)
  556. {
  557. LPDISPATCH result;
  558. static BYTE parms[] = VTS_VARIANT VTS_VARIANT ;
  559. InvokeHelper(0xc5, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, parms, &Cell1, &Cell2);
  560. return result;
  561. }
  562. LPDISPATCH Rectangles(VARIANT& Index)
  563. {
  564. LPDISPATCH result;
  565. static BYTE parms[] = VTS_VARIANT ;
  566. InvokeHelper(0x306, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms, &Index);
  567. return result;
  568. }
  569. LPDISPATCH get_Rows()
  570. {
  571. LPDISPATCH result;
  572. InvokeHelper(0x102, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
  573. return result;
  574. }
  575. LPDISPATCH Scenarios(VARIANT& Index)
  576. {
  577. LPDISPATCH result;
  578. static BYTE parms[] = VTS_VARIANT ;
  579. InvokeHelper(0x38c, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms, &Index);
  580. return result;
  581. }
  582. CString get_ScrollArea()
  583. {
  584. CString result;
  585. InvokeHelper(0x599, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
  586. return result;
  587. }
  588. void put_ScrollArea(LPCTSTR newValue)
  589. {
  590. static BYTE parms[] = VTS_BSTR ;
  591. InvokeHelper(0x599, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, newValue);
  592. }
  593. LPDISPATCH ScrollBars(VARIANT& Index)
  594. {
  595. LPDISPATCH result;
  596. static BYTE parms[] = VTS_VARIANT ;
  597. InvokeHelper(0x33e, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms, &Index);
  598. return result;
  599. }
  600. void ShowAllData()
  601. {
  602. InvokeHelper(0x31a, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
  603. }
  604. void ShowDataForm()
  605. {
  606. InvokeHelper(0x199, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
  607. }
  608. LPDISPATCH Spinners(VARIANT& Index)
  609. {
  610. LPDISPATCH result;
  611. static BYTE parms[] = VTS_VARIANT ;
  612. InvokeHelper(0x346, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms, &Index);
  613. return result;
  614. }
  615. double get_StandardHeight()
  616. {
  617. double result;
  618. InvokeHelper(0x197, DISPATCH_PROPERTYGET, VT_R8, (void*)&result, NULL);
  619. return result;
  620. }
  621. double get_StandardWidth()
  622. {
  623. double result;
  624. InvokeHelper(0x198, DISPATCH_PROPERTYGET, VT_R8, (void*)&result, NULL);
  625. return result;
  626. }
  627. void put_StandardWidth(double newValue)
  628. {
  629. static BYTE parms[] = VTS_R8 ;
  630. InvokeHelper(0x198, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, newValue);
  631. }
  632. LPDISPATCH TextBoxes(VARIANT& Index)
  633. {
  634. LPDISPATCH result;
  635. static BYTE parms[] = VTS_VARIANT ;
  636. InvokeHelper(0x309, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms, &Index);
  637. return result;
  638. }
  639. BOOL get_TransitionFormEntry()
  640. {
  641. BOOL result;
  642. InvokeHelper(0x192, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
  643. return result;
  644. }
  645. void put_TransitionFormEntry(BOOL newValue)
  646. {
  647. static BYTE parms[] = VTS_BOOL ;
  648. InvokeHelper(0x192, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, newValue);
  649. }
  650. long get_Type()
  651. {
  652. long result;
  653. InvokeHelper(0x6c, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
  654. return result;
  655. }
  656. LPDISPATCH get_UsedRange()
  657. {
  658. LPDISPATCH result;
  659. InvokeHelper(0x19c, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
  660. return result;
  661. }
  662. LPDISPATCH get_HPageBreaks()
  663. {
  664. LPDISPATCH result;
  665. InvokeHelper(0x58a, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
  666. return result;
  667. }
  668. LPDISPATCH get_VPageBreaks()
  669. {
  670. LPDISPATCH result;
  671. InvokeHelper(0x58b, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
  672. return result;
  673. }
  674. LPDISPATCH get_QueryTables()
  675. {
  676. LPDISPATCH result;
  677. InvokeHelper(0x59a, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
  678. return result;
  679. }
  680. BOOL get_DisplayPageBreaks()
  681. {
  682. BOOL result;
  683. InvokeHelper(0x59b, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
  684. return result;
  685. }
  686. void put_DisplayPageBreaks(BOOL newValue)
  687. {
  688. static BYTE parms[] = VTS_BOOL ;
  689. InvokeHelper(0x59b, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, newValue);
  690. }
  691. LPDISPATCH get_Comments()
  692. {
  693. LPDISPATCH result;
  694. InvokeHelper(0x23f, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
  695. return result;
  696. }
  697. LPDISPATCH get_Hyperlinks()
  698. {
  699. LPDISPATCH result;
  700. InvokeHelper(0x571, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
  701. return result;
  702. }
  703. void ClearCircles()
  704. {
  705. InvokeHelper(0x59c, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
  706. }
  707. void CircleInvalid()
  708. {
  709. InvokeHelper(0x59d, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
  710. }
  711. long get__DisplayRightToLeft()
  712. {
  713. long result;
  714. InvokeHelper(0x288, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
  715. return result;
  716. }
  717. void put__DisplayRightToLeft(long newValue)
  718. {
  719. static BYTE parms[] = VTS_I4 ;
  720. InvokeHelper(0x288, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, newValue);
  721. }
  722. LPDISPATCH get_AutoFilter()
  723. {
  724. LPDISPATCH result;
  725. InvokeHelper(0x319, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
  726. return result;
  727. }
  728. BOOL get_DisplayRightToLeft()
  729. {
  730. BOOL result;
  731. InvokeHelper(0x6ee, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
  732. return result;
  733. }
  734. void put_DisplayRightToLeft(BOOL newValue)
  735. {
  736. static BYTE parms[] = VTS_BOOL ;
  737. InvokeHelper(0x6ee, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, newValue);
  738. }
  739. LPDISPATCH get_Scripts()
  740. {
  741. LPDISPATCH result;
  742. InvokeHelper(0x718, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
  743. return result;
  744. }
  745. void PrintOut(VARIANT& From, VARIANT& To, VARIANT& Copies, VARIANT& Preview, VARIANT& ActivePrinter, VARIANT& PrintToFile, VARIANT& Collate, VARIANT& PrToFileName)
  746. {
  747. static BYTE parms[] = VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT ;
  748. InvokeHelper(0x6ec, DISPATCH_METHOD, VT_EMPTY, NULL, parms, &From, &To, &Copies, &Preview, &ActivePrinter, &PrintToFile, &Collate, &PrToFileName);
  749. }
  750. void _CheckSpelling(VARIANT& CustomDictionary, VARIANT& IgnoreUppercase, VARIANT& AlwaysSuggest, VARIANT& SpellLang, VARIANT& IgnoreFinalYaa, VARIANT& SpellScript)
  751. {
  752. static BYTE parms[] = VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT ;
  753. InvokeHelper(0x719, DISPATCH_METHOD, VT_EMPTY, NULL, parms, &CustomDictionary, &IgnoreUppercase, &AlwaysSuggest, &SpellLang, &IgnoreFinalYaa, &SpellScript);
  754. }
  755. LPDISPATCH get_Tab()
  756. {
  757. LPDISPATCH result;
  758. InvokeHelper(0x411, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
  759. return result;
  760. }
  761. LPDISPATCH get_MailEnvelope()
  762. {
  763. LPDISPATCH result;
  764. InvokeHelper(0x7e5, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
  765. return result;
  766. }
  767. void SaveAs(LPCTSTR Filename, VARIANT& FileFormat, VARIANT& Password, VARIANT& WriteResPassword, VARIANT& ReadOnlyRecommended, VARIANT& CreateBackup, VARIANT& AddToMru, VARIANT& TextCodepage, VARIANT& TextVisualLayout, VARIANT& Local)
  768. {
  769. static BYTE parms[] = VTS_BSTR VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT ;
  770. InvokeHelper(0x785, DISPATCH_METHOD, VT_EMPTY, NULL, parms, Filename, &FileFormat, &Password, &WriteResPassword, &ReadOnlyRecommended, &CreateBackup, &AddToMru, &TextCodepage, &TextVisualLayout, &Local);
  771. }
  772. LPDISPATCH get_CustomProperties()
  773. {
  774. LPDISPATCH result;
  775. InvokeHelper(0x7ee, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
  776. return result;
  777. }
  778. LPDISPATCH get_SmartTags()
  779. {
  780. LPDISPATCH result;
  781. InvokeHelper(0x7e0, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
  782. return result;
  783. }
  784. LPDISPATCH get_Protection()
  785. {
  786. LPDISPATCH result;
  787. InvokeHelper(0xb0, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
  788. return result;
  789. }
  790. void PasteSpecial(VARIANT& Format, VARIANT& Link, VARIANT& DisplayAsIcon, VARIANT& IconFileName, VARIANT& IconIndex, VARIANT& IconLabel, VARIANT& NoHTMLFormatting)
  791. {
  792. static BYTE parms[] = VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT ;
  793. InvokeHelper(0x788, DISPATCH_METHOD, VT_EMPTY, NULL, parms, &Format, &Link, &DisplayAsIcon, &IconFileName, &IconIndex, &IconLabel, &NoHTMLFormatting);
  794. }
  795. void Protect(VARIANT& Password, VARIANT& DrawingObjects, VARIANT& Contents, VARIANT& Scenarios, VARIANT& UserInterfaceOnly, VARIANT& AllowFormattingCells, VARIANT& AllowFormattingColumns, VARIANT& AllowFormattingRows, VARIANT& AllowInsertingColumns, VARIANT& AllowInsertingRows, VARIANT& AllowInsertingHyperlinks, VARIANT& AllowDeletingColumns, VARIANT& AllowDeletingRows, VARIANT& AllowSorting, VARIANT& AllowFiltering, VARIANT& AllowUsingPivotTables)
  796. {
  797. static BYTE parms[] = VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT ;
  798. InvokeHelper(0x7ed, DISPATCH_METHOD, VT_EMPTY, NULL, parms, &Password, &DrawingObjects, &Contents, &Scenarios, &UserInterfaceOnly, &AllowFormattingCells, &AllowFormattingColumns, &AllowFormattingRows, &AllowInsertingColumns, &AllowInsertingRows, &AllowInsertingHyperlinks, &AllowDeletingColumns, &AllowDeletingRows, &AllowSorting, &AllowFiltering, &AllowUsingPivotTables);
  799. }
  800. LPDISPATCH get_ListObjects()
  801. {
  802. LPDISPATCH result;
  803. InvokeHelper(0x8d3, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
  804. return result;
  805. }
  806. LPDISPATCH XmlDataQuery(LPCTSTR XPath, VARIANT& SelectionNamespaces, VARIANT& Map)
  807. {
  808. LPDISPATCH result;
  809. static BYTE parms[] = VTS_BSTR VTS_VARIANT VTS_VARIANT ;
  810. InvokeHelper(0x8d4, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms, XPath, &SelectionNamespaces, &Map);
  811. return result;
  812. }
  813. LPDISPATCH XmlMapQuery(LPCTSTR XPath, VARIANT& SelectionNamespaces, VARIANT& Map)
  814. {
  815. LPDISPATCH result;
  816. static BYTE parms[] = VTS_BSTR VTS_VARIANT VTS_VARIANT ;
  817. InvokeHelper(0x8d7, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms, XPath, &SelectionNamespaces, &Map);
  818. return result;
  819. }
  820. // _Worksheet properties
  821. public:
  822. };