?
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,111 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

 
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

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

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

The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

770 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