Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import xlrd
- import mysql.connector
- import datetime
- name= "Anand1989.xls"
- book=xlrd.open_workbook(name)
- worksheet = book.sheet_by_index(0)
- database = mysql.connector.connect (host="localhost", user = "root", passwd = "", db = "rainfall")
- cursor = database.cursor()
- query = """INSERT INTO Anand1989(DATE) VALUES (%s)"""
- for r in range(1, worksheet.nrows):
- DATE = worksheet.cell(r,0).value
- date_time_obj = datetime.datetime.strptime(str(DATE), '%Y-%m-%d').date
- values = (date_time_obj)
- cursor.execute(query, values)
- cursor.close()
- database.commit()
- database.close()
- print ("All Done! Bye, for now.")
- Traceback (most recent call last):
- File "newins.py", line 46, in <module> date_time_obj = datetime.datetime.strptime(str(DATE), '%Y-%m-%d').date
- File "C:UsersstudentAppDataLocalProgramsPythonPython37-32lib_strptime.py", line 577, in _strptime_datetimet tt, fraction,gmtoff_fraction = _strptime(data_string, format)
- File "C:UsersstudentAppDataLocalProgramsPythonPython37-32lib_strptime.py", line 359, in _strptime (data_string, format)) ValueError: time data '32509.0' does not match format '%Y-%m-%d'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement