LibreOffice-Forum

Code: Alles auswählen

def filter_C_to_sheetname(*_):
    doc = XSCRIPTCONTEXT.getDocument()
    sheets = doc.Sheets
    sourcesheet = sheets["Tabelle1"] #Tabellennamen anpassen
    cursor = sourcesheet.createCursor()
    cursor.gotoStartOfUsedArea(False)
    cursor.gotoEndOfUsedArea(True)
    source = cursor.DataArray
    criteria = sorted({row[2] for row in source}) # [2]→Spalte_C
    for name in criteria:
        sheetname = f"Altersklasse_{name}"
        try:
            sheets.insertNewByName(sheetname, sheets.Count)
        except:
            pass        
        out = [row for row in source if row[2]==name] # [2]→Spalte_C
        sheets[sheetname][0:len(out),0:len(out[0])].DataArray = out