asposecells.api

Class VbaModuleCollection

Represents the list of VbaModule

Property Getters/Setters Summary
methodgetCount()
methodget(index)
Gets VbaModule in the list by the index.
methodget(name)
Gets VbaModule in the list by the name.
 
Method Summary
methodadd(sheet)
Adds module for a worksheet.
methodadd(type, name)
Adds module.
methodadd(value)
Reserved for internal use.
methodaddDesignerStorage(name, data)
methodaddUserForm(name, codes, designerStorage)
Inser user form into VBA Project.
methodclear()
methodcontains(value)
Reserved for internal use.
methodget(index)
Reserved for internal use.
methodgetDesignerStorage(name)
Represents the data of Designer.
methodindexOf(value)
Reserved for internal use.
methoditerator()
methodremove(sheet)
Removes module for a worksheet.
methodremove(name)
Remove the module by the name
methodremoveAt(index)
 

    • Property Getters/Setters Detail

      • getCount : int 

        int getCount()
        
    • Method Detail

      • addDesignerStorage

         addDesignerStorage(name, data)
        Parameters:
        name: String -
        data: byte[] -
      • getDesignerStorage

        byte[] getDesignerStorage(name)
        Represents the data of Designer. We do not support to parse them. Just only for copying.
      • add

        int add(sheet)
        Adds module for a worksheet.
        Parameters:
        sheet: Worksheet - The worksheet
        Returns:
      • add

        int add(type, name)
        Adds module.
        Parameters:
        type: int - A VbaModuleType value. The type of module.
        name: String - The name of module.
        Returns:
      • addUserForm

        int addUserForm(name, codes, designerStorage)
        Inser user form into VBA Project.
        Parameters:
        name: String - The name of user form
        codes: String - The codes for the user form
        designerStorage: byte[] - the designer setting about the user form
        Returns:
      • remove

         remove(sheet)
        Removes module for a worksheet.
        Parameters:
        sheet: Worksheet - The worksheet
        Returns:
      • remove

         remove(name)
        Remove the module by the name
        Parameters:
        name: String -
      • clear

         clear()
      • removeAt

         removeAt(index)
      • iterator

        Iterator iterator()
      • get

        Object get(index)
        Reserved for internal use.
      • contains

        boolean contains(value)
        Reserved for internal use.
      • add

        int add(value)
        Reserved for internal use.
      • indexOf

        int indexOf(value)
        Reserved for internal use.