Das deutsche Python-Forum

Code: Alles auswählen

import csv
	reder = csv.reader(open("Test_OR.xls","rb"), delimiter='\t')
	for row in reder:
		print row

Code: Alles auswählen

import csv
import sys
from os import *

# Datei �ffnen und einen csv-reader initialisieren
source = file("test.xls", "rb")
reader = csv.DictReader(source, delimiter='\t')

# csv-writer initialisieren und die Kopfzeile schreiben
targetHandle = file("test_output.xls", "wb")
writer = csv.DictWriter(target,["NAME", "FIRSTNAME", "NICKNAME"], delimiter='\t')
writer.writecol({"NAME" : "NAME", "FIRSTNAME" : "FIRSTNAME", "NICKNAME" : "NICKNAME"})
                
for col in reader:

    # Zugriff auf die Felder der jeweiligen Zeilen
    name = col['NAME']
    firstname = col['FIRSTNAME']
    nickname = col['NICKNAME']

    # Tausche Namen und Vornamen und entferne Leerzeichen
    data = {
        'NAME': firstname.replace(' ', ''),
        'FIRSTNAME': name.replace(' ', ''),
        'NICKNAME': nickname.replace(' ', '')
    }

    writer.writerow(data)

# Aufr�umen
source.close()
target.close()

exit()

Code: Alles auswählen

writer = csv.DictWriter(target,["NAME", "FIRSTNAME", "NICKNAME"], delimiter='\t')
writer.writecol({"NAME" : "NAME", "FIRSTNAME" : "FIRSTNAME", "NICKNAME" : "NICKNAME"})

Code: Alles auswählen

from __future__ import with_statement
import sys
import os
import csv
import xlwt

def main(file_name):
    with open(file_name, 'rb') as infile:
        csv_reader = csv.DictReader(infile, delimiter='\t')
        base_name = os.path.splitext(file_name)[0]
        with open("%s.xls" % base_name, 'wb') as outfile:
            wb = xlwt.Workbook()
            ws = wb.add_sheet(base_name)
            # Erste Zeile fixieren (nach xlwt Doku)
            ws.set_panes_frozen(True)
            ws.set_horz_split_pos(1)
            ws.set_remove_splits(True)
            for col, category in enumerate(csv_reader.fieldnames):
                ws.write(0, col, category)
            for row, line in enumerate(csv_reader):
                for col, category in enumerate(line):
                    ws.write(row + 1, col, line[csv_reader.fieldnames[col]])
            wb.save(outfile)
                    
if __name__ == '__main__':
    main(sys.argv[-1])