Copy excel as it is

Help
1

Hi,

I want to copy the the excel data from one workbook to other workbook as it is, means if the data is in bold it should copy as a bold. In my case some rows are merged together. So i want to copy as it is.

Instead of hotkeys, any solution for this?

2

Hi @Jayesh_678

1.Use Workbook Read Range Activity and pass the path of excel file and create output data table variable.
2.Use Workbook Write Range Activity and pass new workbook path of excel file and pass the data table variable.

Regards,
Kommi Jeevan.

1 Like
3

Did we try with MOVE FILE activity if we are trying to create a new another file.
@Jayesh_678

1 Like
4

Book21.xlsx (9.7 KB)

I want to copy the excel data as it is.

@ClaytonM

5

It is not copying as it is. Bold data is not coping as a bold.

6

There is an option for "Preserve Formatting. I can’t remember if that is in the Excel Scope Read Range or the Workbook Read Range. Try that and see if the Bold copies over.

7

It is not working… :frowning:

8

@Jayesh_678 Can you tell me where do you want to Copy the Excel Data?

1 Like
9

Mail Body…

10

@Jayesh_678 Do you want to Attach the File as an Attachment or as a Tabular Data inside the body?

1 Like
11

Tabular data inside the body.

12

@Jayesh_678 Then there is Something else that you need to perform :sweat_smile:, You need to iterate the Excel File using a For Loop, and use basic html Table Coding , Can you send your Excel File? I can try to make a workflow fo it.

2 Likes
13

Book21.xlsx (9.7 KB)

Thanks for your quick response. Please find the attached excel file.

14

@Jayesh_678 Is it fine if the table is in this Format ?
table

15

@supermanPunch Hey are the above header are bold . If yes can you share the method have u have achieved that .

16

Hi @HimanshuSonawane

Have you tried excel application scope and use select range activity and use send hot key as ctrl+c and ctrl+v

or else use excel application scope and pass copy sheet activity

Thanks
Ashwin S

17

@HimanshuSonawane Do you want the Table in an HTML Format ?

18

Yes .

19

@HimanshuSonawane Do you want to use your table inside body of Email ?

20

yes .