Sheet Custom Property – Remove All Custom Properties from a Sheet

Removes all custom properties from the specified Excel worksheet.

It uses xlWriteSheetCustomProperties to clear all properties

    Public Sub xlClearSheetAllCustomProperties(sheet As Worksheet)

        ' Create an empty DataTable with the expected schema
        Dim emptyTable As New Data.DataTable()
        emptyTable.Columns.Add("Property")
        emptyTable.Columns.Add("Value")

        ' Call the main function with the ReplaceAll flag set to True
        xlWriteSheetCustomProperties(sheet, emptyTable, RemoveAllBeforeWriting:=True)

    End Sub

    Public Sub xlClearSheetAllCustomProperties(sheet As Worksheet)

        ' Create an empty DataTable with the expected schema
        Dim emptyTable As New Data.DataTable()
        emptyTable.Columns.Add("Property")
        emptyTable.Columns.Add("Value")

        ' Call the main function with the ReplaceAll flag set to True
        xlWriteSheetCustomProperties(sheet, emptyTable, RemoveAllBeforeWriting:=True)

    End Sub

Posted by ipercube