Informacion de excel sin query

Help Activities
,
1

hola a todos, otra consulta, como puedo copiar una hoja que tiene una query… pero copiarla a otro excel SIN LA QUERY, SOLO LOS DATOS!?
agradeceria su ayuda

2

Hi @mively

If you want only data, In Copy/Paste Range activity select Values in What to Copy

The image shows an Excel automation task setup in which data from "Sheet1" is being copied to "Sheet2" in "Input.xlsx" file. (Captioned by AI)
The image shows an Excel automation task setup in which data from "Sheet1" is being copied to "Sheet2" in "Input.xlsx" file. (Captioned by AI)634×815 23.1 KB

This image shows a Copy/Paste Range function in Excel with specified settings for copying values from Sheet1 to Sheet2, excluding headers but not transposing the data. (Captioned by AI)
This image shows a Copy/Paste Range function in Excel with specified settings for copying values from Sheet1 to Sheet2, excluding headers but not transposing the data. (Captioned by AI)739×427 16.7 KB

Regards,

3

puedo copiarlo asi, pero a otro excel, no el mismo?

4

@mively

If you want to copy to another file try this

This image shows an automation workflow for copying data from an Excel file named "Input.xlsx" to another Excel file named "Output.xlsx" using UiPath. (Captioned by AI)
This image shows an automation workflow for copying data from an Excel file named "Input.xlsx" to another Excel file named "Output.xlsx" using UiPath. (Captioned by AI)638×1189 41 KB

Regards,

1 Like
5

u the best

al momento de copiarse no se puede copiar con el mismo formato o colores, cierto?

6

@mively

If you want same colour and format you need to select All

This image shows a "Copy/Paste Range" activity in an Excel automation process, with settings configured to copy all content from Sheet1 of the input Excel file to Sheet1 of the output Excel file. (Captioned by AI)
This image shows a "Copy/Paste Range" activity in an Excel automation process, with settings configured to copy all content from Sheet1 of the input Excel file to Sheet1 of the output Excel file. (Captioned by AI)672×406 12.5 KB

Regards,

8

una consulta aparte, al momento de abrir el excel, se puede ajustar que el zoom este a 85%?

9

@mively

Try this

The image shows a workflow in UiPath's Excel Process Scope that uses an Excel file and invokes a VBA code to set the zoom level of a specified sheet. (Captioned by AI)
The image shows a workflow in UiPath's Excel Process Scope that uses an Excel file and invokes a VBA code to set the zoom level of a specified sheet. (Captioned by AI)634×886 31.1 KB

Zoom out.txt (87 Bytes)

Sub SetZoomSheet1()
    Sheets("Sheet1").Activate
    ActiveWindow.Zoom = 85
End Sub

Note:
For this we need to configure the Excel application’s security settings

Check the Excel Macro settings.
Open Excel and go to File → Options → Trust Center → Trust Center Settings → Macro Settings-> Check below image

The image shows the macro settings menu in Microsoft Office Trust Center with options to enable or disable VBA macros and trust access to the VBA project object model. (Captioned by AI)
The image shows the macro settings menu in Microsoft Office Trust Center with options to enable or disable VBA macros and trust access to the VBA project object model. (Captioned by AI)1240×994 21.2 KB

Regards,

1 Like
10

muchas gracias por tu buena disponibilidad para responder dudus!!! :slight_smile:

1 Like
11

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