C# - How to Export DataGridView Data to Ms Excel File in Visual C#

Hey Friends, This is SaLaaR HuSyN, Coming back with another Video, In this tutorial we'll learn how to Export DataGridView Data to Ms Excel File in Visual C# ..
Background Music Link:
+++++++++++++++++++++++++++++++++++++++++++
Download DLL File:
github.com/SaL...
++++++++++++++++++++++++++++++++++++++++++++
For Source Code Please Visit My Github Profile:
github.com/SaL...
++++++++++++++++++++++++++++++++++++++++++++
For Android Ui Tutorials, Please Subscribe Our Channel Android Ui Academy:
/ @androiduiacademy6689
++++++++++++++++++++++++++++++++++++++++++++
if You Have any Query, feel free to contact Us on Facebook:
/ csharpuiacademy
++++++++++++++++++++++++++++++++++++++++++++
Please Subscribe for more Videos

[@CatatanHarian]

Nice tutor sir. I wait for how to import excel file to datagridview, and then import to database too. (Mysql)

[@bekindhavepassion3649]

Hello! Thank you, it's cool! Can You be so kind to make a tutorial on how to export data from a form to a googlesheet? It'd be great!

[@joaquinbargiela7134]

Can't find DLL file in github, any clues?

[@حسينابراهيمعبدالرسول]

thank you very very very very very very very very very very very very very very very very much

[@michaelnotarte2980]

thank for the tutorial its very helpful but i have problem when exporting to excel it only exports the data not the header

[@imoleayoemmanuel5278]

C# Ui Academy is a blessing to us... sir can you please guide us on how to create a client server installation for a finished Desktop app... in which the client computer will also use the server database

[@abhiksingh1999]

Sir, I'm stuck. Please help. I didn't find the Rows. Count in my case. It's showing the wavy red line. So how do I traverse through each row?

[@ArtMeeron]

Hi, on 42 row you write in the end "... Value.ToString();" but when I try to repeat the same, the "Value" doesn't automatically put there and afterwards is says that - "Error CS1061 'TableCell' does not contain a definition for 'Value' and no accessible extension method 'Value' accepting a first argument of type 'TableCell' could be found (are you missing a using directive or an assembly reference?)" Do you know what it could be?

[@irriirri6924]

решил проблему?

[@mscotthowell1]

Thanks. This works the way I am used to it, instead of using the new clusterf*** jquery datatables crap; you miss one $ or { or . or [ or ( or what have you break the page. End to end Microsoft solution rocks.

[@bereketsiz]

Thanks bro. It worked very well for me. Bless your hands.

[@mouetteblanc331]

how to import to datagridview data to excel file in c# ? thanks for this video bro

[@RashiCode]

Nice Sir g

[@prosaa9168]

i have a System.NullReferenceException: 'Object reference not set to an instance of an object.' can you fix it for me ? please, thank you

[@marcstephencorpuz4804]

sir help. i have followed every code you did but im still getting error System.NullReferenceException: 'Object reference not set to an instance of an object.' the error im getting is at the Excelapp.Cells[i + 2, j + 1] = dataGridView1.Rows[i].Cells[j].Value.ToString();

[@ericdjemba9149]

true

[@lifeof_btbn7147]

thank you very much. Vietnamese with love

[@dunghn907]

haha :D

[@KhangNguyen-gd3tj]

hahaha, Bạn không cô đơn

[@Jordgubbe]

How do I make a listbox transparent? Please answer.

[@darienistornicolae7195]

Hello, i have a small problem here. xcelApp.Cells[i + 2, j + 1] = dataGridView1.Rows[i].Cells[j].Value.ToString(); Error: System.NullReferenceException: 'Object reference not set to an instance of an object.' I mention that i use 5 columns and you introduce the data manually and after it you can export it to Excel

[@吳鈎-b1q]

Very Nice...

[@farappxtrem3788]

Kindy tell how to save pictures in database and how to publish winforms applications

[@javadjamshidi3399]

Excellent 👌

[@mehribannasibzade1756]

Hi, How can i do it with devexpress grid control? Because no row here

[@naufalez]

please make tutorial for export big data like 100K-200K row to excel

[@PANandhakumarR]

Please post video about how to design attendance page in c#(windows form application) with data base ms access

[@abdulilahelnagme164]

thank you very much

[@Iraqi_Officer]

If datagridview have arabic data ? I wont export as arabic layout

[@zozmoz8067]

hello I did all what you do , but i get message said "Object reference not set to an instance of an object. " in the line code : xcelApp.Cells[i + 2 , j + 1] = dataGridView1.Rows[i].Cells[j].Value.ToString(); could any one helps me please

[@muhammadafzal237]

bro which one is the reference file on your site, I didn't found..!

[@rayanhalabi6742]

How to saveAs in my project Files after build the excel file?

[@asifuddin6364]

System.Runtime.InteropServices.COMException: 'Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80040154 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)).'

[@TheOussamaess1958]

Very Nice thx pro

[@georgealbo]

dear sir do you iam doing the same code but the out is out of order

[@benjcastelo]

Sir, the exporting of data will become slow depends on how many rows that the datagridview has. Is there any other way you can show us how to export data faster? Thanks in advance! Looking forward to your response.

[@marcol5374]

Benjie Castelo use a task to do it and show the status of the operation UI 😃

[@srmback]

if you get an error do not forget to type the Value as Value?. the whole code looks like this: if(dataGridView1.Rows.Count > 0) { Excel.Application excelApp = new Excel.Application(); excelApp.Application.Workbooks.Add(Type.Missing); for(int i=1; i < dataGridView1.Columns.Count + 1; i++) { excelApp.Cells[1, i] = dataGridView1.Columns[i - 1].HeaderText; } for(int i=0; i < dataGridView1.Rows.Count; i++) { for(int j=0; j < dataGridView1.Columns.Count; j++) { excelApp.Cells[i + 2, j + 1] = dataGridView1.Rows[i].Cells[j].Value?.ToString(); } } excelApp.Columns.AutoFit(); excelApp.Visible = true; }

[@andreharington2600]

Worked like a charm

[@desgbtv5733]

Nice

[@rabbi7rabbi763]

Is it possible to do it from excel file to dataviewgrid ? (im trying to do one application but the excel file have to much informacion to write it one by one (like 5000+ rows....) Can you help me pls :D

[@jonathanross9001]

As I know, you can import excel to database and from database to datagridview maybe you did find a better way after two years :D If you did, can you share with me too?

[@RashiCode]

Very help full thank You very much

[@abrahameduardoordoricaisla9103]

Very simple, thanks so much!

[@trungtruong1888]

great

[@TheGeardarko]

Gracias, buen tutorial

[@Ramdhani03]

i can't fine .dll in your github :(

[@aaj3078]

The best thanks!

[@alviyudha]

thanks, you are my hero

[@NHGeneral]

Hello, can you help to write data to excel file template?

[@ishtiaqhussain4370]

im getting error on this line plz help.....xcelApp.Cells[i + 2, j + 1] = dataGridView1.Rows[i].Cells[j].Value.ToString(); error:( nullReference Exception: 'Object reference not set to an instance of an object.' )

[@bleonmurtezaj1849]

same

[@VTOhr]

On "dataGridView1" set property "Allow user to add rows" to false - this will remove extra blank row from bottom of dataGrid, and Your code will work.

[@shaikhsaalim3532]

Thanks its working

[@ridanorani8623]

@@VTOhr thankss

[@netrakoirala1]

That's good

[@آراۓشان]

Nice :-)

[@Iraqi_Officer]

How i can export to pdf

[@martinantoniodejesuslopezm4883]

Thank you

[@Ahmed95406]

background music link please?

[@LP-di1vu]

Thanks again!

[@katrykonig2466]

It wouldn't work if there is a combox inside the DG

[@clanlocos]

se repite el valor de la primera columna en todo mi excel =(

[@lieusedie5499]

спс мужик

[@rafliiskandarkavarera2886]

what happen if client doesnt have excel?

[@tonyyhawk7554]

Thankyou so much ♥♥♥

[@farappxtrem3788]

I'm not able to download DLL file

[@dduRTV]

How can i export to excel with image?

[@farappxtrem3788]

I've the same question, pls let me know if you got the ans.. ty

[@asifuddin6364]

i am getting this error

[@StevulaDodoonline]

how to export to xml?

[@fonzimodev1272]

this.dataset.tabelname.WriteXml("file.xml")

[@ankita302]

Someone explain me that for loop😭

[@LEXKAY02]

???

[@BrunoOliveira-tb3xk]

Thank you so much

[@ddmspeedheat4416]

thank you so much

[@phatlengoc9934]

Thank you so much