Apr-11-2022, 06:03 PM
I need to create some reports in excel using Python from a MSSQL server query. I do get a file in excel format that has the data I ask for but I also get an error and I am trying to work through it.
import pyodbc
import xlsxwriter
import pandas as pd
from os import environ, lseek
CONNECTION_STRING="""Driver=/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.9.so.1.1;
Server=server;
Database=mydata;
UID=youknow;
PWD=password;"""
connection = pyodbc.connect(CONNECTION_STRING)
with pd.ExcelWriter("Output.xlsx", engine="xlsxwriter", options = {'strings_to_numbers': True, 'strings_to_formulas': False}) as writer:
try:
df = pd.read_sql_query("select top 100 * from salesorders where ompclosed!=-1",connection)
df.to_excel(writer,sheet_name="Sheet1", header=True , index =False)
print("File saved successfully")
except:
print("There is an error")I get this error messageError:FutureWarning: Use of **kwargs is deprecated, use engine_kwargs instead.
with pd.ExcelWriter("Output.xlsx", engine="xlsxwriter", options = {'strings_to_numbers': True, 'strings_to_formulas': False}) as writer:
/usr/local/lib/python3.8/dist-packages/pandas/io/sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy