Removing a sheet in Spread COM

Posted by: abrahampetit on 29 April 2021, 1:54 am EST

    • Post Options:
    • Link

    Posted 29 April 2021, 1:54 am EST


    I want to remove the first sheet of a COM Spread. I have found this code on your forums:


    However seems that it does not apply to the Active X version, because the “.Sheets” property does not exist.

    I only see:

    .Sheet, .SheetCount, .SheetName, .SheetVisible, and .ActiveSheet

    But nothing about “.Sheets”

    How can I remove a sheet on a 8.029 com spread???


  • Posted 26 May 2021, 8:28 pm EST


    Apologies for the delayed response first of all. Spread COM has a deleteSheets method for removing sheets from the Spread COM.

    fpSpread1.DeleteSheets(ByVal SheetIndex As Integer, ByVal SheetCnt As Integer) As Boolean

    Here is the documentation link for the same:-

    Hope it helps.



Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels