VbaModuleCollection
VbaModuleCollection class
Represents the list of VbaModule
Properties
| Name | Type | Description |
|---|---|---|
| Count | Number | |
| Item (int) | VbaModule | Gets VbaModule in the list by the index. |
| Item (java.lang.String) | VbaModule | Gets VbaModule in the list by the name. |
Methods
| Name | Description |
|---|---|
| addDesignerStorage | |
| getDesignerStorage | Represents the data of Designer. |
We do not support to parse them. Just only for copying. | | add | Adds module for a worksheet. | | addUserForm | Inser user form into VBA Project. | | remove | Removes module for a worksheet. | | clear | | | removeAt | | | iterator | | | get | Reserved for internal use. | | contains | Reserved for internal use. | | indexOf | Reserved for internal use. |
VbaModuleCollection.Count property
Type: Number
VbaModuleCollection.Item (int) property
Gets VbaModule in the list by the index.
Type: VbaModule
VbaModuleCollection.Item (java.lang.String) property
Gets VbaModule in the list by the name.
Type: VbaModule
addDesignerStorage(name, data)
| Parameter | Type | Description |
|---|---|---|
| name | String | |
| data | byte[] |
getDesignerStorage(name)
Represents the data of Designer.
We do not support to parse them. Just only for copying.
add(sheet) (1 of 3)
Adds module for a worksheet.
| Parameter | Type | Description |
|---|---|---|
| sheet | Worksheet | The worksheet |
add(type, name) (2 of 3)
Adds module.
| Parameter | Type | Description |
|---|---|---|
| type | Number | A VbaModuleType value. The type of module. |
| name | String | The name of module. |
add(value) (3 of 3)
Reserved for internal use.
addUserForm(name, codes, designerStorage)
Inser user form into VBA Project.
| Parameter | Type | Description |
|---|---|---|
| name | String | The name of user form |
| codes | String | The codes for the user form |
| designerStorage | byte[] | the designer setting about the user form |
remove(sheet) (1 of 2)
Removes module for a worksheet.
| Parameter | Type | Description |
|---|---|---|
| sheet | Worksheet | The worksheet |
remove(name) (2 of 2)
Remove the module by the name
| Parameter | Type | Description |
|---|---|---|
| name | String |
clear()
removeAt(index)
iterator()
get(index)
Reserved for internal use.
contains(value)
Reserved for internal use.
indexOf(value)
Reserved for internal use.