Takes a photo of an excel sheet

Help Studio
, , ,
1

Hello everyone,

I would like to take the data from an excel sheet and insert it into a word file (which already has a claque) to extract it as a PDF.

My problem is that the database is too large, so it’s impossible to have everything on a single PDF page.

So I thought of another solution, to make a screenshot of my excel file and insert it into the word file, then export it as a PDF.

I’ve found the Excel Sheet To Image activity but I don’t know how to insert it afterwards in word, do you have any ideas?

Thanks

2

or do you know how to take cell A8 to E30, for example, and make a special paste image in Word?

3

The standard word activities have no ‘insert image’ option as far as I know.
This would mean either search for some less official packages that can facilitate image insertion, or use invoke code to insert an image. I’m sure ChatGPT can give you a code example on how to do that.

I also used another approach for a client. There was a nice-to-have feature to have a specific image on the front page of a report the bot creates. The image would be customer and product dependent so pretty much different each time. Since I used a document template to create the report, I created the front page included an empty / white image on the desired location. Teen using the standard activity replace image I was able to fulfil the requirement with the dynamic image.

Alternatively, if all of the above is not useful, one last thought:
If you have your excel table / sheet, print it, Use a default pdf printer and print the sheet or selection to a pdf file. Then, merge this pdf in your main and final pdf file using the various split/merge pdf activities.

4

Hi @Maxime_LAUGIER

Can you try below

The image depicts an automation sequence that uses UiPath to copy and paste a range from an Excel file, take a screenshot of the copied data, and insert the screenshot into a Word document. (Captioned by AI)
The image depicts an automation sequence that uses UiPath to copy and paste a range from an Excel file, take a screenshot of the copied data, and insert the screenshot into a Word document. (Captioned by AI)818×1996 92.7 KB

Sequence13.xaml (24.3 KB)

Regards,

5

Hello,

Thank you for your answer.

One question, in your Add picture activity, you have ImgPath, where this is come from?
I can’t open your sequence

Thanks

6

@Maxime_LAUGIER

This image shows a sequence in UiPath Studio for automation, where a selected range in Excel is clicked and then a screenshot is taken and saved with the file path indicated. (Captioned by AI)
This image shows a sequence in UiPath Studio for automation, where a selected range in Excel is clicked and then a screenshot is taken and saved with the file path indicated. (Captioned by AI)1459×741 60.5 KB

Regards,

8

An error message in UiPath indicating that it could not attach to any existing Excel instances, as no Excel instance is found or visible in the system. (Captioned by AI)
An error message in UiPath indicating that it could not attach to any existing Excel instances, as no Excel instance is found or visible in the system. (Captioned by AI)1423×634 63.7 KB

It’s very strange, my excel is open with the correct file

9

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