Export data from SQL Server to Excelusing C# and VB.Net in Windows Forms Application

Question

SirI have used your code on Export data from SQL Server to Excel in ASPNet using C and VBNetNow I want to use it in our windows project so please provide me the modified codeThanks

dharmendr · Accepted Answer

Hi  raiamitRefer the below sample code For this you have use OpenXml and ClosedXml libraryYou can download the libraries using the following download locationsDownload OpenXml SDK 20Download ClosedXml LibraryCprivate void btnExportToExcelClickobject sender EventArgs e    DataTable dt  new DataTable    string constr  ConfigurationManagerConnectionStrings34constr34ConnectionString    using SqlConnection con  new SqlConnectionconstr            using SqlCommand cmd  new SqlCommand34SELECT TOP 10  FROM Customers34                    using SqlDataAdapter sda  new SqlDataAdapter                            cmdConnection  con                sdaSelectCommand  cmd                sdaFilldt                            string folderPath  34CUsersdharmendraDesktopTest34    if DirectoryExistsfolderPath            DirectoryCreateDirectoryfolderPath        using XLWorkbook wb  new XLWorkbook            w

dharmendr · Answer

raiamit sayswbSaveAsstrLocation  testReportxlsx Change the above line with the belowwbSaveAsstrLocation  3434  34testReportxlsx34

Export data from SQL Server to Excelusing C# and VB.Net in Windows Forms Application

Export data from SQL Server to Excel in ASP.Net using C# and VB.Net

Company

Explore

Follow us

Contact Us