要在Excel中查找隐藏的行和列... [英] To find Hidden rows and columns in Excel...

问题描述

我在excelsheet(Windows项目)上工作，我无法使用来查找特定工作表中的隐藏行和列.我进行了大量搜索，但未找到相关结果，并且我不想使用XML ....

I m working on excelsheet( windows project) and i am unable to find hidden rows and columns in a particular sheet using. I searched lot but could not find relevant results, and i dont want to use XML....

推荐答案

未提供详细信息；
您仍然可以考虑参考此问题链接. 带有OLEDB的Excel
这样，您可以从excel文件中获取所有隐藏的行和列.

Yet, as you have not provided the details;
Still this question-link you might consider to refer. Excel with OLEDB
This way you can get all the hidden rows and columns from excel file.

此处有多个选项.使用Interop，选择适当的范围并修改内容，您也可以根据需要在列中循环.

如果只想查询数据，请使用OleDbConnection并针对该工作表创建SELECT查询.

没有更多细节(关于当前使用的技术等)，很难给出具体细节.

Several options here. Use Interop, select a proper range and modify the contents, yuo can also loop through the columns if you like.

If you just want to query the data, use OleDbConnection and create a SELECT query against the sheet.

Without more details (about technology currently used etc) it''s quite hard to give specifics.

这篇关于要在Excel中查找隐藏的行和列...的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！