The number of arguments provided is different from the number of arguments accepted by the method

"The number of arguments provided is different from the number of arguments accepted by the method"

The above error getting while importing the excel file. if anybody knows the solution, please help me to resolve the error

Thanks in advance.

check your COM object or you are suffering from following COM error. Try to do same steps mentioned in following link it will resolve your problem.

http://mafsarkhan.blogspot.com/2011/03/error-executing-code-method-has-been.html

-Afsar

http://mafsarkhan.blogspot.com

do i need follow any one of the work around or all?

because i did two things in that

  1. Enable the checkbox Run this program in Compatibility mode for and select Windows XP (Service Pack 2)
  2. Disable Window Ghosting as described in this post. please suggest me which is the best one in that link