Click here to Skip to main content
14,664,816 members
Home » Discussions » ASP.NET
   

ASP.NET

 
AnswerRe: Generate an MVC Project Folder and Files Using Web API 2.2 Pin
Richard MacCutchan30-Apr-20 21:36
mveRichard MacCutchan30-Apr-20 21:36 
GeneralRe: Generate an MVC Project Folder and Files Using Web API 2.2 Pin
MadDashCoder1-May-20 2:29
MemberMadDashCoder1-May-20 2:29 
GeneralRe: Generate an MVC Project Folder and Files Using Web API 2.2 Pin
Richard MacCutchan1-May-20 3:23
mveRichard MacCutchan1-May-20 3:23 
GeneralRe: Generate an MVC Project Folder and Files Using Web API 2.2 Pin
Mycroft Holmes1-May-20 12:05
professionalMycroft Holmes1-May-20 12:05 
QuestionC++,Jquery, SQL MVC, produce Excel pie graph? Pin
Member 1464122429-Apr-20 20:47
MemberMember 1464122429-Apr-20 20:47 
GeneralRe: C++,Jquery, SQL MVC, produce Excel pie graph? Pin
Richard MacCutchan29-Apr-20 23:29
mveRichard MacCutchan29-Apr-20 23:29 
GeneralRe: C++,Jquery, SQL MVC, produce Excel pie graph? Pin
Member 1464122429-Apr-20 23:44
MemberMember 1464122429-Apr-20 23:44 
AnswerRe: C++,Jquery, SQL MVC, produce Excel pie graph? Pin
Richard Deeming30-Apr-20 0:26
mveRichard Deeming30-Apr-20 0:26 
If you're thinking about automating Excel from your ASP.NET MVC application, you should read the following Microsoft knowledgebase article:
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.
The same would apply to automating it from SQL.

Javascript will not be able to automate it at all. Even if the user had Excel installed, Javascript is not allowed to access or automate applications on the user's computer for security reasons.

To generate an Excel file on the server, you would need to use a library which doesn't rely on automating Excel. For example:
The OpenXML SDK[^]
How to: Insert a chart into a spreadsheet document (Open XML SDK) | Microsoft Docs[^]

(Previously I would have recommended EPPlus, which supports charts. But unfortunately, it's no longer free. The other go-to library, ClosedXML[^], doesn't support charts yet.)



"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

GeneralRe: C++,Jquery, SQL MVC, produce Excel pie graph? Pin
Member 1464122430-Apr-20 0:45
MemberMember 1464122430-Apr-20 0:45 
AnswerRe: C++,Jquery, SQL MVC, produce Excel pie graph? Pin
pkfox9-Jun-20 5:33
professionalpkfox9-Jun-20 5:33 
QuestionMVC4 using JWT tokens Pin
Simon_Whale29-Apr-20 0:46
professionalSimon_Whale29-Apr-20 0:46 
AnswerRe: MVC4 using JWT tokens Pin
jkirkerx29-Apr-20 12:46
professionaljkirkerx29-Apr-20 12:46 
GeneralRe: MVC4 using JWT tokens Pin
Simon_Whale29-Apr-20 20:49
professionalSimon_Whale29-Apr-20 20:49 
GeneralRe: MVC4 using JWT tokens Pin
jkirkerx30-Apr-20 7:21
professionaljkirkerx30-Apr-20 7:21 
GeneralRe: MVC4 using JWT tokens Pin
MadMyche30-Apr-20 10:57
mveMadMyche30-Apr-20 10:57 
QuestionI can not connect to the web service Pin
gr_nik28-Apr-20 1:36
Membergr_nik28-Apr-20 1:36 
Questionproblem when publishing asp.net core project on a server Pin
ElenaRez18-Apr-20 22:15
MemberElenaRez18-Apr-20 22:15 
AnswerRe: problem when publishing asp.net core project on a server Pin
Mycroft Holmes19-Apr-20 12:25
professionalMycroft Holmes19-Apr-20 12:25 
AnswerRe: problem when publishing asp.net core project on a server Pin
jkirkerx20-Apr-20 8:07
professionaljkirkerx20-Apr-20 8:07 
QuestionMVC Core 3.1 I need to display multiple images (with transparency) on top of each other as 1 image Pin
clemenslinders13-Apr-20 21:19
Memberclemenslinders13-Apr-20 21:19 
AnswerRe: MVC Core 3.1 I need to display multiple images (with transparency) on top of each other as 1 image Pin
Richard Deeming14-Apr-20 0:51
mveRichard Deeming14-Apr-20 0:51 
GeneralRe: MVC Core 3.1 I need to display multiple images (with transparency) on top of each other as 1 image Pin
clemenslinders14-Apr-20 1:06
Memberclemenslinders14-Apr-20 1:06 
GeneralRe: MVC Core 3.1 I need to display multiple images (with transparency) on top of each other as 1 image Pin
Richard Deeming14-Apr-20 1:30
mveRichard Deeming14-Apr-20 1:30 
GeneralRe: MVC Core 3.1 I need to display multiple images (with transparency) on top of each other as 1 image Pin
clemenslinders15-Apr-20 0:07
Memberclemenslinders15-Apr-20 0:07 
Questionerror in logging when authenticating against active directory with asp.net core by ldap Pin
ElenaRez11-Apr-20 20:23
MemberElenaRez11-Apr-20 20:23 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.