Tech
Forums
Jobs
Books
Events
Videos
Conference
Annual Conference
Bcrypt
Ai Conference
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
2
Answers
Import Excel Format on Asp.Net C#
Ask a question
Ask a question
Upload Source Code:
Select only zip and rar file.
Ekrem Tapan
8y
277
1
Reply
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
Post
Reset
Cancel
Answers (
2
)
Next Recommended Forum
write a program in c#?
session lost when paypal return url .net