Export Datatable (Gridview) to Excel in Windows Application using C#, VB.NET

Introduction: 

Here I will explain how to export datatable or datagridview to excel in windows forms application using  c# vb.net or export datagridview or datatable data to excel in windows application using c# , vb.net or export datagridview / datatable to excel in windows forms using c# , vb.net.

Description:
  
In previous articles I explained bind data to datagridview in windows application, create windows form application file, delete windows service from system, use progressbar control in windows application and many articles relating to windows application, asp.net, c#,vb.net and jQuery. Now I will explain how to export data from datagridview to excel in c# windows application

Excel Find and Highlight Duplicate Values in Columns (Rows)

Introduction: 

Here I will explain how to find and highlight duplicate rows in excel or find duplicate values in excel columns and highlight it or find and highlight duplicate values in excel with colors. By using excel highlight cells rules property in conditional formatting section we can find and highlight duplicate values in excel columns.

Description:
  
In previous articles I explained compare two columns values and show duplicate values in excel, shutdown system automatically in windows 7, keyboard event key codes and character codes, create desktop shortcut key to lock computer, configure dns server in windows 7. Now I will explain how to compare excel columns to find duplicate values and highlight it.

Excel Compare Two Columns to Find Duplicate Values for Matches on Conditional Formatting

Introduction: 

Here I will explain how to compare two columns in excel to find duplicate values for matches on conditional formatting or excel conditional formatting to find duplicate values in columns or get / find duplicate values in columns in excel. By using excel conditional formatting formulas we can get duplicate values in excel columns.

Description:
  
In previous articles I explained shutdown system automatically in windows 7, keyboard event key codes and character codes, create desktop shortcut key to lock computer, configure dns server in windows 7. Now I will explain how to compare excel columns to find duplicate values for matches using conditional formatting.

Export Datagridview Data to Excel in C# Windows Application (VB.NET)

Introduction: 

Here I will explain how to export data from datagridview to excel in c# windows application in vb.net or export datagridview data to excel in windows application using c# , vb.net or export datagridview to excel in windows forms using c# , vb.net.

Description:
  
In previous articles I explained bind data to datagridview in windows application, create windows form application file, delete windows service from system, use progressbar control in windows application and many articles relating to windows application, asp.net, c#,vb.net and jQuery. Now I will explain how to export data from datagridview to excel in c# windows application

How to Create and Download Excel File in Asp.net C#, VB.NET

Introduction: 

Here I will explain how to create and download excel file in asp.net using c#, vb.net or create & download excel file from datatable in asp.net using c#, vb.net.

Description:
  
In previous articles I explained export data to excel from datatable in asp.net, Get Controls inside gridview in asp.net, import data from excel to sql database in asp.net, export gridview data to excel in asp.net using c#, export gridview data to pdf in asp.net using c# and many articles relating to asp.net, c#,vb.net and jQuery. Now I will explain how to create and download excel file in asp.net using c#.

How to Export Data from SQL Server to Excel in Asp.net using C#

Introduction: 

Here I will explain how to export data from sql server to excel in asp.net using c# or export data from sql server database to excel in asp.net using c#.

Description:
  
In previous articles I explained sql injection attacks prevention in asp.net, ExecuteReader example in asp.net, import data from excel to sql database in asp.net, export gridview data to excel in asp.net using c# , export gridview data to pdf in asp.net using c# and many articles relating to asp.net, c#,vb.net and jQuery. Now I will explain how to export data from sql server to excel in asp.net using c#.

How to Export Data to Excel from Datatable or Gridview in Asp.net using c#, vb.net

Introduction: 

Here I will explain how to export data to excel from datatable or dataset in asp.net using c# and vb.net or export data to excel from gridview in asp.net using c# and vb.net.

Description:

In previous posts I explained export gridview data to csv file in asp.net, export gridview data to pdf file in asp.net, export data from excel to gridview in asp.net, import excel data to sql server in asp.net, asp.net Google currency converter and many articles relating to gridview, asp.net, c#. Now I will explain how to export data to excel from datatable or dataset in asp.net using c# and vb.net.

C# - Export Excel Data to Datatable or Dataset or Gridview in Asp.net

Introduction:

Here I will explain how to export excel data to datatable or dataset in C#, VB.NET or export data from excel to gridview in asp.net using OLEDB in C#, VB.NET.

Description:
  
In previous article I explained Export gridview data to excel in asp.net, How to Export gridview data to excel/word document, Import Excel data to sql database and some other articles relating to export gridview data. Now I will explain how to export excel data to datatable or dataset or gridview in asp.net using C#, VB.NET.

C#- Import/Upload Data from Excel to SQL Server 2008 in Asp.net using C#, VB.Net.

Introduction:

Here I will explain how to upload or import data from excel to SQL Server using asp.net in c#, vb.net.

Description:
  
In previous article I explained Import Excel data to gridview in asp.net, How to Export gridview data to excel/word document, Import Excel data to sql database and some other articles relating to export gridview data. Now I will explain how to upload or import data from excel to SQL Server using asp.net in c#, vb.net.

Import/Upload Excel Data to Asp.net Gridview in C#, VB.NET

Introduction:

Here I will explain how to import data from excel to gridview in asp.net using OLEDB in C#, VB.NET.

Description:
  
In previous article I explained How to Export gridview data to excel/word document, Import Excel data to sql database and some other articles relating to export gridview data. Now I will explain how to import data from excel to gridview in asp.net.

Export selected rows of gridview to Excel or word in ASP.Net

Introduction:

Here I will explain how to export only selected or checked rows or records from gridview to Word or Excel sheet using asp.net.

Description:

In my previous posts I explained clearly how to export gridview data to Excel or word using asp.net and how to export gridview data to PDF using asp.net and explained another post that is Export gridview data to CSV file using asp.net. After explain all the concepts one of the user has asked me a question i.e. how to export gridview records to excel/word based on checkbox selection in gridview. To implement this one first design one table in database as shown below and give name as “UserInformation” 

Export gridview data to Excel/word document in asp.net C#

Introduction:

Here I will explain how to export gridview to Word or Excel document using asp.net in c#.

Description:

I have one gridview that has filled with user details now I need to export gridview data to word or excel document based on selection. To implement this functionality first we need to design aspx page like this 

how to Import data from EXCEL to SQL Database in ASP.NET

Introduction

Here I will explain how to Import or insert data into SQL database from Excel spreadsheet using Sqlbulkcopy method.

Description

 I have searched for so many posts that explain static manner some of the posts are not clearly some of the posts are not supporting for latest excel files so many problems i faced by using those examples I have done application that will support for all excel versions and it will work for you without having any problems and it will dynamically you can upload excel sheet from anywhere from your computer.

First of all create Excel workbook as shown in image below and insert some data into it. Please design excel sheet like whatever I shown in image

Read the data from Excel Sheet and bind it to Gridview in asp.net

Here i will explain how to read the data from Excel sheet and bind that data to gridview in asp.net

1) First take one upload control, one button and one gridview like this

How to Make Some cells Read only in Excel Sheet and other should be editable

In Excel sheet we can make some cells read only and some cells editable by using these following steps

1) First Select whole Excel Sheet by Ctrl+A After that

2) Right Click on excel sheet you will find Format Cells Option that screen look like this