Excel, limpiar rango

Help Activities
1

hola, alguien me puede orientar para poder borrar la informacion de una hoja de excel, incluido encabezados pero que no borre el color ni estilo, ni tampoco formulas en las celdas…
intente con (imagen adjunta)

This image shows a configuration setup for an Excel Process Scope that uses an Excel file and clears a specific sheet named "Detalle facturas rechazadas". (Subtitulado por IA)
This image shows a configuration setup for an Excel Process Scope that uses an Excel file and clears a specific sheet named "Detalle facturas rechazadas". (Subtitulado por IA)621×709 17.9 KB

pero borra todo todo, y necesito que deje colores y formulas en celdas…
ayuda

2

Hi @mively

Try this,
Open the Excel file using the “Excel Process Scope” and “Use Excel File” activities. Use the “Invoke VBA” activity and insert the following VBA code(change accordingly):

Sub ClearSheetData()
Dim ws As Worksheet
Set ws = ActiveSheet
ws.Cells.ClearContents
End Sub

Happy Automation

3

Hii @mively
try this approach modern excel activities
follow the below steps

1 Use “Use Excel File”

  • Open the Excel file using the “Use Excel File” activity.

2 Read the Data

  • Use “For Each Excel Row” to iterate through each row dynamically.

3 Loop Through Each Column

  • Inside “For Each Excel Row”, use “For Each” to iterate through columns.

4 Check for Formulas

  • Use “Get Cell Formula” to check if a formula exists in each cell.

5 Clear Non-Formula Cells

  • If the formula is empty, use “Write Cell” to set the cell value to "".

    cheers!!
4

lo podrias graficar para eliminar solo ciertas columnas, por ejemplo escribir “” de la A a la J, en el for each, please

5

@mively

after using of for each row in datatable use the below steps

  • Inside For Each Excel Row use a for Eachloop but limit it to columns A to J.
  • Convert column index to a letter using UiPath’s column conversion logic

cheers!!