Read Range Workbook Picture names cannot be empty

Help Activities
, ,
1

the issue is regarding an excel file that appears to have an overlapping row.
image

This is due to a recent change in the excel file - this gets downloaded first from a website and then is again opened to extract data and update an application and is also attached in the output mail.
The row 2 from the screenshot has an image inserted and is a merged row.
is there a way to delete the image after the file is downloaded to read the file and updates the app. I have tried to use excel application activity, but this throws an error - the file is being used in another application.
Is there any other way to delete the image without using VB expressions.

Also, the excel file does not have any special characters which might restrict the read range workbook activity.

2

@dshah,

VBA macro will be the best approach for this problem.

3

@dshah

If it says file is being used then try to use a excel process scope with options like kill if already in use and launch as automation which would open it

Cheers