VB.NET Tutorial - How to Export DataGridView to excel | FoxLearn

welcome to foxlearn in this tutorial i'll show you how to export data from datagridview to excel file in visualbasic.net using closed xml after you finish creating the new window form project you need to open your form designer and then drag button and data grid view controls from the visual studio toolbox into your form designer [Music] select your data grid view if your project does not already have a data source click add project data source and follow the steps indicated by the wizard in this tutorial i will use the northwind database for practice if you don't have the northwind database you can download it from the foxlearn [Music] website [Music] next right click on your project then select manage nudget packages you need to select the browse tab then search and install closed xml to your project closed xml is a great excel library for reading manipulating and writing excel 2007 files it aims to provide an intuitive and user-friendly interface to dealing with the underlying open xml api next add a click event handler to the export button that allows you to export data from data table to an excel file you can use the save file dialog class to help you open a save file dialog allows you to enter the file name and don't forget to use try catch to catch errors if something goes wrong [Music] you should put the code in the dry catch block we will use excel workbook class to export data from data table to excel [Music] file [Music] we will get data from the products table in the northwind database then display the data on the data grid view [Music] you can use the copy to data table method to copy the data into the data table and then write data to an excel file using the closed xml library [Music] [Music] [Music] [Music] [Music] do [Music] do [Music] [Music] [Music] [Music] thank you for watching this video and don't forget to subscribe to my channel

Channel: Fox Learn

Views: 35,889

Keywords: foxlearn, vb.net, .net, visual basic .net, export datagridview to excel in vb.net, winforms vb.net, vb.net tutorial, create excel in vb.net, export datatable to excel in vb.net, vb.net export to excel, vb.net export datatable to excel, vb.net export gridview to excel, vb.net export sql data to excel, export data to excel vb.net, export data grid to excel vb.net, closedxml, vb.net closedxml, vb.net closedxml datatable, closedxml vb net example, closedxml vb.net excel, vb.net excel

Id: 7E5F6XPDOkY

Length: 7min 43sec (463 seconds)

Published: Fri Dec 11 2020