Help with excel Sharepoint

Help Something Else
1

Hello, I need help on using Excel with Sharepoint,
I need to delete a specific range, there is only one activity to delete and it is delete range, but it deletes the entire entire table, and I need to delete a specific cell, which activity could I use.

¡
thank you

2

@Maria_guerrero_lopez1

Welcome to the community

You can specify range as well in office365 activities

image
image1297×171 21.1 KB

cheers

1 Like
3

Hello @Maria_guerrero_lopez1

Use the “Write Cell” activity within an “Excel Application Scope” to clear the content of a specific cell. Set the “Cell” property to the target cell reference (e.g., “A1”) and the “Value” property to an empty string or space. This approach clears the cell without deleting the entire table. Adjust the cell reference based on your requirements.

Thanks & Cheers!!!

1 Like
4

Great, it deleted the specific range for me, but I need to delete a specific cell if it contains a value, I have tried with a for each workbook but I can’t handle it, although you have helped me a lot with this,
million of thanks.

5

@Maria_guerrero_lopez1

  1. Use the “Find” or “Lookup Range” activity to find the cell with the desired value.
  2. Retrieve the cell address from the activity output.
  3. Use the “Write Cell” activity to write an empty value to the identified cell.
1 Like
6

Hello

I am using Excel online or OneDrive activities, it is a OneDrive document, these activities are for classic Excel, but, thank you!

7

@Maria_guerrero_lopez1

did you happen to try the above ? with delete rnage and providing range

cheers