Category - Excel
31 Jan 2009
1 Comments   41134 Views
Here Mudassar Ahmed Khan has explained how to export data to Microsoft Excel workbook using ADO.Net and C#
04 Feb 2009
10 Comments   69731 Views
Here Mudassar Ahmed Khan has explained how to read and import data to Microsoft Excel workbook using ADO.Net and C#
14 Mar 2009
120 Comments   192666 Views
Here Mudassar Ahmed Khan has explained how to export GridView to Word Excel PDF and CSV documents
14 Mar 2009
7 Comments   60219 Views
Here Mudassar Ahmed Khan has explained how to export GridView to Word Excel PDF and CSV documents
22 Apr 2009
6 Comments   30265 Views
Here Mudassar Ahmed Khan has explained how to Export a GridView with Images or Pictures to Word Excel or PDF Formats. In this article the GridView is displaying images from SQL Server Database
20 May 2009
49 Comments   88254 Views
Here Mudassar Ahmed Khan has explained how to export DataTable or DataSet to Word Excel PDF or CSV formats in ASP.Net
04 Jun 2009
39 Comments   71761 Views
In this article Mudassar Ahmed Khan has explained how to read Excel Sheet and import its data into the ASP.Net GridView control using ADO.Net
06 Jun 2009
35 Comments   98570 Views
Here Mudassar Ahmed Khan has explained how to import Excel Sheet Data into SQL Server Database table using ADO.Net in an ASP.Net Web application
19 Jun 2009
17 Comments   46023 Views
Here Mudassar Ahmed Khan has explained how to export multiple GridViews to the same Excel Sheet using ASP.Net
09 Sep 2009
2 Comments   19431 Views
Here Mudassar Ahmed Khan has explained how to export only selected or checked records or rows to excel sheet using ASP.Net GridView control
10 Sep 2009
2 Comments   30430 Views
Here Mudassar Ahmed Khan has explained how to export only those columns in ASP.Net GridView control that are selected or checked by the user
26 Nov 2009
6 Comments   35800 Views
Here Mudassar Ahmed Khan has explained how to add Excel like AutoFilter feature in ASP.Net GridView Control using DropDownList
09 Nov 2011
4 Comments   13730 Views
Here Mudassar Ahmed Khan has explained how to save the ASP.Net GridView control to Excel sheet on Server's disk using ASP.Net without download prompt.
23 Sep 2012
2 Comments   28998 Views
Here Mudassar Ahmed Khan has explained with an example how to filter data in GridView control with DropDownList in ASP.Net
20 Dec 2012
1 Comments   13243 Views
In this article Mudassar Ahmed Khan has explained with an example and attached sample code, how to Import data from Excel to GridView in ASP.Net.
20 Dec 2012
0 Comments   20712 Views
Here Mudassar Ahmed Khan has explained with an example and attached sample code, how to Import Excel Sheet data and records into SQL Server 2005, 2008, 2012 using ASP.Net
20 Dec 2012
0 Comments   5253 Views
Here Mudassar Ahmed Khan has explained with an example and attached sample code, how to upload data or records from Excel File after reading sheet contents to SQL Server in ASP.Net.
14 Jan 2013
0 Comments   6963 Views
Here Mudassar Ahmed Khan has explained with an example and attached sample code, how to Import or insert Excel Sheet data and records into SQL Server 2005, 2008, 2012 using ASP.Net
05 Feb 2013
2 Comments   10815 Views
Here Mudassar Ahmed Khan has explained with an example and attached sample code, how to export ASP.Net Chart Control (Pie Chart) to Excel Sheet using C# and VB.Net
05 Feb 2013
1 Comments   8080 Views
Here Mudassar Ahmed Khan has explained with an example and attached sample code, how we can create charts in Excel File programmatically from code using ASP.Net Chart Control with C# and VB.Net.
The Chart control can be easily populated from database using DataTable.
14 Mar 2013
0 Comments   9497 Views
Here Mudassar Ahmed Khan has explained with an example and attached sample code,how to export ASP.Net GridView control with Caption or Title to Excel file using C# and VB.Net.

GridView by default has a caption property but the problem is that it does not have much option of styling and alignment. Hence I have developed a trick where I am making use of Panel control and then exporting the Panel control to Excel file
14 Mar 2013
0 Comments   11010 Views
Here Mudassar Ahmed Khan has explained with an example and attached sample code, how to filter ASP.Net GridView control records using DropDownList control in HeaderTemplate or Header Row.
19 Mar 2013
0 Comments   7756 Views
Here Mudassar Ahmed Khan has explained with an example and attached sample code, how to export selected GridView rows to excel file in ASP.Net
19 Mar 2013
7 Comments   17813 Views
Here Mudassar Ahmed Khan has explained with an example and attached sample code, how to export all pages of GridView which has Paging (Pagination) enabled using AllowPaging property to Excel file in ASP.Net using C# and VB.Net.
11 May 2013
4 Comments   33774 Views
Here Mudassar Ahmed Khan has explained with an example and attached sample code, how to export GridView to Excel file in ASP.Net with formatting and styles using C# and VB.Net.
14 May 2013
0 Comments   7921 Views
Here Mudassar Ahmed Khan has explained with an example and attached sample code, how to hide some columns when exporting GridView to Excel in ASP.Net
21 May 2013
0 Comments   5055 Views
Here Mudassar Ahmed Khan has explained with an example and attached sample code, GridView with BoundField or TemplateField with Label can be exported easily and also displays properly. Problem occurs when the GridView with TemplateField Column contains controls like HyperLink, TextBox, Button, LinkButton, RadioButton or CheckBox controls. When such case occurs we need to convert remove these controls and replace them with Label or Literal controls.
26 May 2013
0 Comments   6999 Views
Here Mudassar Ahmed Khan has explained with an example and attached sample code, how to export GridView with TemplateField Column contains controls like HyperLink, TextBox, Button, LinkButton, RadioButton or CheckBox controls to Excel File after removing them.
24 Sep 2013
1 Comments   4602 Views
Here Mudassar Ahmed Khan has explained how to export GridView to Excel without losing GridLines in Exported Excel file in ASP.Net using C# and VB.Net.
04 Oct 2013
4 Comments   11690 Views
Here Mudassar Ahmed Khan has explained the solution to the warning / error “The file you are trying to open is in a different format than specified by the file extension”, that one gets when he tries to open the Excel file that was generated when exporting GridView to Excel.
31 Oct 2013
3 Comments   25926 Views
Here Mudassar Ahmed Khan has explained how to upload Excel File and then read and import its data into DataSet or DataTable using C# and VB.Net in ASP.Net Web Application.

The imported Excel File data is then displayed in ASP.Net GridView control.
18 Jan 2014
2 Comments   6180 Views
Here Mudassar Ahmed Khan has explained how to read Excel File using OLEDB Data Provider Connection in C# .Net. Excel Workbook is just like database with sheets corresponding to tables.
This article covers reading of both Excel 2003 as well as OpenXML i.e. Excel 2007, 2010 and 2013 formats.