Excel export without Creating on IIS

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 Kashyap10y ago

Use sql server data tool......

Manas Mohapatra10y ago

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 Kumar10y ago

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