vb读取excel数据时，当数据隐藏了怎么读取？

[chs048127]

vb读取excel数据时，当数据隐藏了怎么读取？
我是这样写的ext1.Text = xlsheet.Cells(i, 5).Text
但是如果那一列隐藏了就没办法读取了，怎么解决？？

[舉杯邀明月]

“隐藏了就没办法读取”？？？　居然有这事？　

[chs048127]

不只是隐藏没办法读取，就连单元格颜色变下颜色就没办读取了。是不是和text的属性有关系。

[舉杯邀明月]

表示未曾遇到这种事…………

[laotou99]

没碰到过这样的问题。

[一如既往哈]

头一次听说出现这样的情况！！！ 肯定是你的代码有问题.....

[舉杯邀明月]

我觉得也是。 我以前写的一些，别说隐藏行／列了，就是工作表甚至工作簿都隐藏的，照样正常读取。

[chs048127]

http://read.qidian.com/BookReader/1964257,32629223.aspx http://read.qidian.com/BookReader/1964257,32632778.aspx http://read.qidian.com/BookReader/1964257,32636143.aspx http://read.qidian.com/BookReader/1964257,32646393.aspx http://read.qidian.com/BookReader/1964257,32650011.aspx http://read.qidian.com/BookReader/1964257,32660843.aspx http://read.qidian.com/BookReader/1964257,32667433.aspx http://read.qidian.com/BookReader/1964257,32674771.aspx http://read.qidian.com/BookReader/1964257,32680542.aspx http://read.qidian.com/BookReader/1964257,32689233.aspx http://read.qidian.com/BookReader/1964257,51925521.aspx http://read.qidian.com/BookReader/1964257,51925522.aspx http://read.qidian.com/BookReader/1964257,51925533.aspx http://read.qidian.com/BookReader/1964257,51925539.aspx http://read.qidian.com/BookReader/1964257,51925542.aspx http://read.qidian.com/BookReader/1964257,51925548.aspx http://read.qidian.com/BookReader/1964257,51925555.aspx http://read.qidian.com/BookReader/1964257,51925558.aspx http://read.qidian.com/BookReader/1964257,51925562.aspx http://read.qidian.com/BookReader/1964257,51925564.aspx http://read.qidian.com/BookReader/1964257,51925565.aspx http://read.qidian.com/BookReader/1964257,51925569.aspx http://read.qidian.com/BookReader/1964257,51925572.aspx http://read.qidian.com/BookReader/1964257,51925575.aspx http://read.qidian.com/BookReader/1964257,51925578.aspx http://read.qidian.com/BookReader/1964257,51925581.aspx http://read.qidian.com/BookReader/1964257,51925584.aspx http://read.qidian.com/BookReader/1964257,51925586.aspx http://read.qidian.com/BookReader/1964257,51925590.aspx http://read.qidian.com/BookReader/1964257,51925592.aspx http://read.qidian.com/BookReader/1964257,51925593.aspx http://read.qidian.com/BookReader/1964257,51925598.aspx http://read.qidian.com/BookReader/1964257,51925601.aspx http://read.qidian.com/BookReader/1964257,51925611.aspx http://read.qidian.com/BookReader/1964257,51925616.aspx

[chs048127]

http://read.qidian.com/BookReader/1964257,32578891.aspx http://read.qidian.com/BookReader/1964257,32584217.aspx http://read.qidian.com/BookReader/1964257,32589800.aspx http://read.qidian.com/BookReader/1964257,32599567.aspx http://read.qidian.com/BookReader/1964257,32606114.aspx http://read.qidian.com/BookReader/1964257,32608568.aspx http://read.qidian.com/BookReader/1964257,32614062.aspx http://read.qidian.com/BookReader/1964257,32618623.aspx http://read.qidian.com/BookReader/1964257,32622054.aspx http://read.qidian.com/BookReader/1964257,32629223.aspx http://read.qidian.com/BookReader/1964257,32632778.aspx http://read.qidian.com/BookReader/1964257,32636143.aspx http://read.qidian.com/BookReader/1964257,32646393.aspx http://read.qidian.com/BookReader/1964257,32650011.aspx http://read.qidian.com/BookReader/1964257,32660843.aspx http://read.qidian.com/BookReader/1964257,32667433.aspx http://read.qidian.com/BookReader/1964257,32674771.aspx http://read.qidian.com/BookReader/1964257,32680542.aspx http://read.qidian.com/BookReader/1964257,32689233.aspx http://read.qidian.com/BookReader/1964257,51925521.aspx http://read.qidian.com/BookReader/1964257,51925522.aspx http://read.qidian.com/BookReader/1964257,51925533.aspx http://read.qidian.com/BookReader/1964257,51925539.aspx http://read.qidian.com/BookReader/1964257,51925542.aspx http://read.qidian.com/BookReader/1964257,51925548.aspx http://read.qidian.com/BookReader/1964257,51925555.aspx http://read.qidian.com/BookReader/1964257,51925558.aspx http://read.qidian.com/BookReader/1964257,51925562.aspx http://read.qidian.com/BookReader/1964257,51925564.aspx http://read.qidian.com/BookReader/1964257,51925565.aspx http://read.qidian.com/BookReader/1964257,51925569.aspx http://read.qidian.com/BookReader/1964257,51925572.aspx http://read.qidian.com/BookReader/1964257,51925575.aspx http://read.qidian.com/BookReader/1964257,51925578.aspx http://read.qidian.com/BookReader/1964257,51925581.aspx http://read.qidian.com/BookReader/1964257,51925584.aspx http://read.qidian.com/BookReader/1964257,51925586.aspx http://read.qidian.com/BookReader/1964257,51925590.aspx http://read.qidian.com/BookReader/1964257,51925592.aspx http://read.qidian.com/BookReader/1964257,51925593.aspx http://read.qidian.com/BookReader/1964257,51925598.aspx http://read.qidian.com/BookReader/1964257,51925601.aspx http://read.qidian.com/BookReader/1964257,51925611.aspx http://read.qidian.com/BookReader/1964257,51925616.aspx http://read.qidian.com/BookReader/1964257,51925619.aspx http://read.qidian.com/BookReader/1964257,51925622.aspx http://read.qidian.com/BookReader/1964257,51925626.aspx http://read.qidian.com/BookReader/1964257,51925631.aspx http://read.qidian.com/BookReader/1964257,51925634.aspx http://read.qidian.com/BookReader/1964257,51925635.aspx http://read.qidian.com/BookReader/1964257,51925639.aspx http://read.qidian.com/BookReader/1964257,51925642.aspx http://read.qidian.com/BookReader/1964257,51925646.aspx http://read.qidian.com/BookReader/1964257,51925648.aspx http://read.qidian.com/BookReader/1964257,51925650.aspx http://read.qidian.com/BookReader/1964257,51925655.aspx http://read.qidian.com/BookReader/1964257,51925658.aspx http://read.qidian.com/BookReader/1964257,51925663.aspx http://read.qidian.com/BookReader/1964257,51925668.aspx http://read.qidian.com/BookReader/1964257,51925671.aspx http://read.qidian.com/BookReader/1964257,51925676.aspx http://read.qidian.com/BookReader/1964257,51925677.aspx http://read.qidian.com/BookReader/1964257,51925679.aspx http://read.qidian.com/BookReader/1964257,51926012.aspx http://read.qidian.com/BookReader/1964257,51926015.aspx http://read.qidian.com/BookReader/1964257,51926017.aspx http://read.qidian.com/BookReader/1964257,51926020.aspx http://read.qidian.com/BookReader/1964257,51926033.aspx http://read.qidian.com/BookReader/1964257,51926067.aspx http://read.qidian.com/BookReader/1964257,51926077.aspx http://read.qidian.com/BookReader/1964257,51926088.aspx http://read.qidian.com/BookReader/1964257,51926235.aspx http://read.qidian.com/BookReader/1964257,51926236.aspx http://read.qidian.com/BookReader/1964257,51926237.aspx http://read.qidian.com/BookReader/1964257,51926238.aspx