Delete data from excel file

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

MAIN BLAA

BLAA

Blaa

blaa

BLAA

MAIN BLAA

BLAA

MAIN BLAA

BLAA

MAIN BLAA

BLAA

MAIN BLAA

BLAA

MAIN BLAA

BLAA

MAIN BLAA

BLAA

MAIN BLAA

BLAA

MAIN BLAA

BLAA

MAIN BLAA

BLAA

MAIN BLAA

BLAA

MAIN BLAA

BLAA

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?

4 Replies

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

Upendra Kumar Pandey12y ago
Welcome anubahv. I know better you can do.
anubhav prabakar12y ago
Hi Upendra, I remoede all the "s" from the dataset before I put anything in the excel file and it works. thanks...
anubhav prabakar12y ago
Ok, thanks, I will try it..
Upendra Kumar Pandey12y ago
Hi Anubav, the only one idea to delete data from excell on the basis of conditions. First Of all bind excell to gridview and on the basis of rows and cell value you can check and filter your data and then you do a operations and finally using for loop count total rows and insert by one click. This is best Idea. Try You can do, if you can't be able to do then i will provide source code also.