Extract table along with the color format into an excel sheet

Help Studio
, , , , , , , , ,
1

Hi,

Can someone guide me on how to extract this table from SpreadSheetGear UI and write it in excel with the color format. The color of the background cell and the font should remain the same
image

2

@Ruchita_Patil

Directly with color is difficult

Instead use copy sheet activity from classic axcel activities which would copy the sheet as is and then deete the non required rows or column so that the formatting of remaining is intact

Cheers

3

This image is a reference, but the spreadsheet UI is in a desktop based application.

I have to extract the table as it is

4

@Ruchita_Patil

Then you can try using selecting the data and copy to clipboard using ctrl+c then open excel and then use ctrl+v …that might help…

Or if there are any extract options use them…would be recommended

Cheers

5

Hi @Ruchita_Patil - Can you try with CV Extract Table activity to extract the table

Doc - https://docs.uipath.com/activities/other/latest/user-guide/cv-extract-data-table-with-descriptor

6

What are the extract options?

7

@Ruchita_Patil

If any options are there on the application to extract the data or export as excel

Cheers