aspose.cells

Class VbaModuleCollection

Represents the list of VbaModule

Property Getters/Setters Summary
functiongetCount()
functionget(index)
Gets VbaModule in the list by the index.
functionget(name)
Gets VbaModule in the list by the name.
 
Method Summary
functionadd(sheet)
Adds module for a worksheet.
functionadd(type, name)
Adds module.
functionadd(value)
Reserved for internal use.
functionaddDesignerStorage(name, data)
functionaddUserForm(name, codes, designerStorage)
Inser user form into VBA Project.
functionclear()
functioncontains(value)
Reserved for internal use.
functionget(index)
Reserved for internal use.
functiongetDesignerStorage(name)
Represents the data of Designer.
functionindexOf(value)
Reserved for internal use.
functioniterator()
functionremove(sheet)
Removes module for a worksheet.
functionremove(name)
Remove the module by the name
functionremoveAt(index)
 

    • Property Getters/Setters Detail

      • getCount : Number 

        function getCount()
        
      • get : VbaModule 

        function get(index)
        
        Gets VbaModule in the list by the index.
        Parameters:
        index - The index.
        Returns:
      • get : VbaModule 

        function get(name)
        
        Gets VbaModule in the list by the name.
        Parameters:
        name - The name of module.
        Returns:
    • Method Detail

      • addDesignerStorage

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

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

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

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

        function 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

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

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

        function clear()
      • removeAt

        function removeAt(index)
      • iterator

        function iterator()
      • get

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

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

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

        function indexOf(value)
        Reserved for internal use.