A basic Custom Function, written in Python

CF Python Demo.EXCEL.yaml

name: CF Python Demo
description: 'A basic Custom Function, written in Python'
host: EXCEL
api_set: {}
script:
  content: |-
    import customfunctions as cf

    @cf.customfunction("ADD")
    def myadd(x, y):
      return x + y

    import statistics
    @cf.customfunction("PYSTDEV", 
      parameters=[
        cf.ParameterInfo(dimensionality=cf.Dimensionality.matrix)])
    def pystdev(data):
        flatList = [item for sublist in data for item in sublist]
        return statistics.stdev(flatList)
  language: python