How to read xlsx file uploaded in django?

Question

I have a django server which allow user to upload xlsx files, I want to access the data in it.

I know about openpyxl, however, it looks like it doesn't have a way to parse opened files, I do not want to save the file on disk and read it again.

How can I do it?

You'll have to write your own code to pass the zip archive into openpyxl. Much better to save it somewhere. — Charlie Clark, May 15 '16 at 14:55

Ricardo · Answer 1 · 2020-04-14T22:32:46.060

9

Actually, it's simpler than above:

    from openpyxl import load_workbook
    ...
    if request.method == 'POST':
        form = UploadForm(request.POST, request.FILES)
        if form.is_valid():
            wb = load_workbook(filename=request.FILES['file'].file)

The file attribute of FILES['file'] already returns a BytesIO instance ;)

edited Apr 14 '20 at 22:32

answered Apr 14 '20 at 21:57

Ricardo

618
9
11

score 6 · Answer 2 · edited May 23 '17 at 11:46

Read it as bytestream. This explanation helped me for the same task My solution:

    from openpyxl import load_workbook
    from io import BytesIO
    ...
    if request.method == 'POST':
        form = UploadForm(request.POST, request.FILES)
        if form.is_valid():
            file_in_memory = request.FILES['file'].read()
            wb = load_workbook(filename=BytesIO(file_in_memory))

How to read xlsx file uploaded in django?

2 Answers2