| |
|
Camparative Tables for Method Implementation |
|
Below you can see the comparative tables of method implementation in AutomateIT! 0.7 and AutomateIT! 0.9.
IApplication
IWorkbooks
IWorkBook
ISheets
IWorkSheet
IRange
IFont
IInterior
IPageSetup
IBorders
IBorder
Some cells in these tables are marked with – it means that the corresponding method is taken into account but its functionality is not implemented. Thus execution of such method doesn’t cause error but its functionality is not executed either.
IApplication
| Name |
AutomateIT! 0.7 |
AutomateIT! 0.9 |
| Workbooks |
Property/Read |
Property/Read |
| Sheets |
Property/Read |
Property/Read |
| Worksheets |
|
Property/Read |
| Cells |
Property/Read |
Property/Read |
| Version |
Property/Read |
Property/Read |
| ActiveSheet |
Property/Read |
Property/Read |
| ActiveCell |
Property/Read |
Property/Read |
| Application |
|
Property/Read |
| ActiveWorkbook |
Property/Read |
Property/Read |
| Range |
|
Property/Read |
| Columns |
|
Property/Read |
| Rows |
|
Property/Read |
| UserControl |
|
Property/Read-Write |
| DisplayAlerts |
|
Property/Read-Write |
| WindowState |
|
Property/Read-Write |
| Visible |
|
Property/Read-Write |
| EnableEvents |
|
Property/Read-Write |
| ScreenUpdating |
|
Property/Read-Write |
| Caption |
|
Property/Read |
| Selection |
|
Property/Read |
| |
|
|
| ConvertFormula |
Method |
Method |
| Quit |
Method |
Method |
Go to Top
IWorkbooks
| Name |
AutomateIT! 0.7 |
AutomateIT! 0.9 |
| Count |
|
Property/Read |
| Application |
|
Property/Read |
| Parent |
|
Property/Read |
| Creator |
|
Property/Read |
| _Default |
|
Property/Read |
| Item |
|
Property/Read |
| |
|
|
| Add |
Method |
Method |
| _Open |
Method |
Method |
| Open |
Method |
Method |
| Close |
|
Method |
| OpenText |
|
Method |
| _OpenText |
|
Method |
| OpenXML |
|
Method |
| _OpenXML |
|
Method |
| OpenDatabase |
|
Method |
| CheckOut |
|
Method |
| __OpenText |
|
Method |
| CanCheckOut |
|
Method |
Go to Top
IWorkbook
| Name |
AutomateIT! 0.7 |
AutomateIT! 0.9 |
| Sheets |
Property/Read |
Property/Read |
| Worksheets |
Property/Read |
Property/Read |
| ActiveSheet |
|
Property/Read |
| |
|
|
| Close |
Method |
Method |
| SaveAs |
|
Method |
| Save |
|
Method |
| Protect |
|
Method |
| Unprotect |
|
Method |
Go to Top
ISheets
| Name |
AutomateIT! 0.7 |
AutomateIT! 0.9 |
| _Default |
Property/Read |
Property/Read |
| Count |
Property/Read |
Property/Read |
| Application |
|
Property/Read |
| Parent |
|
Property/Read |
| Item |
|
Property/Read |
| Creator |
|
Property/Read |
| |
|
|
| Add |
Method |
Method |
| Select |
|
Method |
Go to Top
IWorksheet
| Name |
AutomateIT! 0.7 |
AutomateIT! 0.9 |
| Name |
Property/Read-Write |
Property/Read-Write |
| Cells |
Property/Read |
Property/Read |
| Range |
Property/Read |
Property/Read |
| Rows |
|
Property/Read |
| Columns |
|
Property/Read |
| PageSetup |
|
Property/Read |
| |
|
|
| Paste |
Method |
Method |
| Activate |
|
Method |
| Copy |
|
Method |
| Delete |
|
Method |
| Protect |
|
Method |
| Unprotect |
|
Method |
| Select |
|
Method |
Go to Top
IRange
| Name |
AutomateIT! 0.7 |
AutomateIT! 0.9 |
| _Default |
Property/Read |
Property/Read-Write |
| ColumnWidth |
Property/Read-Write |
Property/Read-Write |
| Font |
Property/Read |
Property/Read |
| Value |
Property/Read-Write |
Property/Read-Write |
| Columns |
|
Property/Read |
| Column |
Property/Read |
Property/Read |
| Row |
Property/Read |
Property/Read |
| HorizontalAlignment |
|
Property/Read-Write |
| VerticalAlignment |
|
Property/Read-Write |
| WrapText |
|
Property/Read-Write |
| Application |
|
Property/Read |
| Creator |
|
Property/Read |
| Parent |
|
Property/Read |
| Worksheet |
|
Property/Read |
| Interior |
|
Property/Read |
| Borders |
|
Property/Read |
| Count |
|
Property/Read |
| RowHeight |
|
Property/Read-Write |
| NumberFormat |
|
Property/Read-Write |
| NumberFormatLocal |
|
Property/Read-Write |
| Height |
|
Property/Read |
| Width |
|
Property/Read |
| Left |
|
Property/Read |
| Top |
|
Property/Read |
| ShrinkToFit |
|
Property/Read-Write |
| MergeCells |
|
Property/Read-Write |
| Locked |
|
Property/Read-Write |
| Hidden |
|
Property/Read-Write |
| Item |
|
Property/Read-Write |
| Range |
|
Property/Read |
| Rows |
|
Property/Read |
| Text |
|
Property/Read |
| |
|
|
| Select |
Method |
Method |
| ClearContents |
Method |
Method |
| NoteText |
Method |
Method |
| Merge |
|
Method |
| UnMerge |
|
Method |
| Clear |
|
Method |
| ClearComments |
|
Method |
| ClearFormats |
|
Method |
| ClearNotes |
|
Method |
| ClearOutline |
|
Method |
| Delete |
|
Method |
| Copy |
|
Method |
| Insert |
|
Method |
Go to Top
IFont
| Name |
AutomateIT! 0.7 |
AutomateIT! 0.9 |
| Bold |
Property/Read-Write |
Property/Read-Write |
| Italic |
Property/Read-Write |
Property/Read-Write |
| Underline |
Property/Read-Write |
Property/Read-Write |
| Size |
|
Property/Read-Write |
| Strikethrough |
|
Property/Read-Write |
| Name |
|
Property/Read-Write |
| Color |
|
Property/Read-Write |
| ColorIndex |
|
Property/Read-Write |
| Application |
|
Property/Read |
| Parent |
|
Property/Read |
| Creator |
|
Property/Read |
| Shadow |
|
Property/Read-Write |
Go to Top
IInterior
| Name |
AutomateIT! 0.7 |
AutomateIT! 0.9 |
| Color |
|
Property/Read-Write |
| ColorIndex |
|
Property/Read-Write |
| Application |
|
Property/Read |
| Parent |
|
Property/Read |
| Creator |
|
Property/Read |
Go to Top
IPageSetup
| Name |
AutomateIT! 0.7 |
AutomateIT! 0.9 |
| LeftMargin |
|
Property/Read-Write |
| RightMargin |
|
Property/Read-Write |
| TopMargin |
|
Property/Read-Write |
| BottomMargin |
|
Property/Read-Write |
| Orientation |
|
Property/Read-Write |
| Zoom |
|
Property/Read-Write |
| FitToPagesTall |
|
Property/Read-Write |
| FitToPagesWide |
|
Property/Read-Write |
| HeaderMargin |
|
Property/Read-Write |
| FooterMargin |
|
Property/Read-Write |
| CenterHorizontally |
|
Property/Read-Write |
| CenterVertically |
|
Property/Read-Write |
| PrintTitleRows |
|
Property/Read-Write |
| Application |
|
Property/Read |
| Parent |
|
Property/Read |
| Creator |
|
Property/Read |
Go to Top
IBorders
| Name |
AutomateIT! 0.7 |
AutomateIT! 0.9 |
| Application |
|
Property/Read |
| Parent |
|
Property/Read |
| Color |
|
Property/Read-Write |
| ColorIndex |
|
Property/Read-Write |
| Creator |
|
Property/Read |
| LineStyle |
|
Property/Read-Write |
| Weight |
|
Property/Read-Write |
| _Default |
|
Property/Read |
| Item |
|
Property/Read |
| Value |
|
Property/Read-Write |
Go to Top
IBorder
| Name |
AutomateIT! 0.7 |
AutomateIT! 0.9 |
| Application |
|
Property/Read |
| Parent |
|
Property/Read |
| Color |
|
Property/Read-Write |
| ColorIndex |
|
Property/Read-Write |
| Creator |
|
Property/Read |
| LineStyle |
|
Property/Read-Write |
| Weight |
|
Property/Read-Write |
Go to Top
|
|
|
| |
|
|
Download Booklet|Process| Portfolio | Privacy Policy| Contact Us | Site Map | |
|