Click here to Skip to main content
14,775,019 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:

I am trying to view excel data in a gridview.Although the data is coming in the grid but the empty columns in the excel sheet which have no heading are also coming along with it.How to avoid empty cells to be displayed in gridview

Ankit Rajput 22-Apr-11 2:46am
Can you please provide some more details about data fetching from Excel?
Slacker007 22-Apr-11 6:30am
I agree with Ankit here. Could you please provide a little more information for clarity purposes. Thanks.

Try specifying the cell range for your Excel spreadsheet when loading the data into your gridview. You might be loading everything into your gridview and not the exact data range you need/request.
cell reange will not work in this sections.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900