How to export datagridview to excel in c# windows application

thanks man!

Thank You So Much....

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.'

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

Thank you very much, it worked!

Nice Tutorial. Thanks a lot.

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

how to export only checked rows if there is checkbox

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

thank you for this video

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

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

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

Excellent video but it doesn't work for me, I got this message: Recupero della class factory COM per il componente con CLSID {00024500-0000-0000-C000-000000000046} non riuscito a causa del seguente errore: 80040154 Interfaccia non registrata. (Eccezione da HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)).

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

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 :)

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

I made it. Thanks bro.😍👍

Thank you so much , it worked :)

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

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.

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

the code is not correct.

It works thank you, bro!!

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!

Thank you so much for this tutorial
(^-^)

Ottimo good

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

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

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' "

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?

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?

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

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

Thanks

System.BadImageFormatException: 'Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 800700c1 is not a valid Win32 application. (Exception from HRESULT: 0x800700C1).'
I'm getting this error please help

saves only 4 rows?

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

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))".

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

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();"

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!

sound lvl is not very loud

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

Thank you very much!!

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