Removing a sheet in Spread COM

Removing a sheet in Spread COM

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

• 

  abrahampetit

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 29 April 2021, 10: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!

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 27 May 2021, 5:28 am 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