Extract data in an ASP.NET MVC web application on SQL to excel

Question

1.00/5 (1 vote)

See more:

I wanted to extract data in an asp.net mvc web application on sql to Excel.
I wanted to know how to do it.

What I have tried:

How

extract data in an asp.net mvc web application on sql to Excel

Posted 4-Feb-20 8:55am

Member 14663996

Updated 11-Feb-20 5:45am

Add a Solution

Comments

Maciej Los 4-Feb-20 15:22pm

What have you tried?

Herman<T>.Instance 5-Feb-20 3:25am

I guess asking a question here

2 solutions

Add a Solution

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

Maciej Los · Answer 1 · 2020-02-04T09:26:00

Solution 1

Start here: Google[^]

There's over 3440000 results! For example: Export Data In Excel Sheet In ASP.NET MVC[^]

Posted 4-Feb-20 9:26am

Maciej Los

MarcusCole6833 · Answer 2 · 2020-02-11T05:46:00

Solution 2

I had a task to do this with Web Forms and I had some issues using the MSFT interop office DLL's and found this piece of Open Source Software an good solution
EPP Plus

GitHub - JanKallman/EPPlus: Create advanced Excel spreadsheets using .NET[^]

NuGet Gallery | EPPlus 4.5.3.3[^]

Posted 11-Feb-20 5:46am

MarcusCole6833

Comments

Richard Deeming 11-Feb-20 12:38pm

I'm not surprised you had problems with Office interop:

Considerations for server-side Automation of Office[^]
"Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, ASP.NET, DCOM, and NT Services), because Office may exhibit unstable behavior and/or deadlock when Office is run in this environment."

:)

MarcusCole6833 11-Feb-20 14:02pm

a slight learning curve; one of those it works on my machine!!!!!

Extract data in an ASP.NET MVC web application on SQL to excel

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Extract data in an ASP.NET MVC web application on SQL to excel

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us