Methods

add(sheet) → Number

Adds module for a worksheet.

Parameter

Name Type Optional Description

sheet

Worksheet

 

The worksheet

Returns

Number 

add(type, name) → Number

Adds module.

Parameters

Name Type Optional Description

type

Number

 

VbaModuleType

name

String

 

The name of module.

Returns

Number 

add()

Reserved for internal use.

addDesignerStorage(name, data)

Parameters

Name Type Optional Description

name

String

 

data

Array of byte

 

addUserForm(name, codes, designerStorage) → Number

Inser user form into VBA Project.

Parameters

Name Type Optional Description

name

String

 

The name of user form

codes

String

 

The codes for the user form

designerStorage

Array of byte

 

the designer setting about the user form

Returns

Number 

clear()

contains()

Reserved for internal use.

get(index) → VbaModule

Gets VbaModule in the list by the index.

Parameter

Name Type Optional Description

index

Number

 

The index.

Returns

VbaModule 

get(name) → VbaModule

Gets VbaModule in the list by the name.

Parameter

Name Type Optional Description

name

String

 

The name of module.

Returns

VbaModule 

get()

Reserved for internal use.

getCount()

getDesignerStorage()

Represents the data of Designer. We do not support to parse them. Just only for copying.

indexOf()

Reserved for internal use.

iterator()

remove(sheet) → void

Removes module for a worksheet.

Parameter

Name Type Optional Description

sheet

Worksheet

 

The worksheet

Returns

void 

remove(name)

Remove the module by the name

Parameter

Name Type Optional Description

name

String

 

removeAt()