Import Excel data to Database by creating table from code behind in ASP.Net Core

Question

Hi Siri want to upload excel file from ui and save that data in sqlcreate table with excel name and create all column in sql of excel header and save the data of excel in table using aspnet coreif any link or help me in this

pandeyism · Accepted Answer

Hi  telldurgesRefer below link for file uploadhttpswwwcsharpcornercomarticleuploaddownloadfilesinaspnetcore20And after file upload use below code for reading file and save to databseNamespacesCusing SystemIOusing SystemDatausing ClosedXMLExcelusing SystemConfigurationusing SystemDataSqlClientVBNetImports SystemIOImports SystemDataImports SystemCollectionsGenericImports ClosedXMLExcelImports SystemDataSqlClientCodeCprotected void ImportExcelobject sender EventArgs e    string query  3434    string filePath  ServerMapPath34Files34  PathGetFileNameFileUpload1PostedFileFileName    FileUpload1SaveAsfilePath    using XLWorkbook workBook  new XLWorkbookfilePath            IXLWorksheet workSheet  workBookWorksheet1        DataTable dt  new DataTable        bool firstRow  true        foreach IXLRow row in workSheetRows                    if firstRow                            query  34IF

dharmendr · Answer

You have to use the C code in your net core codeOnce you read the posted file using ClosedXML library read the excel fileBy reading first row generate the table to create in database and the Datatable columnsThen looping through other row cell value add the record to datatable and finally using SqlBulkCopy insert all the recor dto the database table

Import Excel data to Database by creating table from code behind in ASP.Net Core

Company

Explore

Follow us

Contact Us