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
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
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
This image is a reference, but the spreadsheet UI is in a desktop based application.
I have to extract the table as it is
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
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
What are the extract options?
If any options are there on the application to extract the data or export as excel
Cheers