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.
Thanks,
Balaji G
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.
Thanks,
Balaji G