Hello friendssince i am new to programming world i am facing the issue that how can i save the excel data which is in below format to a table having the below strucureexcel data 91320189142018915201891620189172018productionorder3022221STN1STN3STN4STN53022222STN1STN2STN3STN4STN53022223STN1STN2STN3STN4STN53022224STN1STN3STN4Table Structurecolumn namedatatypeIDintproductionordernvarchar50stationidnvarchar50tocreationdatedatetimecould you all please help me out thanks alot

Read and Import Excel column as row to database in ASP.Net

KhaliqEP...

SOLVED CLOSED ACTIVE ANSWERED
User: KhaliqEPS
Posted: on Sep 11, 2018 01:34 AM
Forum: ASP.Net Web Forms
Replies: 5
Views: 4649
Sample Code: Download

Hello friends,

since i am new to programming world, i am facing the issue that how can i save the excel data which is in below format to a table having the below strucure.

excel data.

	9/13/2018	9/14/2018	9/15/2018	9/16/2018	9/17/2018
productionorder
3022221	STN1	STN3	STN4	STN5
3022222	STN1	STN2	STN3	STN4	STN5
3022223	STN1	STN2	STN3	STN4	STN5
3022224	STN1	STN3	STN4

Table Structure.

column name	datatype
ID	int
production_order	nvarchar(50)
station_id	nvarchar(50)
to_creation_date	datetime

could you all please help me out. thanks alot.

Download FREE API for Word, Excel and PDF in ASP.Net

KhaliqEP...

0 4

Reply
User: KhaliqEPS
Replied: on Sep 11, 2018 02:10 AM
Report

thanks i will follow the link.

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Read and Import Excel column as row to database in ASP.Net

Company

Explore

Follow us

Contact Us