Export DataGridView To Excel In c# Windows Application Step By Step

DataGridView tutorial. This tutorial I will show you, export DataGridView to excel in c# windows form application easily step by step. This is very simple code to export DataGridView to excel easily. You can learn how to export DataGridView to excel in c# using copy to clipboard step by step following this tutorial.
This tutorial also covered
-how to load data from sql server database to DataGridView in c# windows form application.
-how to connect sql server database with windows form application using c#.
-how to add reference Microsoft excel in your project.
-how to export DataGridView to excel using c#.
Follow these steps-
1. Create a project.
2. Design the form with label, button and DataGridView .
3. Write code in button click event to load data in DataGridView using c#.
4. Write code in export button click event to export DataGridView to excel c#.
private void ExportToExcel_Click(object sender, EventArgs e)
{
dataGridView1.SelectAll();
DataObject copydata = dataGridView1.GetClipboardContent();
if (copydata != null) Clipboard.SetDataObject(copydata);
Microsoft.Office.Interop.Excel.Application xlapp = new Microsoft.Office.Interop.Excel.Application();
xlapp.Visible = true;
Microsoft.Office.Interop.Excel.Workbook xlWbook;
Microsoft.Office.Interop.Excel.Worksheet xlsheet;
object miseddata = System.Reflection.Missing.Value;
xlWbook = xlapp.Workbooks.Add(miseddata);
xlsheet = (Microsoft.Office.Interop.Excel.Worksheet)xlWbook.Worksheets.get_Item(1);
Microsoft.Office.Interop.Excel.Range xlr = (Microsoft.Office.Interop.Excel.Range)xlsheet.Cells[1, 1];
xlr.Select();
xlsheet.PasteSpecial(xlr, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, true);
}
Note- You must have installed Microsoft office as well as excel in the PC- export datagridview to excel in c#.
------
This channel covers all the programming tutorial related with .Net- C#, linq, VB, SQL, Android, HTML, CSS, jQuery, Crystal Report and Microsoft Report.
So, Please subscribe and keep in touch.
/ @programminggeek
Visit my page in Facebook
/ programminggeek7
------
More Tags
#ExportDataGridViewToExcelInCSharp #ExportToExceTutorial #ProgrammingGeek
programminggeek,export datagridview to excel in c#, export datagridview to excel,export gridview to excel c#, c# export to excel, export datagridview to excel windows application, how to export datagridview data instantly to excel on button click, export grid data to excel in c#,visual studio c# export to excel, export dataview to excel c

[@maheswariganapathy]

Simply Superb....Thanks for the Video...😃

[@paulinedonor]

Well demonstrated! I have been watching videos as this was for my exams but this one is the best! It worked on me. Thank you sir!❤

[@martinmanalansan8941]

Thanks for the Video!😎

[@azamchy6019]

Nice demo.

[@aimanmalkawi8831]

Thanks man... i have been struggling with this one until i met your video. All the best and keepup the good work

[@ProgrammingGeek]

Glad it helped. You are very kind. Please keep connected.

[@aminaali5905]

Great tutorial thanks 👍😍😍👍

[@ProgrammingGeek]

Thanks for your comments 😃

[@rasulvalipoor7125]

Oooh thanks boy, great and simple, I was really stock

[@ProgrammingGeek]

Glad I could help. You are also great and kind. Please keep in touch!!

[@dulalmia5243]

Well demonstration. Keep it up.

[@ProgrammingGeek]

Thanks, will do!

[@nizamuddin4128]

Wow! its working fine. thanks.

[@ProgrammingGeek]

Thanks for your comment. please keep in touch.

[@wildanfirdaus7502]

amazing, thanks !!!

[@ProgrammingGeek]

You are really intelligent. Thanks

[@user-ig8pg8ov9y]

Thank you!

[@ProgrammingGeek]

Most welcome.

[@lynguyen-sh5jw]

thank you!!! it is worked

[@ProgrammingGeek]

You're welcome!

[@yashomanityagi4104]

but data is exporting without column headers
how we can do that ???

[@furkanturkylmaz3781]

Thanks for video, Can you explain how we can export the cell headers to excel

[@rambuddinagalakshmi7515]

So helpful thankyou so much

[@ProgrammingGeek]

Glad it was helpful! Please keep connected. Thanks

[@purbahazra7462]

Thanks a lot , really it helps me a lot

[@ProgrammingGeek]

Glad it helped! Thanks.

[@TenzinThinley]

super content. did u make video on how to import excel to datagridview?

[@rasulvalipoor7125]

What should I do if I want to extract a table with border

[@user-wx8xp9kq4i]

sir can i make visible the column name on the top of excel report ????

[@hindbenkouch9819]

thank you soooooooooo much

[@ProgrammingGeek]

Thanks you too for your time.

[@prosaa9168]

i have an exception when export date, it will become ###### can you fix it, thanks alot

[@mo-awny]

how can i set sheet right to left ? with ur code ?! can you help me sir

[@ehtishamakram4437]

I want to apend data in existing excel file but its always make new file. can anyone help me out ?

[@fatenaljabal3478]

thanx

[@ProgrammingGeek]

You're welcome!

[@miurangadananjaya1479]

good

[@ProgrammingGeek]

Thanks for your comment.

[@user-eo7dx5bp3f]

i USE GRAPH ,IS POSSIBLE TO EXPORT EXCEL

[@kyawaungmoe540mdy]

i want to known how to export selected column in C# with window application

[@ProgrammingGeek]

I will come with this tutorial very soon.

[@parcasio25]

I have an error " System.IO.FileNotFoundException: 'Could not load file or assembly 'office, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c'. The system cannot find the file specified.'" Could you help me?

[@ProgrammingGeek]

If you don't have latest Microsoft Office please install Microsoft Office latest version.

[@parcasio25]

@@ProgrammingGeek Currently I am using Office 2010 :

[@ProgrammingGeek]

@@parcasio25 Add references with Microsoft office excel by following this tutorial. May be you will success. thanks.

[@KaranbirJanjua]

Thanks for the tutorial but I was wondering why the headers are not getting copied as well ? thanks

[@ProgrammingGeek]

OH! You got it. Actually i didn't see it during the video creation. I will check it. thanks for your comment.

[@bullseyerendan7486]

@@ProgrammingGeek so did you find out why it aint getting copied, if yes then can you please share your code

[@ncueBenson]

@@bullseyerendan7486 because header won't be copy just set yourgrid.ClipboardCopyMode = DataGridViewClipboardCopyMode.EnableAlwaysIncludeHeaderText;

[@joaodematos4083]

You just need to enable this propriety in your datagrid. ClipBoardCopyMode = EnableAlwaysIncludeHeaderText

[@surya.banerjee]

For windows 11 it's not working 😢 why ? How to solve?

[@marcadrianc.benales1015]

How about the header Title?

[@joaodematos4083]

You just need to enable this propriety in your datagrid. ClipBoardCopyMode = EnableAlwaysIncludeHeaderText

[@womercabrestante7938]

thing kwu sa Code priii agiiiik!!!

[@CesarHernandez-vx7ti]

TO PDF???

[@ProgrammingGeek]

I will do it soon.

[@kusinanidaddymonyo4844]

how to include the column name?

[@ProgrammingGeek]

Mentioned in the tutorial. thanks

[@joaodematos4083]

You just need to enable this propriety in your datagrid. ClipBoardCopyMode = EnableAlwaysIncludeHeaderText