How to export datagridview to excel in c# windows application

and in this video we will discuss how to export Excel from data grid view so let's start we create a Windows application the selector windows application and then rename it dot a great export click - ok now this window is project is created now in first step we will add a data grid from this data system and drag and drop to our workspace we remove it for adding and then bind that data give to form database I already created a table for this we select a database test click to next and you can change your connection string name here and that can clearly driving a database information here we selected table for example I select that this TBL registration and click to finish now that data grid will bind from database cable we spent there with now we take a button for exporting question and we also add one more reference for exporting data gradient Excel Microsoft Excel object 15.0 to use the video studio 2017 then it's then exploring a Microsoft Excel 16.0 credibly I use a V or sugarcoat on 13 so it's showing visuals to Microsoft Excel 15.0 so search the other Microsoft Excel 15.0 click - ok now we code for Excel for exporting Excel form data credit link to that button code and this right here a code for exporting data gateway objection Microsoft dot office dot interro power texture dr. vacation which will - Oh new Microsoft go out intro Microsoft auto v dot dot Excel dr. application Microsoft duo topics Rock intro we are a creator object F the gating of Microsoft Excel F and here we can get a subtext text not here we create a log book equal to F we creating a data Excel workbook workbook book we add ever booked into this section we object applet so letting the type dot missing type or sneaking and we also add a box seat so Microsoft dot dot dot works it works it is equal to now we creating an object for this now we get a it box it equal to work workbook dot sleep may provide a meaningful name let's just eat one and we activ that you want to book dot dot active gate and we provide above system sweet dot name equal to customer detail now we add a column header text to that exit I the type messing is one object column index is 1 inch equal to dot a gradient column I minus 1 dot add a text we add a header text into this worksheet now we add a Rose for this not already go down to Rose . to count count and we add one more rope on this column count maybe here wait about six dot cells I plus 2j plus one it's a row index and it's a column X is equal to dot a great dot to DRI totals J values dot dot dot strings now we save that excel in your computer so is the save file dialog is equal to new a dialogue dialogue dot file name replied of meaningful name like on output and we set a default extension for this and dot xlsx if a save dialog taught us to log is equal to dialogue result then log book tour tables now save as all save of Excel report yes save dialog go to file name which the file format file format is already edit so we added type dot missing Oh Pete its password is missing the right password in read-only recommended now create backup now and will be a data access mode so Microsoft dot dot dot n Rho dot texas dot XLS save mode physics is node dot X dot exclusive and let's say concrete regeneration is missing and what is the thing coverage everything and text visual layout anything and local in also nothing you know we keep that up now all it's done click to start now you will succeed now we click to export I think something is now now run so save that excel file into desktop is already so replace it so click now we go to desktop that exporting all the records into that excel I think something is missing header is not added so well / - hi - a detached we need to check this here in this section we create a problem we can give one for pro index and this for column index now we again and click to export English 970 the show now working correctly so thanks for watching if you have any question please write in the comment box I will reply you soon so thanks for watching please subscribe my channel

Channel: Csharp Space

Views: 54,989

Keywords: How to, export datagridview, datagridview, csv, c#, windows application, c# tutorial, datatables, excel, convert into excel, office, microsoft, windows, file, gridview, form, csharp, interop, export, datagridview c#, datagridview in c# windows application, exporting, export into excel

Id: YfcasWYaIzo

Length: 16min 29sec (989 seconds)

Published: Wed Mar 22 2017