How to export datagridview to excel in c# windows application

Here I will explain how to export datagridview to excel in c# windows application. Export datagridview to excel with column headers.C# datagridview export to excel with formatting
~-~~-~~~-~~-~
Please watch: "How to Perform Global Exception Handling in ASP.NET CORE MVC"
• How to Perform Global ...
~-~~-~~~-~~-~

[@vietthole7217]

I made it. Thanks bro.😍👍

[@alawal_kabir]

Nice Tutorial. Thanks a lot.

[@jackhuynh9847]

Thank you very much, it worked!

[@alejandromonroy8726]

Thank you so much , it worked :)

[@motivation9822]

My program is giving me an error on this line Pdftable.AddCell(new Phrase(Cell.Value.ToString(),text)); Its saying Object reference not set to an instance of an object

[@KaS95PeR]

thanks man!

[@WhiteCoder]

Thank You So Much....

[@thonginh5082]

thank you for this video

[@nadunsilv]

It works thank you, bro!!

[@radhikagharote1261]

Only the the first column name is visible other columns are not visible But the rows are visible

[@pauloherculano9243]

Hey Bro, I'm having this issue "System.NullReferenceException: 'Object reference not defined for an instance of an object. System.Windows.Forms.DataGridViewCell.Value.get retorned null." in this line "worksheet.Cells[i+2,j+1] = produtoDataGridView.Rows[i].Cells[j].Value.ToString();" Could you help me pls?

[@radhikagharote1261]

Same here . If you have found the solution please let me know

[@shujanaqvi2668]

@@radhikagharote1261 anyone found it?

[@radhikagharote1261]

@@shujanaqvi2668 try this for loop: For(int i = 0; i

[@shujanaqvi2668]

@@radhikagharote1261 oh its working thank you

[@tanasitlikitchol5170]

@@radhikagharote1261 it works, thank you

[@rasulvalipoor7125]

It was greatly explained, thank you, how we use border on it

[@mahmoudalhussain9291]

thanks for ur video , can u explain why you use type.missing more than one time ?

[@ga7853]

The Sound is very low, could not hear you even with my volume so high, you should play it yourself and see if you can hear it, but I was able to follow because the video was clear and you moved the mouse reasonably to follow.

[@CsharpSpace]

Sorry for slow volume but now in my new videos volume is clear

[@philipharrisona4496]

worksheet = workbook.Sheets["Sheet1"]; worksheet = workbook.ActiveSheet; error in these lines Error 1 Cannot implicitly convert type 'object' to 'Microsoft.Office.Interop.Excel._Worksheet'. An explicit conversion exists (are you missing a cast?) C:\Users\Dhivya\Desktop\FaceRecProOV\MakeRegistered.cs 105 25 MultiFaceRec

[@liga_production]

worksheet = workbook.Sheets[1]; Hope will help

[@Ram7188]

@@liga_production I am facing the same issue but it not resolve yet. worksheet = workbook.Sheets[1]; worksheet = workbook.ActiveSheet;

[@liga_production]

@@Ram7188 hello. you may have already solved this problem, but here is my code. And it worked. (sry for my English. Check the code in the next post.)

[@liga_production]

@@Ram7188 if (dataGridView1.Rows.Count > 0) { Microsoft.Office.Interop.Excel.Application xcelApp = new Microsoft.Office.Interop.Excel.Application(); Microsoft.Office.Interop.Excel.Workbook workbook = xcelApp.Workbooks.Add(Type.Missing); Microsoft.Office.Interop.Excel.Worksheet worksheet = null; worksheet = workbook.Sheets[1]; worksheet = workbook.ActiveSheet; worksheet.Name = "CustomerDetail"; for (int i = 1; i < dataGridView1.Columns.Count + 1; i++) { worksheet.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++) { worksheet.Cells[i + 2, j + 1] = dataGridView1.Rows[i].Cells[j].Value.ToString(); } } xcelApp.Columns.AutoFit(); var saveFileDialoge = new SaveFileDialog(); saveFileDialoge.FileName = "Вывод"; saveFileDialoge.DefaultExt = ".xlsx"; if (saveFileDialoge.ShowDialog() == DialogResult.OK) { workbook.SaveAs(saveFileDialoge.FileName, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing); } xcelApp.Quit(); }

[@simoneesposito2293]

Ottimo good

[@Tigrandav]

Thank you for video, how can I expoert excel from datagridview with formating.

[@MrLongAnimations]

Thank you so much!! But you have video :"How to import excel to datagridview in c# windows application" ?

[@noppawinsrikulchayanan3395]

Thank you very much!!

[@CsharpSpace]

+Noppawin SRIKULCHAYANAN welcome

[@nguvanbachhoa3547]

I have problem in these lines: XLSaveAsAccessMode error : The type or namespace name 'XLSaveAsAccessMode' does not exist in the namespace 'Microsoft.Office.Interop.Excel' (are you missing an assembly reference?) CAN YOU HELP ME!

[@CsharpSpace]

You need to add this reference(Microsoft.office.interope.Excel )in your project .

[@techlife97415]

worksheet.Cells[i + 2, j + 1] = dataGridView1.Rows[i].Cells[j].Value.ToString(); in here it says below problem. System.NullReferenceException: 'Object reference not set to an instance of an object.'

[@CsharpSpace]

I think no data is present at this row and cell in dataGridView, So this error may occurred

[@novifadhilah_f1411]

you can change it to --------> Convert.ToString(worksheet.Cells[i + 2, j + 1] = memberDataGridView.Rows[i].Cells[j].Value);

[@moxmed5539]

how to export only checked rows if there is checkbox

[@King-Merlin]

Hi iwanted to ask, is this also compatible with WPF gridview in C#

[@kshitijsaxena8272]

How to append the excel sheet data if excel is already existing

[@sheetalkedar1156]

i want to save image to excel sheet using c# . any solution????? plz help ...!!

[@surajshinde9258]

Thanks

[@ganeshgavali9971]

Exception thrown: 'System.ArgumentOutOfRangeException' in mscorlib.dll

[@reubenmwangikibara4434]

very great channel... would you minf helpin in exporting to pdf

[@CsharpSpace]

ok I will upload in next video

[@marlondumdumaya3409]

hello, Im having a problem int the codes, "Object reference not set to an instance of an object." in "sheet.Cells[i + 2, j + 1] = dataGridView1.Rows[i].Cells[j].Value.ToString();"

[@CsharpSpace]

+Marlon Dumdumaya I think something is missing in your code, try to debug your code with breakpoint

[@marlondumdumaya3409]

hello, my codes is now running, I just unchecked the properties of datagridview1 (enable delete, enable editing, enable adding) thats all. Thank You for reply :) have a good day

[@marlondumdumaya3409]

but another question, Can I add a progress bar on it? progress bar will serve as the process of exporting

[@fadyemad5345]

@@marlondumdumaya3409 thanks you helped me

[@CsharpSpace]

Welcome

[@user-xg7hi5mh3g]

thank you so much ,how i can check if the Sheet is empty or not

[@CsharpSpace]

you can can count rows when you export excel.

[@muhammadresturamadhan6129]

my project is problem with the error code is : An unhandled exception of type 'System.InvalidCastException' at here > Microsoft.Office.Interop.Excel._Workbook workbook = app.Workbooks.Add(Type.Missing); can you fix this problem as soon as possible ... thanks for ur tutorial :)

[@user-ff1vr4bf9g]

what is wrong System. Argument Out of range Exception ?!

[@cybelmaloon8397]

Sir, I have this error could you lend me a hand for this error "System.ArgumentOutOfRangeException: 'Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index' "

[@CsharpSpace]

I think your have loop that goes outside datagrid view total column length

[@cybelmaloon8397]

@@CsharpSpace Thanks a lot sir i already notice the error :D

[@cybelmaloon8397]

and I already solve it thanks a lot to this video.

[@lahcenjaber9901]

@@cybelmaloon8397 how do you slove it beo i have the same problem and i can't fix it

[@md.nurulhuda9752]

Do I can show a preview instead of direct save dialogue????

[@aitezazbilal3796]

You can use the function app.visible = true, which will open the excel file without saving it. No need to do save dialogue part.

[@martylofttv4871]

Hello, i have a problem. Where can i find the Microsoft Excel 15.0 Object Library. I'm using C# 2010 Express. My system has error. It says, Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX)) and the other one is Check the error code properly of the exception to determine the HRESULT returned by the COM object. Please help me. Thank you!

[@CsharpSpace]

+samartino sta maria right click on reference and click to add reference and then it will popup reference manager, her you will select COM tab and select libraries now here you can find Microsoft Excel 15.0 Object library

[@martylofttv4871]

Csharp Space i already click it but there is no microsoft excel 15.0 object library. I tried the other like microsoft office 15.0 object library but still the error is the same. If i dont have microsoft excel it is posible to download it? I look one by one into my COM but there is no microsoft excel sir. I hope you can help me. Thank you very much.

[@CsharpSpace]

Check this link for reference : www.codeproject.com/Questions/587538/Howplustoplusaddplusmicrosoftplusexcelplus-plus

[@martylofttv4871]

Csharp Space Ok, thank you very much

[@CsharpSpace]

+samartino sta maria welcome

[@KeijiJohnLibadisos]

no microsoft.office in my VS

[@rzikiyassir7402]

thank you so much for this video please i want import information from Excel to my database can you help me please and thanks again

[@CsharpSpace]

yes how can I help you?

[@rzikiyassir7402]

I have a file Excel filled with information and I would like to import this information to my database reverse what you've done in this video

[@CsharpSpace]

You can find step to step description and Source code here: tutorialslink.com/Articles/How-to-import-excel-data-in-MS-SQL-server-database-in-Aspnet-MVC/1

[@rzikiyassir7402]

thank you so so much, i wish you success (y)

[@CsharpSpace]

welcome

[@yeremiawijaya7456]

why when i close the app it didnt stop debug??

[@CsharpSpace]

I think app is still running in background

[@GoodGuy374]

if you try to overwrite the name on same folder, it will show rewrite warning twice. :(

[@CsharpSpace]

ok I will check

[@toratoura3]

the code is not correct.

[@luisafernandapinedadelaoss2173]

hola tengo un ERROR en esta linea de codigo HELP sheet.Cells [i + 2, j + 1] = dataGridView1.Rows [i] .Cells [j] .Value.ToString ();"

[@lrobertj]

LUISA FERNANDA PINEDA DE LA OSSA tengo en mismo problema, pudiste corregirlo

[@luisafernandapinedadelaoss2173]

si correo y envio codigo completo

[@adamdante11]

I have the same error, can you send me a correct code?

[@tanitalu]

[e-mail] no logro arreglar esta linea, favor ayudame :(

[@juliocampos8085]

luisa responde por aca para que todos los que tengan ese error puedan solucionarlo

[@richardmelvingarcia771]

saves only 4 rows?

[@CsharpSpace]

no this fetch all rows from datagridview

[@juanfernandezbernt9105]

i have the same issue, only 4 rows are shown

[@mirzamehran4017]

@@CsharpSpace why

[@TheWebjunky007]

sound lvl is not very loud

[@McNabbhead]

Funny, I was thinking it was too quiet, especially because I had to turn the volume up after the ad that showed beforehand.

[@TheWebjunky007]

D1D2 i ment not very loud

[@sarimkhan9459]

Can you tell me how to save the file directly to desktop through code?

[@CsharpSpace]

You can set path of your desktop location to output file

[@neyleencaraballo9398]

Thank you so much!!! But I need help with the next: " code : " worksheet = workbook.Sheets["Sheet1"];" present the next error"Additional information: El índice no es válido. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))".

[@egordavidovich7276]

you fixsed this bag?

[@guilhermequirino4593]

Use index instead: workSheet = workBook.Sheets[1];

[@Jvkomusic]

Lo resolviste?

[@shehzadbhatti1361]

Hey Bro, I'm having this issue "System.NullReferenceException: 'Object reference not defined for an instance of an object. System.Windows.Forms.DataGridViewCell.Value.get retorned null." in this line "worksheet.Cells[i+2,j+1] = produtoDataGridView.Rows[i].Cells[j].Value.ToString();" Could you help me pls?

[@shehzadbhatti1361]

i found the error thanks

[@CsharpSpace]

try to debug the code and find the value for i variable, I think it going outside range.

[@user-zx5pm2rv4h]

@@shehzadbhatti1361 how u solved, tell me?

[@ShalukaHettiarachchi]

@@user-zx5pm2rv4h try this for second for loop -> for (int i = 0; i < dataGridView1.Rows.Count-1; i++)