Limpiar celdas de excel

Help Activities
, , ,
1

hola, buenas tardes.
hay alguna forma de limpiar las celdas de excel, por rango…
lo estoy haciendo con write cell y escribo “” pero se demora demasiado!
necesito su ayuda
gracias

Forum Engagement Daily Reports
2

Hey @mively
If you want to clear a range of cells in Excel, instead of using “Write Cell” repeatedly, try using the “Clear Range” activity — it’s much faster.

A Microsoft Excel action interface allowing the user to clear a specified sheet, range, or table with an option to include headers. (Captioned by AI)
A Microsoft Excel action interface allowing the user to clear a specified sheet, range, or table with an option to include headers. (Captioned by AI)643×197 6.59 KB

3

Hi @mively,
If you want to clear a specific range in Excel:

Use the “Clear Range” activity from the UiPath.Excel.Activities package.

Set the range (e.g., “A2:A100”) to clear multiple cells at once.

Regards,
Arivu

4

The image shows an Excel process workflow in an automation software, where it opens an Excel file and clears a specified sheet named "Guias por Facturar". (Subtitulado por IA)
The image shows an Excel process workflow in an automation software, where it opens an Excel file and clears a specified sheet named "Guias por Facturar". (Subtitulado por IA)618×676 16.5 KB

como seria para seleccionar un rango de esa hoja… por ejemplo de la A hasta la G

5

@mively

Give Excel.sheet("Sheetname").Range("A:G")

Cheers

1 Like
Forum Engagement Daily Reports
6

@mively
Excel.Sheet(“Guias por Facturar”).Range(“A:G”)

7

se puede borrar, pero sin borrar los formatos de las celdas ?

8

@mively

Ideally it would clear the data only

Cheers

9

entieendo, sabes como darle formato a las columnas? sin hacer click en el mismo excel?

10

@mively

What do you mean by format columsn and clicking?

Cheers

11

nop, necesito que algunas columas sean formato numero por ejemplo, ya que al momento de copiar y pegar, pierde el formato

12

@mively

Please use this activity

Cheers

13

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.