TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Ekrem Tapan
NA
967
81.2k
Import Excel Format on Asp.Net C#
Aug 22 2016 3:22 AM
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
Reply
Answers (
2
)
write a program in c#?
session lost when paypal return url .net