How to create excel file using json data using c#?

Question

I have sample json data and want to create a xls file using that.

"{\"Id\":\"123\",\"Name\":\"DEMO\",\"Address\":\"US\",\"Team\":\"JK\"}"

Want to create a excel file stream which I will upload on azure storage using below code -

CloudFile cloudFile = cloudFileDirectory.GetFileReference("filename.xls");
cloudFile.UploadFromStream(fileStream);

output expected -

I'm able to create csv by below code -

var result = new StringBuilder();
    for (int i = 0; i < table.Columns.Count; i++)
    {
        result.Append(table.Columns[i].ColumnName);
        result.Append(i == table.Columns.Count - 1 ? "\n" : delimator);
    }
    foreach (DataRow row in table.Rows)
    {
        for (int i = 0; i < table.Columns.Count; i++)
        {
            result.Append(row[i].ToString());
            result.Append(i == table.Columns.Count - 1 ? "\n" : delimator);
        }
    }
    return result.ToString().TrimEnd(new char[] { '\r', '\n' });

Convert the JSON input to objects, create excel file and write those object into it. — David Walser
– David Walser, Commented Jul 19, 2018 at 10:10

Fedor · Accepted Answer · 2018-07-19 10:27:38Z

4

to generate xls file from json files you should done those steps

Read file
Parse JSON file (Json.NET is the best) to your c# Class object.
Choose xls framework(using Open XML SDK or anyone which do you find)
Use structure from step 2 to fill columns and rows in xls file using framework API from step 3.

answered Jul 19, 2018 at 10:27

Fedor

1815 bronze badges

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

Comments

Hambone · Accepted Answer · 2018-07-22 02:24:47Z

3

If you already have a datatable, then you can convert a data table to a spreadsheet as easy as pie using EPPLus. The code could be as simple as this:

FileInfo f = new FileInfo("filename.xlsx");
ExcelPackage package = new ExcelPackage(f);

ExcelWorksheet ws = package.Workbook.Worksheets.Add("Data");
ws.Cells["A1"].LoadFromDataTable(table, true);

If you have some special handling, for date formats and such, it might be moderately more work, but not much.

From Nuget:

Install-Package EPPlus

If you've ever worked with Excel Interop, you will love how much easier EPPlus is to work with.

answered Jul 22, 2018 at 2:24

Hambone

16.5k8 gold badges54 silver badges79 bronze badges

Collectives™ on Stack Overflow

How to create excel file using json data using c#?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related