C# Tutorial - How to Export DataGridView To Excel File | FoxLearn

[@michalismichael7666]

Can you make an example for export database table to excel using C# (ClosedXML)

[@boborahimyuldashev9346]

Hello teacher. I don’t want to explore the DataGridView features: please. Thank you so much

[@damionreid3164]

Awesome. was able to successfully integrate this to my existing vb code

[@foxlearn]

Thank you :)

[@DavidHays205]

Awesome. Thanks for uploading these!

[@foxlearn]

Thanks :)

[@DavidHays205]

Can you take a look at my code and see what I am doing wrong? Once the save dialog opens and I hit save it just closes and does not create a new file.... github.com/Flyhalf205/CallLog

[@geminian091]

In my case i am getting error in it when we are loading form using database db with data source and ToList() thing . An unhandled exception of type 'System.ArgumentException' occurred in System.Data.Entity.dll Additional information: The specified store provider cannot be found in the configuration, or is not valid. Kindly help how to sort out. Thanks

[@انامسلموكفى]

how i can check if the Sheet i empty or not . i ve used the Excelreader thak you so much

[@foxlearn]

Do you want to check data in sheet? is that right?

[@hafizoktri3847]

I followed all your steps and instruction but nothing is working after the Save As dialog is closed. any idea?

[@foxlearn]

Please check your code again. i think you missing something. Thank you !

[@pantrapan3995]

Хотелось бы увидеть отчеты с использованием ReportViewer :D

[@foxlearn]

Thank you for your suggestion :)

[@TopVideos.Talent]

why can't you open it directly with excel? There comes message yes or no in excel

[@alannunez3999]

Hi! I can't see the table I called from my DataBase in the "model.edmx" Help please!!

[@gastonramirez2634]

Very good this video!!!!

[@foxlearn]

Thank you

[@thanhlecotuong4813]

thank you very much :)

[@foxlearn]

You're welcome. Thank you !

[@punzalanmichael9697]

i got an error using the name Interop. in Microsoft.Office.Interop.Excel. please help. how to fix. Thank You. :D

[@foxlearn]

Please add a reference to Microsoft.Office.Interop.dll

[@punzalanmichael9697]

@@foxlearn now that i fix the interop error. now the name "Application" in Microsoft.Office.Interop.Excel.Application is error. i search on how to fix it but i got a lot of new error. please help

[@punzalanmichael9697]

Severity Code Description Project File Line Suppression State Error CS0433 The type 'Application' exists in both 'Microsoft.Office.Interop.Excel, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' and 'Microsoft.Office.Interop.Excel, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c'

[@punzalanmichael9697]

nevermind hahah i already fix it :D thanks by the way

[@foxlearn]

That's great. Thank you my friend !

[@singhsahab8117]

Please give me guide how i make sum of data grid column value

[@foxlearn]

OK. Thank you for your suggestion. I'll upload soon !

[@singhsahab8117]

@@foxlearn thanks One more how add item in combobox using access data in visual basic if recently uploaded this kind video then please provide link Thanks

[@sakrkokymohamed3049]

I have this error "System.NullReferenceException: 'Object reference not set to an instance of an object.' list was null." in this step int process = list.Count;

[@foxlearn]

Please check your code again. i think you miss something

[@sakrkokymohamed3049]

private void BackgroundWorker_DoWork(object sender, DoWorkEventArgs e) { List list = ((DataPrameter)e.Argument).tblMasrofs; string fileName = ((DataPrameter)e.Argument).fileName; Microsoft.Office.Interop.Excel.Application execl = new Microsoft.Office.Interop.Excel.Application(); Workbook wp = execl.Workbooks.Add(XlSheetType.xlWorksheet); Worksheet ws = (Worksheet)execl.ActiveSheet; execl.Visible = false; int index = 1; //if ((list != null) && (!list.Any())) //{ int process = list.Count; ws.Cells[1, 1] = "price"; ws.Cells[1, 2] = "date"; ws.Cells[1, 3] = "masrof"; foreach (tblMasrof p in list) { if (!backgroundWorker.CancellationPending) { backgroundWorker.ReportProgress(index++ * 100); ws.Cells[index, 1] = p.price.ToString(); ws.Cells[index, 2] = p.date.ToString(); ws.Cells[index, 2] = p.masrof.ToString(); } } // Add new item // list.Add(list.Count""); //} 　 　 　 ws.SaveAs(fileName, XlFileFormat.xlWorkbookDefault, Type.Missing, Type.Missing, true, false, XlSaveAsAccessMode.xlNoChange, XlSaveConflictResolution.xlLocalSessionChanges, Type.Missing, Type.Missing); execl.Quit(); 　 }

[@Videoman2102]

2:42 why my table didn't appear?

[@nachiketsg7116]

Hi, I am using SQL Data Adapter for getting values in data grid view. Below is my sample code. But when I am using your code for exporting it is not working. can you please tell me what are the changes required? SqlConnection con = new SqlConnection(); con.ConnectionString = "Data Source=SINDT0271;Initial Catalog=3032017_RDB;Integrated Security=True"; con.Open(); //PipingCommodityFilter SqlDataAdapter PCFsda = new SqlDataAdapter("SELECT * From Table); DataTable PCFdt = new DataTable(); PCFsda.Fill(PCFdt); metroGrid1.DataSource = PCFdt;

[@madoubar5346]

I do not appreciate this video, because you did it so quickly that is extremely difficult to understand how do you did it. Your curse urges is not controlled. Thank you for your time but it's not helpfully.

[@hmamoun]

I agree that it is a bit fast, but this is a plus, I paused the video to follow, however, it would be useful to include the source code

[@kevinmungame1869]

No one understood what you are doing. What's the purpose of the video, everyone is asking for source code???

[@foxlearn]

Export data to excel