By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,166 Members | 1,143 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,166 IT Pros & Developers. It's quick & easy.

Couldn't invoke VLookup function in excel from .net

P: 1
Hi All,

I am exporting a datatable to an excel sheet in an existing workbook. In another worksheet in the same workbook, i am using vlookup function that uses data in the exported worksheet. The issue is vlookup function works only when i manually enter the values in the exported worksheet and click "Enter" button. Is there any way to invoke vlookup function from my .NET application. I have tried SendKeys.Send("{ENTER}"), however, it doesn't work. Calculation tab is also set to "Automatic" in excel.

Balaji G
Jul 15 '10 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.