Loading

Import Excel Format on Asp.Net C#

Import Excel Format on Asp.Net C#

Ekrem Tapan

Ekrem Tapan

10y876.NET

Hi everyone,

How Can i import excel document to datatable like below format

excel table format

i`m using to "#" character seperate every part.

#CODE-1
A B C D E
Column1 Value Value Value Value Value
column2 Value Value Value Value Value
Column3 Value Value Value Value Value
column4 Value Value Value Value Value
Column5 Value Value Value Value Value
#CODE-2
Q W E R T
Column1 Value Value Value Value Value
column2 Value Value Value Value Value
Column3 Value Value Value Value Value
column4 Value Value Value Value Value
Column5 Value Value Value Value Value
Column6 Value Value Value Value Value
#CODE-3
A S F H V
Column1 Value Value Value Value Value
column2 Value Value Value Value Value
Column3 Value Value Value Value Value

after import to datatble datatable like below

CODE CAT TYPE VAL
CODE-1 A Column1 Valuue
CODE-1 A Column2 Valuue
CODE-1 A Column3 Valuue
CODE-1 A Column4 Valuue
CODE-1 A Column5 Valuue
CODE-1 B Column1 Valuue
CODE-1 B Column2 Valuue
CODE-1 B Column3 Valuue
CODE-1 B Column4 Valuue
CODE-1 B Column5 Valuue
CODE-1 C Column1 Valuue
CODE-1 C Column2 Valuue
CODE-1 C Column3 Valuue
CODE-1 C Column4 Valuue
CODE-1 C Column5 Valuue
CODE-1 D Column1 Valuue
CODE-1 D Column2 Valuue
CODE-1 D Column3 Valuue
CODE-1 D Column4 Valuue
CODE-1 D Column5 Valuue
CODE-1 E Column1 Valuue
CODE-1 E Column2 Valuue
CODE-1 E Column3 Valuue
CODE-1 E Column4 Valuue
CODE-1 E Column5 Valuue

Anybody Have an any idea

2 Replies

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

Vinay Singh10y ago
By converting row into column. you can acchive the task
http://www.aspdotnet-suresh.com/2012/09/how-to-convert-rows-to-columns-in-sql.html
0
alice yang10y ago
Hi,
Check the following link:
Import data from Excel to Datatable:
http://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Excel-Import/Export-Import-Data-from-Excel-to-Datatable.html
0