本文介绍了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函数似乎不起作用?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!