How Do I Export Json Data Getting From Web Api Mvc4 To Excel Sheet Using Jquery

Question

4.00/5 (1 vote)

See more:

C#

jQuery

WebAPI

how do i export json data getting from web api mvc4 to excel sheet using jquery????

Posted 7-May-14 20:13pm

zoyajein

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Andrew Torrance · Accepted Answer · 2014-05-07T21:52:00

I think you have a wider problem than the how , and that is I don't think that you can map all possible Json structures to Excel since Json allows for hierarchical data and excel does not . I.e You cant map objects containing other objects and arrays of objects to a grid layout . If your Json is hierarchical then you can think up your own mapping scheme whereby you code against the one Json object you can display . But that might involve several views , and it would only work against that one object .
I would not consider attempting to use Jquery to pass data into Excel . Even if it were possible it seems a misuse of it ? Personally I would add the ability on the API to export a CSV or similar and then pass those into excel . ( But as mentioned above it may not be possible) .