Classic O365 Activities Excel Error

[m.eisermann]

Hi all,
we recently set up the O365 Connections are nor trying to implement a process using the classic O365 Excel Activities in a Windows Legacy project.
Those are working fine except for the Insert Column and Insert Rows Activities, those always throw an error “Insert Column: Code: ItemNotFound”. The Sheet is definetly available since I am using the same variables in the same O365 Scope for Read Range and this works without any issues. Has anyone ever got those Insert Row/Column Activites to work?
I have read online, that the GraphApi has a limitation for those use cases. It will only work with Sharepoint Files in the root directory of a Sharepoint Site. Might this be the reason for the error?
Best Regards,
Moritz

[pradeep931 (Pradeep Bandharam)]

Hi @m.eisermann

Are you giving the same workbook path for the insert column operation?

Refer the below thread for more information

UiPath.Excel.Activities.insertColumn cannot work

Thanks everyone, I used debug mode to find out where the problem was, then i found out the path that the excel activity referred to was not point to the folder I placed the workbook i needed. After editing the path, the problem solved

[m.eisermann]

Hi @pradeep931,
yes I pass exactly the same values for both Read Range and Insert Column/Row. For the insert Column/Row I’m not passing a Row name rather a index and am not passing any data, so just the Insert Empty Row Parameter.
But still thanks for the suggestion.