【无标题】2020829

import json
import pandas as pd
from django.http import JsonResponse
from django.views.decorators.csrf import csrf_exempt
from django.shortcuts import render

def index(request):
return render(request, ‘index.html’)

@csrf_exempt
def process_data(request):
if request.method == ‘POST’:
json_data = json.loads(request.POST.get(‘json_data’))
excel_file = request.FILES.get(‘excel_file’)

    df = pd.read_excel(excel_file)
    results = {}

    for key, value in json_data.items():
        excel_value = df[df['Key'] == key]['Value'].values
        if len(excel_value) == 0:
            results[key] = '没有找到此key值'
        elif excel_value[0] != value:
            results[key] = str(excel_value[0])

    return JsonResponse({'results': results})

return JsonResponse({'error': 'Invalid request'}, status=400)

from django.urls import path
from . import views

urlpatterns = [
path(‘’, views.index, name=‘index’),
path(‘process/’, views.process_data, name=‘process_data’),
]

from django.contrib import admin
from django.urls import include, path

urlpatterns = [
path(‘admin/’, admin.site.urls),
path(‘’, include(‘myapp.urls’)),
]

JSON Data:
Excel File:
开始
Results:

<script>
    function submitData() {
        var formData = new FormData(document.getElementById('dataForm'));
        fetch('/process/', {
            method: 'POST',
            body: formData
        }).then(response => response.json()).then(data => {
            document.getElementById('results').value = JSON.stringify(data.results, null, 2);
        });
    }
</script>