VBO Microsoft 365 Excel: Dynamically describe Excel

[EasyBluePrism]

I have an Excel file on Sharepoint. Every day I want to add a few new lines there, because it is a report. Until now, we had this report on an ordinary drive. That’s why we used the VBO Excel with the following actions, amongst others: Go To Next Empty Cell Down or Go To Next Empty Cell Right. Unfortunately, I can’t find any analogue actions in the VBO Microsoft 365 Excel.
So my question: How can I use the Microsoft 365 VBO to dynamically describe an Excel, i.e. add new rows to existing rows?

[Neel1]

Hey @EasyBluePrism  How are you. Good to see you back on community after a while.

I also noticed that out of 30 actions currently in Graph API Excel VBO, there is no direct action to support this.

You can raise idea on Dx portal  https://dxassetideas.blueprism.com/ideas  and share here for upvoting.

[Kirk.Russell]

Hi @EasyBluePrism 

While waiting for a possible addition to the vbo - could you use the action Get number of rows and then work out the first blank A cell from that? Or the Get used range action?

All the best

Kirk

[EasyBluePrism]

Hi @Kirk.Russell 

Thank you very much. That’s how it works, as long as the Excel doesn’t have formatting. My Excel had marked the rows with different colours. So with GetNumberOfRows, all the empty rows were counted. As soon as I removed these formatting, it worked.

[Kirk.Russell]

Hi @EasyBluePrism 

Awesome, I'm glad you got it working for you.

All the best

Kirk