cancel
Showing results for 
Search instead for 
Did you mean: 

Microsoft 365 Excel Write Excel

EasyBluePrism
Level 4
have implemented a process where a collection hast to be written to an Excel. As a test I created an Excel with the name TestExcel.xlsx and the table “Tabelle1”.
The Excel can be found, because I can copy it or read data out of it. But writting from a collection to the Excel does not work.
There is no error message. Everything looks fine. But, the collection is not written to Excel. 
I use the actions Authenticate, Open Workbook, Write Collection and Close Workbook.
Could it be a permission problem? Attached you can find the BP API permissions.
Thanks for your help.
EasyBluePrism_0-1715665721337.png

 

22 REPLIES 22

EasyBluePrism
Level 4

I read the IDs via the Graph API. To make sure that I don’t have the same Excel anywhere else, I created a new Excel with different data in a different folder. That is, this time I read data from Sheet2 (Tabelle2) and write data to Sheet1 (Tabelle1). The IDs must be correct, otherwise the Get Worksheet as Collection would not work. But Sheet1 remains empty.
What else I noticed is that I receive the following error message

EasyBluePrism_0-1718788221679.png

when writing collection, if the collection contains numbers, even though the collection is formatted as text:

EasyBluePrism_1-1718788721881.pngEasyBluePrism_2-1718788830808.png

When the collection has just text (in RowA) there is no error message.

 

EasyBluePrism
Level 4

@ewilson In the meantime I was able to test the request URL with Postman (Sharepoint Graph Exlorer is unfortunately not allowed in our company). I had the same problem. This means that the problem is on our (Sharepoint) side and we have to keep looking at ourselves.
Thank you for your support so far!

EasyBluePrism
Level 4

I found out that no session ID can be passed to Write Collection. Carl Carter (from BluePrism) pointed out to me that I should not use Open Workbook. Then no session ID is passed and it works 😉