Only using Microsoft.Office.Interop.Excel

[patrick]

Hello

I need to Find a example source that uses Microsoft.Office.Interop.Excel to save DataTable(DataRow) type data in Excel.
The library downloaded from Nuget is not allowed.
Only, I should write code using only Microsoft.Office.Interop.Excel as DataTable(DataRow) type data.
i need to save as Excel File. (Do not save as a CSV File.)
there is example source or Is there an internet site with example sources?

thank you.

Waiting for your reply.

 

[Skydiver]

Be aware that you shouldn't be using Microsoft.Office.Interop from a web server.

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.

Considerations for server-side Automation of Office - Microsoft Support

Describes problems when using server-side Automation of Office and offers alternatives to Automation that can speed performance.

support.microsoft.com

 

[cjard]

ClosedXml is open source