Exporting Excel Sheet without getting any warning message

We find many articles in order to export the data into excel sheet.

By using the below code we can export data to excel sheet without getting any warning message when we are trying to open the file.

In order to do this we need to  Add library files of NPOI into our project. This can be added though nuget or you can directly download from the below link and refer the dll into your project.

http://npoi.codeplex.com/releases

Logging the error message into text files in the application

With the below code you can log the error messages getting in your application into text files.
By doing this we can easily trace out the issue where we are getting.

Add the below code into Web.config App settings section

<add key="LogFilePath" value="C:\RootFolder\SubFolder\Logs\LogFile"/>

Import Html Files into Data Base

Below code is used to read the html files from ftp site and import all the data into Database.

Add the below Key codes into web.config file