i have one excel sheet if i tried to open it in my uipath giving me error like rename deleted or selector not found.if i rename the sheet it working fine,here send u my program pls check and let me know if u have any idea related issue
@Manjuts90 I checked excel name its correct, (Go to excel Property → Security → Copy Object Name it gives file path with extension, so no chance to get a wrong path)
Im sorry for my question but, do you need to open the excel window right? Because if you dont, you should use excel or wb activities for read and write a file, you dont need to open it.
The problem is in the name of the Excel, dont know why yet, but with your .xaml and you excel file called “SAP ZXY Report_(Yesterdays Date).xlsx” I could’t open it.
But, I renamed the xlsx to: “LOL.xlsx” and then it opened successfuly, so the problem is there.
Rename the .xlsx if you cant solve the problem with the previous name.
If you just need to open the file in Excel and have it be visible, then you can also consider using the Excel Application Scope activity. As long as the Visible property is enabled, it will open the Excel workbook and have it be visible. The Excel file will close once the Excel Application Scope ends, so you just have to put your Click activities and other pivot operations inside the Excel Application Scope. Hope that helps!