Filtrado - copiado y pegado

Help Activities
, ,
1

hola, buenas tardes, necesito su ayuda comunidad.

necesito hacer un filtro a una hoja de excel, en una columna, hoja guias

A spreadsheet with values for 2024, 2025, and total general columns, with the "filtro" column filled with error values ("#N/D"). (Subtitulado por IA)
A spreadsheet with values for 2024, 2025, and total general columns, with the "filtro" column filled with error values ("#N/D"). (Subtitulado por IA)329×352 4.47 KB

necesito copiar la informacion que muestren esasa filas, las que salga n/D

copiarla en la hoja resumen, solo necesito copiar la columna cliente y total general a la otra hoja
copiarlas aqui…
image

justo arriba del total general para ir agregandolos a la suma

ambas hojas tienen que seguir en el excel, no son datatables externas

me podrian ayudar a realizar esto porfavor comunidad.

2

Hi @mively,

You can achieve that using filter datatable activity.

  1. read range excel sheet and store in a datatable
  2. Filter datatable to keep the rows where filtro column equals ‘#N/D’
    3)Use the filtered datatable from step 2, you will have the data as shown above, now here filter the datatable again to only keep the column Total general
  3. Now you will only have Total general column with values where filtro column had value ‘#n/D’.
  4. Now you can paste this datatable onto your summary sheet using write range activity.

Hope this helps.

Regards
Sonali

3

Hi @mively

Can you try this

The image depicts an automated process flow in UiPath Studio that reads an Excel file, applies a filter, reads a specific range with headers, filters the data table, and then writes the filtered data to a new Excel sheet. (Captioned by AI)
The image depicts an automated process flow in UiPath Studio that reads an Excel file, applies a filter, reads a specific range with headers, filters the data table, and then writes the filtered data to a new Excel sheet. (Captioned by AI)585×1391 47 KB

Sequence4.xaml (14.7 KB)

Note: Make sure to select Read formatting as Display value, assuming your excel having formulas.

This image displays the configuration settings for using an Excel file in an automation process, specifying the file name "Input.xlsx" and options like saving changes and reading formatting. (Captioned by AI)
This image displays the configuration settings for using an Excel file in an automation process, specifying the file name "Input.xlsx" and options like saving changes and reading formatting. (Captioned by AI)880×589 16.3 KB

Regards,

1 Like
Forum Engagement Daily Reports
4

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