0

I am working on a action that returns excel file - the excel is created using ComponentOne dll.

Here is what I have so far

public ActionResult DownloadExcel()
 {
            C1XLBook testBook = new C1XLBook();
            XLSheet s1 = testBook.Sheets[0];

            MemoryStream ms = new MemoryStream();
            testBook.Save(ms,FileFormat.Biff8);



            return File(ms, "application/ms-excel");
}

But I am getting a invalid Json error

On the JS side I have the following code

 $.ajax({

        contentType: 'application/json, charset=utf-8',
        type: "POST",
        url: /test/DownloadExcel,       
        cache: false,
        dataType: "json",

        success: function (response) {
            alert("good");            
        },

        error: function (xhr, ajaxOptions, thrownError) {

            alert("error");
        }

    });

What am I doing wrong?

sarsnake
  • 26,667
  • 58
  • 180
  • 286
  • 1
    How are you going to get an Excel document in the format of JSON? Your AJAX request is setting the data type of the return to be JSON. You should be doing this as a link and not AJAX: Download Excel – Nick Bork Jan 30 '12 at 21:17
  • are you trying to download an excel (BIFF8 binary) format as json? not sure how that will work out for u ... – scartag Jan 30 '12 at 21:18
  • Splash-X, I don't know what I was thinking. Thank you. Please put this as an answer - so I can mark it accepted. – sarsnake Jan 30 '12 at 21:37

0 Answers0