[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

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

Posted on 2011-03-16
9
Medium Priority
?
1,260 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 1500 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 30

Assisted Solution

by:SiddharthRout
SiddharthRout earned 1500 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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

834 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