Advertisement
Guest User

Untitled

a guest
Mar 5th, 2018
116
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.46 KB | None | 0 0
  1. import pymssql
  2. import pandas as pd
  3.  
  4. server = 'ip'
  5. username = 'user'
  6. password = 'password'
  7.  
  8. cnxn = pymssql.connect(server, username, password, "tempdb")
  9. cursor = cnxn.cursor()
  10. cursor.execute("SELECT INFO, INFO2, \"GRUPO INFO\" FROM \"INFO3\".\"database\".\"subdatabase\";")
  11. row = cursor.fetchone()
  12.  
  13. df = pd.DataFrame(columns=['A', 'B'])
  14. writer = pd.ExcelWriter(
  15.     'prueba.xlsx', engine='xlsxwriter')
  16. df.to_excel(writer, sheet_name='Sheet1')
  17. writer.save()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement