import excel sheet into database -different formats in sheet

Shyam Kumar Guduru

7y763

is there any possibilities in .net(except mvc ) regarding import excel sheet into database with different formats in excel same sheet (means diffrent table formats in same sheet)

Is there any code in .net for excel cell wise data insertion into database in visual studio.

please find below sample formats in single excel sheet.

Help me with excel sheet insertion in same table or different tables.

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

2 Replies

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

Leon D7y ago
You can use Spire.XLS library to read data in excel sheet into datatable, and then insert the datatable to database.
//Load Excel file
Workbook workbook = new Workbook();
workbook.LoadFromFile(@”..\FandH.xlsx”);

//Get the first worksheet
Worksheet sheet = workbook.Worksheets[0];

//Read data in the worksheet to a datatable
DataTable dt = sheet.ExportDataTable();
More information, check this link:
https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Excel-Import/Export-Import-Data-from-Excel-to-Datatable.html
0
Jaimin Shethiya7y ago
Hello Shyam kumar,

can you please check the epplus library
please refer below link for that
1. https://stackoverflow.com/questions/36637882/epplus-read-excel-table
2. http://www.dotnet-tutorials.net/Article/read-an-excel-file-in-csharp
3. https://riptutorial.com/epplus/example/26603/import-data-from-excel-file
you have fetch rows wise data so can you prepare custom based set value to the our database model.

let me know if you have needed any other help.

Thanks
0