import excel sheet into database

Question

is there any possibilities regarding import excel sheet into database with different formats(means multiple grids or diffrent table format in single sheet with different table format) in .net.

Is there any code for excel cell wise import to database.

Sale Buildings
Tower	Configuration	IOD	CC	Constructin status
test	test	test	test	test
test	test	test	test	test
test	test	test	test	test

Project Name	Carpet Area	Sale Area	Construction Area	Sale:Carpet Area Loading	Construction:Sale Area Loading
test	test	test	test	test	test
test	test	test	test	test	test
test	test	test	test	test	test

Tower	RCC Completion	CFO Ready	OC Ready	Remarks
test	test	test	test	test
test	test	test	test	test
test	test	test	test	test

Mageshwaran R · Answer

Hi, Please refer the below link, it might helps you https://www.c-sharpcorner.com/blogs/export-to-excel-using-epplus1

Sapna Girish · Answer

Hi,you may try Spire.XLS library. It supports to select the cell range while exporting data from excel to datatable. Here is the code snippet for your reference. using Spire.Xls; using System.Data; namespace ExcelToDatatable { class Program { static void Main(string[] args) { //Create a Workbook object Workbook workbook = new Workbook(); //Load an Excel file workbook.LoadFromFile( "data.xlsx" ); //Get the first worksheet Worksheet sheet = workbook.Worksheets[0]; //Export data from a choosen cell range to datatable DataTable table1 = sheet.ExportDataTable(1, 1, 3, 3, false ); DataTable table2 = sheet.ExportDataTable(4, 4, 7, 7, false ); } } } also refer to: https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Excel-Import/Export-Import-Data-from-Excel-to-Datatable.html

Sonu Gupta · Answer

Hi, Visit the below URLs - https://www.aspsnippets.com/Articles/Import-Excel-data-to-SQL-Server-Database-in-ASPNet-using-C-and-VBNet.aspx https://www.aspdotnet-suresh.com/2010/09/import-data-from-excel-to-sql-database.html https://www.aspsnippets.com/Articles/Import-Excel-data-to-SQL-Server-Database-using-Stored-Procedure-in-ASPNet.aspx

Ramesh Palanivel · Answer

Hi Shyam, Simply you can create model class as per your excel and bind the excel value into your model class and insert everything into database. That is the easist way you can do it. Please refer the below links. It might help you. http://www.omarelabd.net/generating-c-classes-from-excel/ https://sqlspreads.com/2017/05/04/how-to-insert-data-in-excel-to-sql-server/

import excel sheet into database

Answers (4)