Hi All, I am developing an application in .NET Core with angular client. I have a scenario where user click on Download button and data from SQL Server will be exported to excel sheet in .NET Core WebAPI. The generated and downloaded sheet will display- Image on top left corner of sheet from Images folder in WebAPI. This image will be displayed in several cells based on its size. For example image can be stretched/displayed in 5 columns and 8 rows in excel. Data from SQL Server will be displayed just below above image in tabular format with headers in Navy blue color and text in white over them. The sheet will not have any default cell. It will display data in tabular format(generated from code) and each column will fit to the content size. Please let me know how can I achieve the same ASAP. Regards, Pratham

Export data to excel in .NET Core

Pratham Jain 221

Hi All,

I am developing an application in .NET Core with angular client. I have a scenario where user click on Download button and data from SQL Server will be exported to excel sheet in .NET Core WebAPI. The generated and downloaded sheet will display-

Image on top left corner of sheet from Images folder in WebAPI. This image will be displayed in several cells based on its size. For example image can be stretched/displayed in 5 columns and 8 rows in excel.
Data from SQL Server will be displayed just below above image in tabular format with headers in Navy blue color and text in white over them.
The sheet will not have any default cell. It will display data in tabular format(generated from code) and each column will fit to the content size.

Please let me know how can I achieve the same ASAP.

Regards,

Pratham

Xinran Shen - MSFT 2,091 Reputation points

2023-01-30T02:10:32.1+00:00

Hi @Pratham Jain, You can use EPPlus or ClosedXML library to export data to excel in Asp.Net Core.