0

Is there any way we can populate data into excel in Web API (in .net 4.7 framework not .net core) and return the result in excel format as part of GET request? I am totally new to this. please guide me regarding this.

Sainath
  • 19
  • 7
  • Does this answer your question? [Modify excel cell](https://stackoverflow.com/questions/23168657/modify-excel-cell) – Yehor Androsov Oct 29 '20 at 06:52
  • The sample is using EPPlus and few are suggesting ClosedXML which are third party source. It seems EPPlus is having licensing. Is there any library from microsoft (Interop) which can be used for this purpose and return the response as a stream? – Sainath Oct 29 '20 at 07:36
  • don't. let the API return the data itself, as it should and then the client can do whatever it wants with it. – Andrei Dragotoniu Oct 29 '20 at 08:07
  • that's true. We initially proposed the same where API returns data in json forma. But the client expects API to return well formatted, populated excel. That too without using any licensed third party libraries. – Sainath Oct 29 '20 at 10:36

0 Answers0