Image copy while copying excel from source to destination path

Help Studio
1

Hi,

I am copying excel file from source to destination path.

While copying, the image inside the source file is not copying with the text as is, but it is showing as some junk data.

PFA reference files, Request for support please.

  1. Image with content in source excel file.png
  2. Image with date as junk in desitination file.png

Thanks,

Image with date as junk in desitination file
Image with date as junk in desitination file703Ă—138 2.15 KB
Image with content in source excel file
Image with content in source excel file703Ă—78 1.26 KB

Thanks

1 Like
2

Hi @krishbcd

Share us with your sample source and destination excel files

3

Hi
i tried to replicate this case, but i could see the file is getting copied with its image property.

Did we check doing the same, MANUALLY…like copy the file and paste it manually and see whether we are getting junks

Cheers @krishbcd

1 Like
4

Hello Palaniyappan,

Yes, while copying those few cells with Image and its content is being copied while copying manually,

can you please help me how did you copy with its image property please as few (3) cells only with the image and with content. I have used copy file as of now which is giving the mentioned error.

Thanks

5

Even i used COPY FILE activity and it worked fine @krishbcd
would you like to copy the entire file or copy only the cells with images

Cheers @krishbcd

2 Likes
6

Entire file as it is including cells with image and content inside that image

1 Like
7

Then copy file would work for sure @krishbcd
i wonder there could be some issue with the file itself.

or try with MOVE FILE activity if its fine to move it completely.

or

–use START PROCESS and pass the FileName as filepath of the excel
–then it will open the excel file
–use ATTACH WINDOW and select that screen
–inside that activity use send hot key activity with key as ctrl+a
–then again a send hot key with ctrl+c
–and use again START PROCESS activity and pass a new filepath of excel as input to Filename
–once opened use Send hot key with key as ctrl+v

its another way but still need to try for your case being with images

Kindly try this and let know for any queries or clarification

Cheers @krishbcd

1 Like
8

Hi,

I have found the actual root cause. While copied, the file is being copied properly with the image including the text inside the Image cell.

But when writing the excel other cells using workbook Write cell, the text inside the image cell is being overwritten with some junk data.

When I write other cells using excel application scope write cell activity, it is not updating any junk data inside the image cell.

Is the any specific reason for this? Can not use workbook write cell activity for this scenario?

Thanks,