How to find this Excel Sheet To Image activity

how to find this activity in UiPath or which package to install to get this activity Excel Sheet To Image

@Gomathi_Ganesan

There is a marketplace component you can download from there and load into UiPath from manage pckages

Or other option is

  1. In excel activities you will have excel to pdf
  2. And then if you install pdf activities you have pdf to image activity

You can use a combination

Cheers

Hi @Gomathi_Ganesan

There isn’t a built-in activity in UiPath for converting an Excel sheet to an image. However, there are a few ways to achieve this using UiPath.

One option is to use the “Take Screenshot” activity to capture an image of the Excel sheet while it’s open on the screen. You can then save the screenshot as an image file using the “Save Image” activity.

Thanks!!

1 Like

OKay thanks for the tip will try it

Hi @Anil_G i have installed excel range to image in windows legacy but i needed this in windows format so when i converted this and im getting error as activity is either missing or could not be loaded properly so may ask me why i needed to i convert this windows its because i wanted to use this acivity in existing windows project and i would use nupkg as activity for my windows project

@Gomathi_Ganesan

  1. In windows compatibility this activity is not available…

So you need to go with the second option…of using excel to pdf and then pdf to image

Cheers

1 Like

@Gomathi_Ganesan

You can try VBA code for this

Save the below code in a txt file

Public Function TakeScreenshotTable(InputTarget As String) As String
'
' Take Screenshot Function
'
'

    arrayTarget = Split(InputTarget, ";")
    Dim i As Integer

On Error GoTo ErrorHandler

    For i = 0 To UBound(arrayTarget)
        Dim aChart As Chart, Rng As Range, Path As String, SheetName As String, SheetRange As String
        SheetRangeName = Split(arrayTarget(i), ",")
        SheetName = SheetRangeName(0)
	SheetRange = SheetRangeName(1)
        Path=SheetRangeName(2)
	
	if Len(Path)=0 Then
        Path = CreateObject("WScript.Shell").SpecialFolders("Desktop") & "\" & "Capture" & i & ".jpg"
        End if 
	Range(SheetRange).EntireColumn.AutoFit
	Set Rng = Sheets(SheetName).Range(SheetRange)
        Call Rng.CopyPicture(xlScreen, xlPicture)
        With Sheets.Add
            .Shapes.AddChart
            .Activate
            .Shapes.Item(1).Select
            Set aChart = ActiveChart
            .Shapes.Item(1).Line.Visible = msoFalse
            .Shapes.Item(1).Width = Rng.Width
            .Shapes.Item(1).Height = Rng.Height
            aChart.Paste
            aChart.Export (Path)
            Application.DisplayAlerts = False
            .Delete
            Application.DisplayAlerts = True
        End With
    Next
TakeScreenshotTable="Success"

ErrorHandler: ' Error-handling routine.
if err.number<>"0" then
TakeScreenshotTable="Failed "& Err.Number
end if

End Function

Now use Invoke VBA activity and in properties EntryMethodName is TakeScreenshotTable
EntryMethodParameters are {SheetName, SheetRange, PathoftheJpgFileName.jpg}

Sheet Range → A1:F10

Hope this may help you

Thanks,
Srini

2 Likes

Couldnt find excel to pdf

Thank u so much @Srini84 will try and let u know

@Gomathi_Ganesan

This is the activity

https://docs.uipath.com/activities/docs/save-as-pdf-x

Cheers

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.