import pandas as pd
import numpy as np
import sqlalchemy as sq


desired_width = 320
pd.set_option("display.width", desired_width)
np.set_printoptions(linewidth=desired_width)
pd.set_option('display.max_columns', 15)
df = pd.read_excel("KE30.xlsx", 0, usecols='A:P')

database_username = 'sa'
database_password = 'xxxx'
database_ip = 'localhost'
database_name = 'test'
database_connection = sq.create_engine('mysql+mysqlconnector://{0}:{1}@{2}/{3}'.
                                       format(database_username, database_password,
                                              database_ip, database_name))
df.to_sql(con=database_connection, name='table_name_for_df', if_exists='replace')