I am trying to pass data from webpage to Excel. While doing so Excel throws one popUp box ‘Repairs to Excel file’ containing message such as Excel was able to open the file by repairing or removing the unreadable content and then close button appears.
All I have to do is to close that button and then Save content in different file. But I am not able to automate so. While clicking Close button or passing hotkey ‘Enter’. Error comes such as – unable to cast object of type ‘newtonsoft.json.linq.jobject’ to type ‘system.string’.
Please see this pic, I want to automate to press the close button.
Error is coming, while doing so.