Excel export without Creating on IIS

Question

Dear All Good Days !!! I would like to know the correct steps to export data in excel file. My Envirioment is Visual studio 2010 SQL Server 2008 Frame work 4.5 The output file SOULD NOT BE CREATED ON IIS SERVER - Please help your guidence for this requirment. Note : It is my earlier related post :http://www.c-sharpcorner.com/forums/excel-export-need-steps

O. Developer · Answer

HI When I am trying to connect -Report Wizard - i am getting below error in my laptop. Any fix for this. Could not load file or assembly 'Microsoft.SqlServer.Types Version=11.0.0.0 Culture=neutral PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

Dr.Ajay Kashyap · Answer

Use sql server data tool......

Manas Mohapatra · Answer

Follow below links that may help you to export excel file without creating file: http://www.aspsnippets.com/Articles/Write-data-to-Excel-file-xls-and-xlsx-in-ASPNet.aspx http://stackoverflow.com/questions/16346227/export-data-to-excel-file-with-asp-net-mvc-4-c-sharp-is-rendering-into-view http://techbrij.com/export-excel-xls-xlsx-asp-net-npoi-epplus

Shubham Kumar · Answer

Hi as you say you don't want to create the excel file on iis server here is the link it may help you http://stackoverflow.com/questions/10628136/download-excel-file-from-asp-net-page-without-generating-physical-file-on-server