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
anubhav prabakar
NA
14
7.2k
Delete data from excel file
Jan 27 2014 5:18 AM
HeaderMain1
HeaderMain2
Header1
Header2
Header3
Header4
Header5
Header6
Header7
Header8
Header9
Header10
Header11
Header12
Header13
Header14
Header15
Header16
Header17
Header18
Header19
Header20
Header21
Header22
Header23
Header24
Header25
Header26
Header27
Header28
Header29
Header30
Header31
Header32
Header33
Header34
Header35
Header36
Header37
Header38
Header39
Header40
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
MAIN BLAA
MAIN BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
s
s
s
s
s
s
s
s
s
s
Blaa
Blaa
Blaa
Blaa
Blaa
Blaa
blaa
blaa
blaa
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
MAIN BLAA
MAIN BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
s
s
s
s
s
s
s
s
s
s
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
MAIN BLAA
MAIN BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
s
s
s
s
s
s
s
s
s
s
MAIN BLAA
MAIN BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
s
s
s
s
s
s
s
s
s
s
s
s
s
s
s
s
s
s
s
s
MAIN BLAA
MAIN BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
s
s
s
s
s
s
s
s
s
s
MAIN BLAA
MAIN BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
s
s
s
s
s
s
s
s
s
s
MAIN BLAA
MAIN BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
s
s
s
s
s
s
s
s
s
s
MAIN BLAA
MAIN BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
s
s
s
s
s
s
s
s
s
s
s
s
s
s
s
s
s
s
s
s
MAIN BLAA
MAIN BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
s
s
s
s
s
s
s
s
s
s
s
s
s
s
s
s
s
s
s
s
MAIN BLAA
MAIN BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
s
s
s
s
s
s
s
s
s
s
MAIN BLAA
MAIN BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
s
s
s
s
s
s
s
s
s
s
s
s
s
s
s
s
s
s
s
s
MAIN BLAA
MAIN BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
BLAA
s
s
s
s
s
s
s
s
s
s
s
s
s
s
s
s
s
s
s
s
s
s
s
s
s
s
s
s
s
s
Hi guys,
What I have:
I have an excel file which looks like this and I put data in it in a set of 10. This implies I put a particular amount of data For example in Header1 to Header10 and some other kind of data in header 11 to header20 and so on. (I HAVE UPLOADED THE EXCEL FILE)
What I want
I wand to delete all the columns in a set of 10 if it contains only "s". (Example: I want to delete Header11 to Header20, all rows). However, I do not want to delete any other set of 10 columns which contains any other combinations with "s" (for example I do not want to delete headers 21 to 30 all rows, since it also contains blaa in it).
Can any one please help?
Attachment:
deletes.rar
Reply
Answers (
4
)
What is the use of private constructor in C#
make text bold in richtextbox c#