Today we will look at how to build Export to Excel functionality by deriving new type from ActionResult class.

To get started, lets setup following:

An ASP.NET MVC project
New controller with name "ExcelController.cs" inside controller folder
ConnectionString to any database (in this one I am using Products table of Adventure works database) [More]

Problem Statement:

In a company say ABC Inc. you have stored data in the database for each department. Data includes Location, total salary, # of Paid vacation, and total #of employees for each department. We have a department head for every department and once in every month we need to send these department head's a summary report reflecting this data in an excel file. So our goal is to create different excel reports for each department. [More]

In this article, we will be using FTP task to download an .xls file and then use that file to upload it in SQL Server using Data Flow Task base. So let's create a new package and name our package as DownloadFile. [More]

There is a common need where we are required to generate a report from a database and send that report to group of people. In this article we will see as how we can use SSIS to design a work flow to first create an excel report and then send in an Email. [More]

Generating reports in excel is very common. With C#'s help, you can almost do anything in excel so whether it's excel based chart for funnel report or any regular analysis report.

Today, we will see how to generate reports in excel using C#. In order to do this we will create a console based application. [More]