Solved

how to export data from selected columns in datagridview to excel in windows application using c# 2008?

Posted on 2011-03-16
9
942 Views
Last Modified: 2013-12-17
how to export data from selected columns in datagridview to excel in windows application using c# 2008
0
Comment
Question by:NeetD
  • 4
  • 4
9 Comments
 
LVL 30

Accepted Solution

by:
SiddharthRout earned 500 total points
ID: 35154247
0
 

Author Comment

by:NeetD
ID: 35154851
I have been created windows application in Visual Studio 2008 using C# and MS Access for database.
I want to transfer selected column of datagidview to Excel with Header at runtime means client will select any column as per his choice and then export to excel.
 and date should be in dateformat ,it sholudnot include time.
0
 
LVL 11

Expert Comment

by:SAMIR BHOGAYTA
ID: 35155709
Hi, convert this code to C# then try it.

Sub doExcel(Source as Object, E as EventArgs)
If gv.Rows.Count.ToString + 1 < 65536 Then
gv.AllowPaging="False"
gv.DataBind
Dim tw As New StringWriter()
Dim hw As New System.Web.UI.HtmlTextWriter(tw)
Dim frm As HtmlForm = new HtmlForm()
Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader("content-disposition", "attachment;filename=" & "export.xls")
Response.Charset = ""
EnableViewState = False
Controls.Add(frm)
frm.Controls.Add(gv)
frm.RenderControl(hw)
Response.Write(tw.ToString())
Response.End()
gv.AllowPaging="True"
gv.Databind
Else
LblError.Text="Too many rows - Export to Excel not possible"
End If
End Sub
0
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 
LVL 30

Assisted Solution

by:SiddharthRout
SiddharthRout earned 500 total points
ID: 35162749
NeetD: Didn't the links that I gave above help you?

Sid
0
 

Author Closing Comment

by:NeetD
ID: 35165111
I have been refer those links and done some modification to get result.
0
 

Author Comment

by:NeetD
ID: 35165153
now i am transferring selected column from datagridview and then export to excel but while doing this those unselected columns are also created with empty value in excel.
Now i want to know, how to delete null columns in excel using c#?
0
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 35165223
Post your complete code please.

Sid
0
 

Author Comment

by:NeetD
ID: 35171296
DataGridView1.RowHeadersVisible = false;  
DataGridView1.SelectAll();
Clipboard.SetDataObject(DataGridView1.GetClipboardContent(), true);
StreamWriter sw = new StreamWriter("d:\\ReservationDetail.xls");
sw.Write(Clipboard.GetText());
sw.Flush();
sw.Close();
DataGridView1.ClearSelection();  
DataGridView1.RowHeadersVisible = true;
0
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 35172061
NeetD: I don't know C# as I code in vb.net but what I can see from your code is that this line

DataGridView1.SelectAll();

is selecting all the contents of the datagrid. I believe there is a click event of the grid where you can transfer the current column to Excel?

Sid
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

792 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question