Print to Image from Microsoft Excel File

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 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

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

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

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

This request was addressed.

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 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