Guest User

Untitled

a guest
Mar 6th, 2018
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.25 KB | None | 0 0
  1. columns = [desc[0] for desc in cursor.description]
  2. data = cursor.fetchall()
  3. df = pd.DataFrame(list(data), columns=columns)
  4.  
  5. writer = pd.ExcelWriter(
  6.     'pruebamartes.xlsx', engine='xlsxwriter')
  7. df.to_excel(writer, sheet_name='Sheet1')
  8. writer.save()
Advertisement
Add Comment
Please, Sign In to add comment