Uipath Marketplace
MarketplaceStudioアクティビティPrint to Image from Microsoft Excel File

はじめてのオートメーションをわずか数分で作成できます。Studio Web を試す

Print to Image from Microsoft Excel File

Print to Image from Microsoft Excel File

作成者: Internal Labs

4

アクティビティ

ダウンロード数

14.1k

Neha Patel
5 months 前に投稿

Hello, When I am downloading this file it is in the .nupkg format. How to convert it to other format and use it in our system ?

Octavio Elliot
2 years 前に投稿

Hello,

I have been using the activity and it works fine locally but when I test in other machines it breaks with the following message.

Both studio / excel versions are the same. Any thoughts? I was hoping I could check the source code to try to fix it.

Private: Excel Sheet To Image (ExcelSheetToImage): CopyPicture method of Range class failed

Thank you very much,

Octavio

Adit Kansara
3 years 前に投稿

Hello, 

I have been using this activity since last year and it was working fine. But, last month I encountered following exception: 'Excel Sheet To Image: The server threw an exception. (Exception from HRESULT: 0x80010105 (RPC_E_SERVERFAULT))'

Can you please help me with this?

Thanks,

Adit

niji das
4 years 前に投稿

Can we use this activity to get image of ondrive excel?

Daniela Dumitrascu
4 years ago 前に投稿

In case the Excel file is on Sharepoint, you can use Sharepoint activities to download it and use the activity on the local copy of the file. In case you already have a local copy of the file, no need to download it, just use the activity on the Excel file.

Harish Suramsetti
5 years 前に投稿

Hi Daniela,

Thanks for this custom activity. It saved a lot of time in my development. But i have a concern in this, sometimes i am getting an error "Object reference not set to an instance of an object. Source: ExcelSheetToImage".

I have used this activity at multiple places. The above error is coming randomly.

Can you please help on that.

Thanks,

Harish

Daniela Dumitrascu
5 years ago 前に投稿

Hi Harish,

Please provide more info (using Report a Bug) on the issue. Please also indicate if you use the last version (v4) of the activity.  Is it possible to provide a short workflow or details on how to reproduce (if it is random, it might not be possible)? Also, please look into the Execution logs and extract the whole error message along with the position in the source code where the error occured.

As a workaround, you could use the activity in a Retry Scope activity (so if it fails the first time, the second time it might work fine).

Thank you,

Daniela

Krishna C
5 years 前に投稿

Hey @Daniela Dumitrascu

I'm getting this error. 'Excel Sheet To Image: Unknown file extension' 

Can you tell me what is the issue?

Daniela Dumitrascu
5 years ago 前に投稿

Hi @Krishna C,

Please check the user manual (it is attached on the right side of the webpage under Resources). The image file path should be something like "c:\temp\Image.jpg" (The supported image file extensions are: Bmp, Exif, Gif, Jpeg, Jpg, Png, Tiff.)

Regards,

Daniela

Pawel Trojanski
5 years 前に投稿

Daniela,

I think that the "Image File Path" argument is in wrong Category as this is clearly InArgument. 

This is a bit confusing. "Image File Path" is not something what is produced by the activity. It's something  that is required to save the image in a specific location, otherwise the activity won't save the image and will only return an Image object instead.

Cheers,

Pawel

Daniela Dumitrascu
5 years ago 前に投稿

Hi Pawel,

You are correct, thank you for your feedback. I intend to update the activity and provide the fix in a new version of the package.

Thank you,

Daniela

Pietro Ascione
5 years 前に投稿

Ciao 

I have excel with password, there is a way to use with this kind of file? i would open as readonly. 

thanks

Pietro

Daniela Dumitrascu
5 years ago 前に投稿

Hi Pietro

In this version of the Activity we do not have support for Excel files with password (we'll consider it for the future improvement of the activity).

For now it can be used as follows:

  1. Use Parallel activity

  2. On first brach use "Type into" activity for typing the password

  3. On second branch use "Click" activity for clicking the OK button

  4. On third branch use 'Excel Sheet to Image' activity for processing the excel file with password

 

I hope this was helpful.

Regards,

Daniela

Bogdan Jianu
5 years 前に投稿

Hi Daniela,

Is there anyway to see the source code of this activity? It works well for our purposes but it is a requirement that we can visualise the source code for security purposes.

Thank you.

Daniela Dumitrascu
5 years ago 前に投稿

This request was addressed.

Kazuyoshi Kiyota
6 years 前に投稿

Hi Daniela,

Can you tell me how I can take out graphs which I have already made by Excel ?

I've already done this activity. But The images of the graphs are not updated to reflect date values in Excel.

I am sorry that my English is so bad.

Regards.

Kazuyoshi Kiyota

Daniela Dumitrascu
6 years ago 前に投稿

Hi Kazuyoshi,

The activity should save to image the range exactly as what you see when you open the Excel file on the given sheet. I only noticed that when you modify the data in Excel, and you do not save the Excel file, the chart will show the old values in the saved image (even if in Excel the chart shows the updated values). I did not encounter your use case, isn't it a save/refresh available so that the graphs/charts will be updated?

Regards,

Daniela

David Chen
6 years 前に投稿

Hi Daniela,

Can you tell me what should go into the "Image File Path" and "Resulting Image"?

Cheers

DC

Daniela Dumitrascu
6 years ago 前に投稿

Hi David,

The arguments for this activity are:

Input:

Excel File Path (required): String

Excel Sheet Name  (required) : String

Sheet Range  (required): String

Output:

Image File Path: String  

   file full path or relative file path

Resulting Image: System.Drawing.Image

The image format depends on the file extension of the image file indicated in the Image File Path input argument. The supported image file extensions are: Bmp, Exif, Gif, Jpeg, Jpg, Png, Tiff.

If you want to save the image as Jpeg, you can specify for Image File Path something like "c:\Images\image1.jpeg" or System.IO.Path.GetFullPath(folderPath) + "\image2.jpg"

If you want to save the resulting object Resulting Image, you can create a variable using Ctrl+K in the Resulting Image property field (this is an optional argument). You could use this object with Save Image activity, later in your workflow.

Regards,

Daniela Dumitrascu

公開者

Internal Labs

公開者ページを表示

ライセンス契約とプライバシー条項

ライセンス契約

プライバシー条項

技術情報

バージョン

1.0.0.5

更新日

2023年4月6日

対応製品

Studio: 22.10+

認定

シルバー 認定済み

アプリケーション

Microsoft Excel

サポート

UiPath コミュニティ サポート

リソース