Want to remove the blank rows from .xls file

Posted by Amatya under C# on 3/17/2016 | Points: 10 | Views : 180 | Status : [Member] | Replies : 2
I am reading the file row by row from .xls file. Actually I have 4 rows filled but in my data Table 134 rows are coming i.e. 4 rows with values and the rest are coming blank.Want to remove the blank rows from .xls file.

Feel free to share informations 9731764134
mail Id ' adityagupta200@gmail.com
Thanks



Responses

Posted by: Rajnilari2015 on: 3/17/2016 [Member] [Microsoft_MVP] [MVP] Platinum | Points: 25

Up
0
Down
@Amatya Sir,
Do u want to remove that manually from excel file? Another approach is to check for blank/null fields and ignore that programatically.

--
Thanks & Regards,
RNA Team

Amatya, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Amatya on: 3/17/2016 [Member] Silver | Points: 25

Up
0
Down
Plz tell through programatically and manually if possible.

Feel free to share informations 9731764134
mail Id ' adityagupta200@gmail.com
Thanks

Amatya, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response