ich habe nach dem Tipp von Sirius folgenden Fehler:
[Codebox=python file=Unbenannt.py]
*** ERROR Unexpected data at end of OBJECT record
0: 00 00 00 00 ff ff ff ff ff ff ff ff ff ff ff ff ~~~~????????????
16: ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ????????????????
32: ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ????????????????
48: ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ????????????????
64: ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ????????????????
80: ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ????????????????
96: ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ????????????????
112: ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ????????????????
128: ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ????????????????
144: ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ????????????????
160: ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ????????????????
176: ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ????????????????
192: ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ????????????????
208: ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ????????????????
224: ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ????????????????
240: ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ????????????????
256: ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ????????????????
272: ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ????????????????
288: ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ????????????????
304: ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ????????????????
320: ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ????????????????
336: ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ????????????????
352: ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ????????????????
368: ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ????????????????
384: ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ????????????????
400: ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ????????????????
416: ff ff ff ff ????
Traceback (most recent call last):
File "DBschreiben.py", line 11, in <module>
daten = xlrd.open_workbook('/home/pi/EmailAnhang/Pruefergebnis.xls',formatting_info=True)
File "/usr/lib/python2.7/dist-packages/xlrd/__init__.py", line 435, in open_workbook
ragged_rows=ragged_rows,
File "/usr/lib/python2.7/dist-packages/xlrd/book.py", line 119, in open_workbook_xls
bk.get_sheets()
File "/usr/lib/python2.7/dist-packages/xlrd/book.py", line 705, in get_sheets
self.get_sheet(sheetno)
File "/usr/lib/python2.7/dist-packages/xlrd/book.py", line 696, in get_sheet
sh.read(self)
File "/usr/lib/python2.7/dist-packages/xlrd/sheet.py", line 1076, in read
saved_obj = self.handle_obj(data)
File "/usr/lib/python2.7/dist-packages/xlrd/sheet.py", line 1890, in handle_obj
raise XLRDError(msg)
xlrd.biffh.XLRDError: Unexpected data at end of OBJECT record
[/Codebox]
Mein Code sieht wie folgt aus:
Code: Alles auswählen
#!/usr/bin/env python
# -*- coding: utf8 -*-
import xlrd
import datetime
import MySQLdb
_encoding = 'utf-8'
mysql = MySQLdb.connect(host='localhost', user='zy', passwd='xy', db='testdb')
cursor = mysql.cursor()
daten = xlrd.open_workbook('Pruefergebnis.xls',formatting_info=True)
query = """Insert Into orders (seriennummer, klassifikation, region, sc, betirebsart, hnr, liegenschaft, gebaeude, etage, raum, verantwortlicher, eib, letzepruefung, naechstepruefung) VALUES (%s, %$
sheet = daten.sheet_by_index(0)
for row in range (sheet.nrows):
cursor.execute("UPDATE testdb set letztepruefung = :sheet.cell(row,8), 0), naechstepruefung = DATE_ADD(:sheet.cell(row,8), 0), Interval 2 Years) WHERE seriennummer =:sheet.cell(row,4), 0) a$
cursor.close()
mysql.comit()
mysql.close()