topic Re: VBO Microsoft 365 Excel: Dynamically describe Excel in Digital Exchange

VBO Microsoft 365 Excel: Dynamically describe Excel

EasyBluePrism — Fri, 31 Oct 2025 09:37:36 GMT

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?

Re: VBO Microsoft 365 Excel: Dynamically describe Excel

Neel1 — Fri, 31 Oct 2025 09:50:39 GMT

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.

Re: VBO Microsoft 365 Excel: Dynamically describe Excel

Kirk.Russell — Mon, 03 Nov 2025 11:56:11 GMT

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

Re: VBO Microsoft 365 Excel: Dynamically describe Excel

EasyBluePrism — Thu, 06 Nov 2025 07:15:51 GMT

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.

Re: VBO Microsoft 365 Excel: Dynamically describe Excel

Kirk.Russell — Thu, 06 Nov 2025 07:51:11 GMT

Hi @EasyBluePrism

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

All the best

Kirk