import excel sheet into database

Shyam Kumar Guduru

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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mageshwaran R6y ago
Hi,
Please refer the below link, it might helps you
https://www.c-sharpcorner.com/blogs/export-to-excel-using-epplus1
0
Sapna Girish7y ago
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
0
Sonu Gupta7y ago
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
0
Ramesh Palanivel7y ago
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/
0