サインイン
はじめてのオートメーションをわずか数分で作成できます。Studio Web を試す →
Print to Image from Microsoft Excel File
作成者: Internal Labs
4
アクティビティ
14.2k
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 ?
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
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
Can we use this activity to get image of ondrive excel?
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.
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
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
Hey @Daniela Dumitrascu
I'm getting this error. 'Excel Sheet To Image: Unknown file extension'
Can you tell me what is the issue?
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
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
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
Ciao
I have excel with password, there is a way to use with this kind of file? i would open as readonly.
thanks
Pietro
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:
Use Parallel activity
On first brach use "Type into" activity for typing the password
On second branch use "Click" activity for clicking the OK button
On third branch use 'Excel Sheet to Image' activity for processing the excel file with password
I hope this was helpful.
Regards,
Daniela
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.
This request was addressed.
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
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
Hi Daniela,
Can you tell me what should go into the "Image File Path" and "Resulting Image"?
Cheers
DC
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
