I need to read and also write to an excel file on a sharepoint. I tried to use excel application scope to open the excel but failed with the error “The given path’s format is not supported”. The file from sharepoint has the path like “https://sharespace.xxx.com/rooms/project-xxx/Shared Documents/excelfile.xlsx”. the normal document path is like “C:\Users\xxx\Documents\excelfile.xlsx”. I can see it’s quite different format.
Is there any way to interact with excel on sharepoint like we normally do in UiPath?
Hello, I mapped the sharepoint link to local drive Z and run a test below. While the bot is running, I can see it writes to the cells with correct strings. But when the bot finishes running, I checked the excel and the changes (Write cell") are not saved. It seems somehow the Save Workbook activity does not work. Do you have any idea why this happened?
Hi, I don’t have any error report from UiPath. The problem is that I use Write Cell activity to update cell value in the test code. after the robot finish running (no error occur), when I open the Test.xlsx file, it’s still the same one. no cell value is updated. But during the process, I can see in the excel that UiPath is writing to specific cell (I made the excel activity visible). What makes me so confuse is that why the changes are not saved even if I checked the auto save option?
Sorry I am not allowed to upload my xaml file as a new user, but I did a screenshot below, that is all my code.
I just run the example you sent to me with the correct file path in my Z drive (Mapped from Sharepoint link). Still the changes are not saved successfully even if no error occur in UiPath.
When I open the file manually, I see below the protected view. If I need to change the sheet manually, I always need to click Enable Editing. Could this be the problem? if yes, how could I use UiPath to get rid of the protected view? It’s not password protected btw.
Hi,
You can used click activity to select protected view. If you are not getting the Enable Editing everytime. Please use element exists and if exists then click.
I have done this and it works fine for me. Particularly Enable Editing Button selector is common across hence you can use same selector for editing for all excels.
I have a similar problem. I have mapped from sharepoint and i can perform some tasks in the excel file with uipath.
However, if someone has opened the file in its browser (via SharePoint webpage) when the robot writes content in a cell then the file gets duplicated in Sharepoint instead of being applied in the same file… very strange behaviour.
When nobody has it opened and i write something in a cell, then the changes are applied in the same file and not a new file is generated.
Hi, I don’t have much experience using SharePoint activities. I do know that the Excel scope had a similar bug where if the file was opened by someone else, it would create a new file in the local documents folder for some reason. I wonder if it’s a similar bug.
I would suggest searching the forums some more or use technical support if that’s applicable for you.