Workbook control spreadsheet object method event details

1. activecell: return the range read-only object representing the active cell.
2. activesheet: returns the read-only worksheet object representing the active worksheet.
3. activewindow: return the window object of the current window.
4. activeworkbook: return the workbook object that opens the workbook.
5. allowpropertytoolbox: determines whether the "command and option" dialog box can be displayed during running. Boolean type.
6. Application: There are two cases. A) when applied to the owclanguagesetaskobject, The obejct object indicating the Web component is returned; B) the spreadsheet object indicating the workbook control is returned.
7. autofit: if the total size of the workbook is determined by the number of visible columns for the spreadsheet or receivttable object, set it to true. The Row Height and column width cannot exceed the maxheight and maxwidth attribute values in the workbook or PivotTable list. The default value is true. If the autofit attribute is set to false, the overall size of the workbook or PivotTable list is set by the width and height attributes. Boolean Type
8. Build: return a long type, indicating the compilation number of Web Components, read-only.
9. buildnumber: returns the internal version number. String type, read-only.
10. calculation: returns or sets the xlcalculation constant for the specified calculation mode.
11. calculationversion: returns the Web Components version of the long type.
12. canundo: returns true if any of the preceding operations can be undone. Read-Only
13. Caption: return or set the object title, string type
14. Cells: returns a range object that represents cells in an object.
15. columns: when the application is on the range object, it indicates that the range object representing the columns in the specified area is returned and is read-only. When the application is on the spreadsheet and worksheet objects, the range object representing all columns on the specified worksheet is returned.
16. commands: returns an occommands object, indicating a set of available commands.
17. constants: returns an object that allows the script user to use named constants, read-only. Required on the HTML page
18. csvdata: returns or sets the workbook data of the string type in a comma-separated list.
19. csvurl: return or set the URL of the workbook data file separated by commas.
20. datamember: return or set the data member name (specify the record set name that the control will obtain from the data source request). It is of the datamember type.
21. datasource: return or set the ADO datasource object of the specified control data source.
22. datatype: Specifies the workbook data format and source. Htmlurl, htmldata, csvurl, csvdata
23. defaqueryqueryonload: When this attribute is set to true, the binding with the purpose attribute value "query" and loadmode attribute value "normal" will be refreshed when the page is loaded. When set to false, no binding is refreshed when the page is loaded.
24. designMode: returns true if the workbook control is currently in design mode.
25. Dirty: If the workbook has been changed since the last save, true is returned. Read/write
26. displaydesigntimeui: Set to true to display the design phase version of the "commands and options" window during running. The default value is false.
27. displayofficelogo: if it is set to true, the Office logo can be displayed on the toolbar.
28. displaypropertytoolbox: Set whether to display the "commands and options" window.
29. displaytitlebar: sets whether the title bar can be displayed.
30. displaytoolbar: Set whether to display toolbar.
31. enableevents: If the workbook workspace event is enabled, true is returned and can be read and written.
32. enableundo: Enable the workbook revocation function.
33. htmldata: returns or sets a string type to indicate the workbook data in the correct format.
34. htmlurl: return or set the URL of the workbook HTML data file.
35. International: the current country/region and international settings are returned. Variant Type, read-only.
36. languagesettings: returns an owclanguagesettings object that contains language settings.
37. majorversion: The primary version of the returned object, read-only.
38. maxheight: return or set the maximum height that a worksheet can reach when the autofit attribute value is true. Pixel representation can also be expressed as a percentage. Variant Type.
39. maxwidth: return or set the maximum width that can be reached when the autofit attribute value is true.
40. minorversion: the secondary version of the returned object, which belongs to the string type and is read-only.
41. moveafterreturn: determines whether the active cell is moved after the user presses enter. The default value is true. Use the moveafterreturndirection attribute to determine the direction of movement.
42. moveafterreturndirection: return or set the direction of Focus movement when the current user presses enter and the moveafterreturn attribute is set to true. Xldirection type.
43. Name: return or set the name of the specified object.
44. Names: when applied to spreadsheet and workbook objects, the names set indicating all names in the active workbook is returned, which is read-only. When it is applied to a worksheet object, a set of names indicating all worksheet-level names defined in the specified worksheet is returned. Read-only.
45. Range: return a range object, indicating the cell or rectangular cell area.
46. revisionnumber: return the revision number.
47. righttoleft: returns true if right-to-left language support is enabled.
48. Rows: returns a range object that represents all rows in the specified region. Applies to the spreadsheet object and returns a range object that represents all rows in the active worksheet. Applies to the worksheet object and returns a range object that represents all rows on the specified worksheet.
49. screenupdating: returns true if the screen update is on. Read/write.
50. Selection: returns a range object, indicating the selected cells.
51. sheets: Apply to the spreadsheet object and return the sheets set that represents all worksheets in the active workbook. Apply to Workbook. The returned result indicates the sheets set of all workbooks in the specified workbook.
52. titlebar: return the titlebar object that represents the specified workbook title.
53. toolbar: return a mscomctllib. toolbar object, indicating the toolbar.
54. Value: return the name or value of the specified object.
55. Version: Return version, which belongs to the string type.
56. viewonlymode: returns true if it is in read-only mode.
57. Windows: A Windows collection is returned, indicating that the window in the workbook is opened.
58. workbooks: return a workbooks set that indicates opening a workbook.
59. worksheets: return a worksheets set to open a worksheet in the workbook.
60. xmldata: return or set the XML data of the specified component. String type, which can be read and written.
61. xmlurl: return or set a string type to indicate the URL of the Extensible Markup Language (XML) file.

*************
Method
*************
1. addin: add an add-on to the specified workbook.
2. beginundo: Specifies the start of block revocation. This means that all statements from this call to the corresponding endundo method call can be revoked in one call to the Undo method. In this way, the entire macro can be combined into a statement to facilitate revocation. Undo blocks can be nested.
3. Calculate: calculates the opened workbook, the specified worksheet in the workbook, or the specified cell area on the worksheet.
4. calculatefull: the formula on the forcibly opened Workbook is recalculated.
5. endundo: Specify the end of The undo block. This means that all statements from this call to the corresponding beginundo method call can be revoked in one call to the Undo method. In this way, the entire macro can be combined into a statement to facilitate revocation. Undo blocks can be nested.
6. Evaluate: calculates the expression in text format and returns the result.
7. Export: Export spreadsheet to a file
8. fireparameterout: This method can be used to trigger the parametersoutready event.
9. rectintersect: return the range object that represents the intersection of rectangles between the specified regions.
10. rectunion: returns a range object, indicating the smallest cell area in the specified area union.
11. Refresh: refresh the specified object.
12. repaint: forcibly redraw the specified object.
13. showabout: the "about" dialog box is displayed.
14. showcontextmenu: display the custom context menu at the specified screen coordinate.
15. showHelp: displays the primary help topic of the PivotTable or Spreadsheet control.
16. Undo: undo the macro block between the last operation or the last beginundo and endundo method call.
17. updatepropertytoolbax: update the "commands and options" window with the selected object.

From: http://www.6excel.com/doc/20027

*****************
Event
****************
1. beforecontextmenu: occurs before the context menu is displayed. You can right-click or press the application key to display the context menu.
2. beforekeydown: occurs after the user presses the key on the keyboard and before the control presses the key. If you press and hold the key, the event repeats based on the key-click interval set on your computer.
3. beforekeypress: After the user presses and releases the key on the keyboard, it occurs before the control processes the key. If you press and hold the key, the event repeats based on the key-click interval set on your computer.
4. beforekeyup: occurs after the user releases a key on the keyboard and before the control processes the key.
5. bindingadded: It occurs when you use the edit query command to add or modify an existing xmldatabinding object.
6. bindingcompleted: The data is successfully loaded to the ing or exported from the ing through refresh or update.
7. bindingdeleted: occurs when the new xmldatabinding object is deleted.
8. bindingerror: an error is received from the data source because the refresh or update method is called.
9. bindingupdated: occurs when the bindingdata attribute of the existing xmldatabinding object is changed.
10. CLICK: It occurs when the user clicks the specified control.
11. commandbeforeexecute: occurs before the command is executed. If you want to specify the limit before executing the command, use this event.
12. commandchecked: occurs when the Microsoft Office Web component is specified to determine whether the command is selected.
13. commandenabled: It occurs when the specified Microsoft Office Web component command is enabled.
14. commandexecute: occurs after the command is executed. If you want to execute a series of commands after executing a specific command, use this event.
15. commandtiptext: It occurs when the screen prompt Text of the Microsoft Office Web component query command is specified.
16. dblclick: It occurs when you double-click a specified control.
17. endedit: It occurs when the user switches from edit mode to the specified Spreadsheet control or pivot table list. You can use this event to verify the validity of data items in the detail area of the worksheet or PivotTable list.
18. initialize: occurs before the spreadsheet component is loaded and loaded.
19. keydown: occurs after the user presses the key on the keyboard. If you press and hold the key, the event repeats based on the key-click interval set on your computer.
20. keypress: It occurs when the user presses and releases the key on the keyboard.
21. keyup: occurs after the user releases the key on the keyboard.
22. loadcompleted: This occurs after the spreadsheet component is loaded.
23. mousedown: When you press the mouse button on a workbook, PivotTable list, or chart workspace.
24. mouseout: This occurs when you move the mouse pointer out of the cell on the workbook.
25. Mouseover: This occurs when you move the mouse pointer to a cell on the specified workbook.
26. mouseup: the mouse button is released when the pointer is in a workbook, PivotTable list, or chart workspace.
27. mousewheel: This occurs when you rotate the pulley on a mouse device with a pulley.
28. parametersoutready: This parametersoutready event occurs when a set of parameters are transmitted from the Web component that implements the iparametersoutprovider interface to the workbook Web component that implements the iparametersoutconsumer interface.
29. When rowready loads the listobject object to the workbook component, selects a single row in the listobject object and calls the refresh method of the xmldatabinding object, whether the method is successful or not, will call the rowready event process of this component.
30. selectionchange: It occurs when a user makes a new selection. You cannot cancel this event.
31. selectionchanging occurs when you move the mouse pointer in the selected area. This event does not occur when the user selects the keyboard. You cannot cancel this event.
32. sheetactivate occurs when a worksheet is activated.
33. sheetcalculate occurs after the worksheet is calculated.
34. sheetchange occurs when the user or external link changes the cells in any worksheet.
35. When the sheetdeactivate user changes the worksheet, this event is called before the sheetactivate event.
36. sheetfollowhyperlink occurs when you click the hyperlink.
37. startedit: It occurs when the user enters the editing mode in the cell where the pointer is located.
38. viewchange: occurs when the workbook is repainted.

 

Workbook control spreadsheet object method event details