Code to download excel file in asp.net using c#

Hence, we are going to get the data from the database. Add some entity classes and database access class. To add the new Model class, right click on the Models folder and choose Add. Choose Class and it will give you the dialog Window, where you can provide the name of the class.

Thus, I am going to add the following entity classes and database context classes. View All. Mukesh Kumar Updated date Jul 26, Cannot open the file, file fotmat may be different or file may be corrected. But if I go to the drive directly I can open the same file. Clear ; Response. AddHeader "Content-Length", file. ToString ; Response. WriteFile file. Write "This file does not exist. Improve this question. Sanju Sanju 85 2 2 gold badges 3 3 silver badges 10 10 bronze badges.

Which ASP. Net framework are you using? WebForms or MVC? I am using framework 3. This is working fine with othe downloading app, giving error for this. Add a comment.

Active Oldest Votes. You can try with this code Response. Application xlApp ; Excel. Workbook xlWorkBook ; Excel. To quote myself again: 'The folder you need will be a part of your website structure, almost certainly, and that means you probably need something like Server.

And where is the downloads folder in your website in production? Now many different websites are hosted on the same computer? Most systems organise this into a hierarchical structure so you have the website root folder with the default. MapPath to convert a relative address i. MapPath because you have no idea where your site is hosted, or when it might be moved. Add your solution here. OK Paste as. Treat my content as plain text, not as HTML.

Existing Members Sign in to your account. This email is in use. Do you need your password? Submit your solution! When answering a question please: Read the question carefully. Understand that English isn't everyone's first language so be lenient of bad spelling and grammar. If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem.

Insults are not welcome. Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid. Related Questions. Excel file not saving in asp. How can I protect an existing excel file with password. Zip files within a folder including the source folder. How to copy an excel file and save as new excel file in C MS excel interop.

Can not get txt file in folder. Automate download of file using.