显示空的Excel单元格 [英] Empty Excel Cells getting displayed

问题描述

你好

我正在尝试在gridview中查看excel数据.尽管数据正在网格中，但是excel表中没有标题的空列也随之出现.如何避免在gridview中显示空单元格


谢谢

Hello

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


Thanks

推荐答案

在将数据加载到gridview时尝试指定Excel电子表格的单元格范围.您可能正在将所有内容加载到gridview中，而不是需要/请求的确切数据范围内.

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.

这篇关于显示空的Excel单元格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！