How to convert xlsx file to DataFrame or save it directly when uploaded by Django

Most people do not understand the knowledge points of this article "how to upload xlsx files on Django directly into DataFrame or save directly", so the editor summarizes the following contents, detailed contents, clear steps, and has a certain reference value. I hope you can get something after reading this article. Let's take a look at this article, "how to directly convert Django uploaded xlsx files into DataFrame or save directly" article.

Urls.py

From django.urls import pathfrom. Import views# adds a namespace to the URL name app_name = 'report'urlpatterns = [# upload report path (' / upload_report/', views.upload_report, name='upload_report'),] view.py

Def handle_uploaded_file (file, path): "" Save uploaded file: param file: uploaded file: param path: storage path (including file name): return: "with open (path) 'wb+') as destination: # divide the file into parts for chunk in file.chunks (): # write file destination.write (chunk) def upload_report (request): "upload report: param request:: return:" # get the file file = request.FILES.get (' file') # report storage path path = 'reports/' + file.name # 1. Convert directly to DataFrame file_df = pandas.read_excel (file) # data processing # DataFrame and save to xlsx file_df.to_excel (path, index=False, header=None, float_format='%.2f') # 2. Directly save the uploaded file handle_uploaded_file (request.FILES ['file'], path) return JsonResponse ({' reports': 1}) the above is about "how to directly convert Django uploaded xlsx file to DataFrame or save directly". I believe you all have some understanding. I hope the content shared by the editor will be helpful to you. If you want to know more about the relevant knowledge, please follow the industry information channel.