Removing a sheet in Spread COM

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

  • Posted 29 April 2021, 1:54 am EST

    Hi,

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

    fprspread1.sheets.remove(fpspread1.sheets(1)),

    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???

    Thanks!





  • Marked as Answer

    Replied 26 May 2021, 8:28 pm EST

    Hello,

    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:-
    https://help.grapecity.com/spread/Spread8/WebSiteHelp/webframe.html#sheets6.html

    Hope it helps.

    Thanks,
    Reeva
Need extra support?

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

Learn More

Forum Channels