LibreOffice-Forum

Code: Alles auswählen

import csv
from tkinter import filedialog 


def import_csv():
    root = filedialog.Tk()
    root.withdraw()
    filter = (("csv","*.csv"),)
    filename = filedialog.askopenfilename(
        initialdir="C:/Users/Stefan/Downloads",
        filetypes= filter,    
    )
    print(filename)
    with open(filename) as f:
        reader = csv.reader(f, delimiter = ';')
        i = 0
        werte = [""]
        for row in reader:
            if row[0] != '':
                werte[0] = [row[0],row[14]]
            i += 1

if __name__ == "__main__":
    import_csv()

Code: Alles auswählen

import uno, csv

createUnoService = XSCRIPTCONTEXT.ctx.ServiceManager.createInstance

def get_csv_file(*_):
    oFP = createUnoService("com.sun.star.ui.dialogs.FilePicker")
    oFP.appendFilter("Text_csv", "*.csv")
    if oFP.execute():
        return uno.fileUrlToSystemPath( oFP.Files[0] )

def main():
    csv_file = get_csv_file()
    if csv_file:
        with open(csv_file) as file:
            reader = csv.reader( file, dialect=csv.excel) #fix me
            for row in reader:
                print(row)

Code: Alles auswählen

def main():
    csv_file = get_csv_file()
    out = []
    if csv_file:
        with open(csv_file) as file:
            reader = csv.reader( file, dialect=csv.excel) #fix me
            for row in reader:
                if row[0].strip():
                    out.append((row[1], row[14]))
    doc = XSCRIPTCONTEXT.getDocument()
    sheet = doc.Sheets["Tabelle1"]
    sheet[:len(out),:2].DataArray = out

Code: Alles auswählen

def main():
    csv_file = get_csv_file()
    out = []
    if csv_file:
        with open(csv_file) as file:
            reader = csv.reader( file, delimiter = ';') #fix me
            for row in reader:
                if row[0] != "":
                    out.append([row[0], row[14]])
    
    doc = XSCRIPTCONTEXT.getDocument()
    sheet = doc.Sheets["Tabelle1"]
    sheet[:len(out),:2].DataArray = out

Code: Alles auswählen

sheet[:len(out),:2].DataArray = out

Code: Alles auswählen

def main():
    csv_file = get_csv_file()
    if csv_file:
        with open(csv_file) as file:
            reader = csv.reader( file, delimiter = ';') #fix me
            out = [(row[1], row[14]) for row in reader if row[0] != "" ]
    doc = XSCRIPTCONTEXT.getDocument()
    sheet = doc.Sheets["Tabelle1"]
    sheet[:len(out),:2].DataArray = out