Send Excel File to ASP.NET Web API

Question

How do I send an excel file coming from file upload input to my ASP.NET WebAPI and then save that excel file so I can read its data?

Here's what I've got (button click calls upload()) - just the basics, which works fine:

    function upload() {
        $.getJSON("api/uploads/uploadfile",
            function (data) {
                $("#mydiv").append("Success: " + data.Success + " Failed: " + data.Failed);
            });
    }

And my ASP.NET WebAPI method:

    public DBResult UploadFile()
    {
        DBResult result = new DBResult();
        result.Success = 0;
        result.Failed = 0; 

        return result;
    }

Any help is greatly appreciated.

TIA

Solution 1

I was able to figure this out between these 2 articles:

How To Accept a File POST

http://www.strathweb.com/2012/04/html5-drag-and-drop-asynchronous-multi-file-upload-with-asp-net-webapi/

Solution 2

I posted a similar solution at another question, but using c# to post to webapi:
How To Accept a File POST

Comments

[Rup]

Does that upload work? To upload a file you normally have to actually post a form, e.g. see the jQuery Form plugin, rather than just make a normal AJAX request. And what's the file upload control - an ASP.NET HtmlInputFile control? You should just be able to read the file contents out of the control as a stream.

[Rivka]

No, I haven't gotten the file upload to work. I'm using <input type="file"/>. I've read about form with action and enctype, but I'm still not sure how to retrieve that file in the WebAPI method.

[Mike Wasson]

See my answer here: stackoverflow.com/questions/10320232/…

[Rivka]

@MikeWasson I was able to figure this out. Your article helped, as well as strathweb.com/2012/04/…. Thanks.