Aspdotnet-Suresh

aspdotnet-suresh offers C#.net articles and tutorials,csharp dot net,asp.net articles and tutorials,VB.NET Articles,Gridview articles,code examples of asp.net 2.0 /3.5,AJAX,SQL Server Articles,examples of .net technologies

Showing posts with label ExcelSheet. Show all posts
Showing posts with label ExcelSheet. Show all posts

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

Sep 1, 2015 4 comments
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)

Jun 18, 2015 0 comments
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

Jun 12, 2015 1 comments
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)

Dec 4, 2014 5 comments
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

Nov 11, 2014 3 comments
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.

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

Nov 6, 2014 8 comments
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#.

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

Nov 5, 2014 8 comments
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

2 comments
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.netHow to Export gridview data to excel/word document, Import Excel data to sql database
and some other articles relating to export gridview dataNow 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.

Dec 18, 2012 11 comments
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

Dec 17, 2012 64 comments
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

Dec 12, 2011 16 comments
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#

Apr 2, 2011 80 comments
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

Sep 15, 2010 196 comments
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

Jun 21, 2010 33 comments
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

13 comments
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



© 2015 Aspdotnet-Suresh.com. All Rights Reserved.
The content is copyrighted to Suresh Dasari and may not be reproduced on other websites without permission from the owner.