本文介绍了Worksheet.Find函数似乎不起作用?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

你好,
在尝试在Excel中查找值时,我很快遇到了另一个问题.我使用以下代码. (所有声明和赋值均已在此之前完成)
执行后,"FoundLoc"为空.

Hello,
I quickly came across another problem while trying to find a value in Excel. I use the following code. (All declaration and assignment have been done prior to this)
And after execution the "FoundLoc" is null.

Excel.Worksheet ExcelSheet = (Excel.Worksheet)ExcelWB.Sheets["Sheet1"];
Excel.Range Foundloc;

Foundloc = ExcelSheet.Cells.Find("test",  MissingObject, Excel.XlFindLookIn.xlValues,  Excel.XlLookAt.xlWhole,  Excel.XlSearchOrder.xlByRows,  Excel.XlSearchDirection.xlNext,  false,  false,  false);



我怀疑我的excel文件具有导致值和过滤器的公式.但是我不确定是否是因为这个原因.只能请帮我吗.

[edit]仅标记= OriginalGriff [/edit]



I suspect that my excel file has formulas which result in values and filters. But i am not sure if it is because of this.
Could any only please help me out whith this.

[edit]Tags only = OriginalGriff[/edit]

推荐答案



这篇关于Worksheet.Find函数似乎不起作用?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

05-28 21:52
查看更多