C# Tutorial - Creating/Writing to an Excel file with C#

welcome to foxlearn [Music] in this video i'll show you how to write data table to excel file using ep plus library in c-sharp after you finish creating the new windows forms 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] [Music] next right-click on your project then add an ado.net entity data model to your project i will use the northwind database to practice the demo if you don't have the northwind database in sql server yet you can watch the previous video on how to download and install the northwind database into sql server [Music] next add a formload event handler to your form that allows you to retrieve data from the customers table and then display the data into the datagridview control [Music] next right click on your project then select manage nudget packages you need to search and install eplus library into your project this is a great excel library that helps you read and write data to excel file it's currently a single dll and has no dependencies to any other library such as microsoft excel after installing ep plus library you need to add a configuration to app config file which allows you to run the library under non-commercial license [Music] 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] next you can use excel package class to help you write data from data table to excel file [Music] [Music] [Music] finally cast your data from the data grid view into the customer list and then write your data to an excel file and don't forget to copy your code inside the try catch block [Music] [Music] [Music] [Music] thank you for watching this video and don't forget to subscribe to my channel

Channel: Fox Learn

Views: 29,750

Keywords: c#, foxlearn, .net, c# epplus, epplus tutorial c#, c# create excel file, c# write to excel, c# write excel file, c# winforms, export datatable to excel c#, c# export datagridview to excel, c# export data to excel, epplus c# tutorial, epplus write datatable to excel, epplus write to excel c#, epplus, epplus create worksheet, export excel c# winform, c# tutorial, epplus export to excel c#, write excel, how to export datagrid view to excel in c#, epplus c# create excel file, how to

Id: iX3-9ES-TLM

Length: 8min 58sec (538 seconds)

Published: Tue Nov 17 2020