Interop Excel

mithun narayanan

Is it possible to insert dynamically generated html table directly into an Excel using interop. Please reply... Thanks in advance,,,,

sashidhar

How it Is related to asp.net..! Try the other forums my friend..!:thumbsup:

LatestArticle :Log4Net Why Do Some People Forget To Mark as Answer .If It Helps.

mithun narayanan

I am using it in asp .net itself... code behind is C# .... please let me know if it is possible or not......:confused: Thanks in advnce...

sashidhar

Then why to interop cant u use directly the code..! try this link..! http://forums.asp.net/t/1214938.aspx[^]

LatestArticle :Log4Net Why Do Some People Forget To Mark as Answer .If It Helps.

gg4237

If your web app is for a couple of users, then Excel Interop might work, but check out if Excel is installed on server. But for other scenarios, don't use Excel Interop on server side. It scales bad and uses server's resources intensively. Also Excel Interop has other issues. If your dynamically generated HTML table is generated from GridView you could try GemBox.Spreadsheet .NET Excel component to export it to Excel because it is directly supported. Here is an example how to export DataGrid to Excel and how to export DataTable to Excel with GemBox.Spreadsheet component.