Read row by row + write yml-file

[kA_4Gqo52C5]

Have a Calc file here that I would like to read row by row, add markups depending on the values of the cells and write to a YAML file.

fictitious example:

KNX	device generic	1.2.3
KNX	switch	demoSwitch	light	3/0/4+<3/0/5
KNX	contact	demoContact	door	1.019:<5/1/2

    Thing device generic [
        address="1.2.3"
    ] {
        Type switch : demoSwitch "Light" [ ga="3/0/4+<3/0/5" ]
        Type contact : demoContact "Door" [ ga="1.019:<5/1/2" ]
    }
}

Operating system is primarily Linux(Manjaro), but it would be desirable if this would work on Windows as well.

Background: Have my Smarthome things(KNX, OneWire…) maintained in an Excel file and would like to migrate to openHAB. Therefore a yml readable by openHAB with all bindings, things, channels, items and rules should be generated from the table.

[Villeroy]

Python snippet:

doc = XSCRIPTCONTEXT.getDocument()
# Get current region around A1 on the first sheet
oCell = doc.Sheets.getByIndex(0).getCellByPosition(0,0)
oCursor = oRange.getSpreadsheet().createCursorByRange(oCell)
oCursor.collapseToCurrentRegion()
data = oCursor.getDataArray()

data is a nested array containing all the numbers and strings.