import pandas as pd

from database import get_all_users


def export_excel():

    rows = get_all_users()

    columns = [
        "id",
        "telegram_id",
        "username",
        "first_name",
        "created_at",
        "group_name",
        "q1",
        "q2",
        "q3",
        "q4",
        "q5",
        "q6",
        "q7",
        "q8",
        "q9",
        "q10"
    ]

    df = pd.DataFrame(
        rows,
        columns=columns
    )

    file_name = "users.xlsx"

    df.to_excel(
        file_name,
        index=False
    )

    return file_name