mysql not enough arguments_not enough arguments for format string from excel to mysql

I notice 2 things that could cause this error:

Your variable values is a tuple already, so you dont need to wrap it inside a new list.

That means, change this line mycursor.execute(query, [values])

to mycursor.execute(query, values)

You are also missing a comma in your query in the part where you list the target column names, between penalty_way and penalty.

In case of this many arguments, I would suggest to restructure your code so that you can more easily see if you missed anything.

For example, here is a version that groups the 15 parameters in a 1-3-3-3-3-2 formation in 3 parts: the first part of the query, the second part of the query and also when building the values tuple.

query = """

INSERT INTO sanction (

id,

organization_type, organization, date,

decision_number, penalty_type, penalty_way,

penalty, violation, execution_period,

article, note, type_npa,

department, uploaded_date)

VALUES (

null,

%s, %s, %s,

%s, %s, %s,

%s, %s, %s,

%s, %s, %s,

%s, %s)

"""

for r in range(1, sheet.nrows):

organization_type = sheet.cell(r, 1).value

organization = sheet.cell(r, 2).value

date = sheet.cell(r, 3).value

decision_number = sheet.cell(r, 4).value

penalty_type = sheet.cell(r, 5).value

penalty_way = sheet.cell(r, 6).value

penalty = sheet.cell(r, 7).value

violation = sheet.cell(r, 8).value

execution_period = sheet.cell(r, 9).value

article = sheet.cell(r, 10).value

note = sheet.cell(r, 11).value

type_npa = sheet.cell(r, 12).value

department = sheet.cell(r, 13).value

uploaded_date = datetime.now().strftime("%Y-%m-%d %H:%M")

values = (

# the first value of the INSERT statement will be NULL

organization_type, organization, date, # 3 elements

decision_number, penalty_type, penalty_way, # 3 elements

penalty, violation, execution_period, # 3 elements

article, note, type_npa, # 3 elements

department, uploaded_date, # 2 elements

)

mycursor.execute(query, values)