Passing an Excel file to server using AJAX Post

Question

I simply want to be able to use a html Input type="file" to select an Excel file

<input type="file" id="UploadedFile" name="UploadedFile" accept="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet">

then pass that chosen file back to the server - preferably using AJAX post:

    var serviceURL = appRoot + 'Register/ImportTasks'

    $j.ajax({
        type: "post",
        url: serviceURL,
        data: (??? Not sure how to present here ???),
        contentType: "application/json; charset=utf-8",
        dataType: "json",
        success: successFunc,
        error: errorFunc
    });

Specifically I cannot see how I present the 'file' to the AJAX call as data.

    public void ImportTasks(DataType?? uploadedExcelFile)
    {
        ..... Doing stuff ...
    }

And then I am unsure as to what parameter datatype I should then tell the Method to expect when it is called?

Does this answer your question? jQuery ajax upload file in asp.net mvc — Chetan
– Chetan, Commented Mar 16, 2020 at 21:48
This does look promising actually....! I will probably take a look in the morning and will update! Many thanks for the quick response...! Really appreciate it! :) — CJH
– CJH, Commented Mar 16, 2020 at 21:49

Train · Accepted Answer · 2020-03-16 21:50:50Z

3

Here is a basic example. You should use FormData

     var formData = new FormData();
     var uploadFiles = document.getElementById('js-upload-files').files;
     this.formData.append("MyKey", uploadFiles[0]);

    $.ajax({
        type: "POST",
        url: 'Controller/Upload',
        data: formData,
        dataType: 'json',
        contentType: false,
        processData: false,
        complete: this.onComplete.bind(this)
    });

Edit

Forgot controller code

    [HttpPost]
    public virtual BetterJsonResult Upload()
    {

        foreach (var fileKey in Request.Files)
        {
            ...Request.Files[fileKey.ToString()] //access it like this
        }

    }

answered Mar 16, 2020 at 21:50

Train

3,5363 gold badges33 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

CJH Over a year ago

Thanks - this and a couple of other similar suggestions have gotten this working for me.

Collectives™ on Stack Overflow

Passing an Excel file to server using AJAX Post

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related