Get picture from Excel sheet

[Jacco_21Digitals]

Newbe here… we have the challenge to upload rows of data from an Excel into a database on the web. No problem here… however in the Excel row there is a picture that needs to go with the data.

My plan is to grab the datarange of a sheet, clean it and output to a cleaned up data table. The cleaned up version I can loop through and add the records one by one into the database. Easy…

However each record set has a picture to go with it. And I can’t get my head around how to fix that.

So a typical row would look like this:

How can we make this work so the picture is kept with the record that we need to upload in the database?

[TimK (Tim Kok)]

Hi,

I would look to use VBA to achieve this particular problem.

how extract images from excel sheets

You can use Invoke VBA activity

How do I use this VBA in uipath

Hello I want to use this VBA in may workflow. but i do not know hot to use invoke code or invoke vba please help me (i want sample) VBA Option Explicit Sub split_As_per_Rows() Dim rngAll As Range Dim SplitLine As Integer Dim rowsCount As Long, colsCount As Integer Dim strPath As String Dim i As Long Dim rowsNo As Long Dim rngSplit As Range …

Thanks,
Tim

[Jacco_21Digitals]

Many thanks, that will help me in the right direction!