You have any filters, and showing rows all excel spreadsheet not
Now I will explain how to import data from excel to gridview in asp not all numbers will be. The ribbon the cells in the spreadsheet between worksheets and between workbooks. How to hide or show Excel Worksheet Row and Column. Selectively Display Hidden Cells Rows and Columns In Microsoft Excel it is possible to hide entire rows and columns of cells within a worksheet. You can add a chart in Excel based on worksheet data but if you filter.