How to convert .xlsx file to .Json file in asp.net using c#

Question

0.00/5 (No votes)

See more:

.NET4.5

Hi, can any one tell me how to convert .xlsx file to .Json file by uploading xlsx file converting it into json file and then downloading .json file
Best regards
Ali

Posted 21-Aug-14 3:02am

Member 10532069

Updated 21-Aug-14 3:03am

v2

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)

Sharmanuj · Accepted Answer · 2014-08-21T03:17:00

Solution 1

Follow these steps to get the required output.

1. Read the .xlsx file and store all the data in DataTable object.
2. Make a dictionary object like this e.g
Dictionary<string,list><string>> obj = new Dictionary<string,list><string>>
3. Fill the list object with all the Rows values for selected column
4. the first parameter for Dictionary object would be the key and it will refer the column name defined in excel file.
5. Once you fill all the values in the dictionary object, generate the output in Json format by using

JsonConvert.SerializeObject(objectToSerialize)

to use JsonConvert class include the Dll Newtonsoft.Json.

Posted 21-Aug-14 3:17am

Sharmanuj

Comments

Member 10532069 23-Aug-14 2:25am

Thanks Sharmanuj
Could you please elaborate the 3rd & 4th step little more.
am not able to understand the point .
If i have n no: of column in excelsheet.
Best regards
Ali

Sharmanuj 4-Dec-14 4:14am

Hi Ali,

If you have n no of columns in your excel file and want to capture all the columns data in the json file then, your column name would be the key for the dictonary object. And the rows data would be in the list object.

for example if you have 10 rows and 5 columns then list object would contain 10 rows data related to first column and that would get added in dictonary. Similarly for all the columns.

Regards,
Sharmanuj