from django.shortcuts import render

from django.http import HttpResponse

import pandas as pd

from antproject.settings import BASE_DIR

# Create your views here.

def hello(request):

    return  HttpResponse("hello django,hhahhe")

def read_excel(request):

    pf = pd.read_excel(BASE_DIR / "datas/数据-学生成绩表.xlsx")

    cont = """

        <table>

            <th>学号</th>

            <th>姓名</th>

            <th>语文</th>

            <th>数学</th>

            <th>英语</th>

    """

    for idx , row in pf.iterrows():

        cont +=f"""

           <tr>

                <td>{row.学号}</td>

                <td>{row.姓名}</td>

                <td>{row.语文}</td>

                <td>{row.数学}</td>

                <td>{row.英语}</td>

           </tr>

        """

    cont +="""

        </table>

    """

    return HttpResponse(cont)