b900108b-d194-48f9-b24c-e8a3981d6581.png

Senior Consultant

This package includes the below activities that can handle the Aggregation, Cumulative, Add - Delete row range and Export to Xml:

Add Data Row Range.

Remove Data Row Select.

Group By Aggregation (Sum,Count,Avg, Max, Min).

DataTable to XML Document.

DataTable to XML File.

Sum,Count,Avg, Max, Min.

Native Group Aggregation - To aggregate multiple columns with multiple functions like (Max(Price),Min(Qty),Sum(Value)) - Check the document attached.

Custom Activities including the Aggregation, Cumulative and Export to Xml

This package includes the following activities that can handle the Aggregation, Cumulative, Add / Delete row range and Export to XML:

*   **Add Data Row Range** - allows users to easily add rows of data to a specified range.
*   **Remove Data Row Select** - provides an efficient method for removing selected rows from a range.
*   **Group By Aggregation** (Sum, Count, Avg, Max, Min) - offers a range of aggregation functions, including Sum, Count, Avg, Max, and Min, helping with data analysis.
*   **DataTable to XML Document** - helps users export data to XML documents.
*   **DataTable to XML File** - exports data to XML files.
*   **Sum, Count, Avg, Max, Min** - helps with calculating numerical data.
*   **Native Group Aggregation** - aggregates multiple columns with multiple functions like (Max(Price),Min(Qty),Sum(Value)).

Please check the document attached in the Resources section for more details about how the activities can be used.

Custom activities including Aggregation, Cumulative and Export to XML file.

The **Windows Service Activities** package contains the activities to control the Windows Service and get the information like status and description related to Windows Services.

1.     **Service Execute** – Using this activity, you can start, stop, pause and continue the Windows Service.

2.     **Service Status** - Using this activity, you can get the status of the Windows Service.

The purpose of these activities is to automatically convert PDF files to Word documents.

  

**Properties:**

  

1. **PDFFilePath** – PDF file full path.

2\. **WordFilePath** – Specify the Word document file full path.

3\. **WordFilePassword** – Maintains the password of the Word document file.

This activity simplifies the conversion of PDF files to Microsoft Word.

The activity will create an instance of PowerPoint depending on the file path. An empty slide will be added and then the application will close. This is meant to be used when the amount of slides in a presentation is dynamic.

*   **Delete Slide** - Delete the specific slide using slide Index.
*   **Export To PDF** - Export the PowerPoint file to PDF file.
*   **Insert Picture** - Insert the image in a specific location with size.
*   **Insert Slide** - Insert a new slide.
*   **Create PowerPoint** - Create a new PowerPoint file.

The package is meant to automate building out and changing content on a PowerPoint presentation

c7942eeb-09df-4d80-bb65-2655e887c75d.png

The package is meant to automate building out and changing content in a PowerPoint presentation.

This custom activity automates the creation of charts inside an Excel sheet.

  

**Properties:**

  

1\. **Cell Range** - Specify the data range for the Excel sheet.

2\. **Chart Title** - Title for the chart.

3\. **Chart Type** - Supports 26 chart types.

4\. **File Path** - Excel file full path.

5. **Image Copy** – Specify the path where the chart has to be saved as an image.

6\. **AutoText** \- Automatically generates appropriate text based on content.

7\. **DataLabelsType** - \[ShowNone, ShowValue,ShowPercent,ShowLabel, ShowLabelAndPercent, ShowBubbleSizes\].

8\. **Had Lead lines** - if the series has leader lines.

9\. **Legend Key** - Show the legend key next to the point.

10\. **Separator** \- The separator for the data label.

11\. **Show Bubble Size** \- The bubble size for the data label.

12\. **Show Category Name** - The category name for the data label.

13\. **Show Legend** - True to show the legend to the chart.

14\. **Show Percentage** \- The percentage for the data label.

15\. **Show Series Name** \- The series name for the data label.

16\. **Show Value** \- The value for the data label.

17\. **Sheet Name** - Excel book’s sheet name where the data exists.

18\. **Size** \- Height, left, top and width are for the position and size of the image.

By using this activity you can create Pie, Column, Line and Bar graphs.

A single activity can able create multiple charts like (Pie,Column,Line and Bar graph)

Using this activity can create the Pie,Column,Line and Bar graph.

This package contains the activities described below that make it easy to retrieve the data from the Informix database. You can use also the stored procedure.

1.**Execute DataTable**

This brings the information from database even you use the direct query or stored procedure.

2.**Execute NonQuery**

It helps to execute the To insert , update and delete statements.

3.**Execute Scalar**

Returns the first column of the first row in the result set returned by the query or stored procedure as Object.

A simple way to communicate with Informix database

34474b4d-c6a1-4b62-9863-5119104426f0.png

This activities package facilitates the following:

*   **Local Printers** - Obtain all the local printers names which are installed on the local machine.
*   **Network Printers** - Obtain all the network printers names which are connected to the current machine.

This component helps with retrieving the local and network printers' names.

This component facilitates the following:

**Local Printers** \- Obtain all the local printers names which are installed in the local machine

**Network Printers** - Obtain all the network printers names which are connected in the current machine.

This component helps with retrieving the local and network printers' names

This package includes the below activities that help you easily automate printer related processes:

  

1.  **Clear Printer Queue**
2.  **Default Printer Status**
3.  **Get Default Printer**
4.  **Local Printers**
5.  **Network Printers**
6.  **Pause Printer**
7.  **Printer Command**
8.  **Queue Data**
9.  **Resume Printer**
10.  **Set As Default Printer**

**Image Extract** - It extracts all the images into a folder from the PDF file

**Pdf Splitter** \- Split the page from PDF file using the this option of EachPage , EvenPage , OddPage and PageRange

**SetPassword** \- Set the password to a new PDF file.

**PageCount** \- Get the Total page count. In the video below you can see the demo.

This package simplifies the image extraction from a PDF file, split and set the password

83f8bb0f-b686-4b48-86de-8a791e6c105a.png

Converts the numeric value of this instance to its equivalent string representation specified in the format property

This package contains 2 activities that convert numeric to the desired format:

1.  **Double Formatter** - Converts double value to the desired format.
2.  **Number Formatter** - Converts the integer value to the desired format.

Converts the numeric value of this instance to its equivalent string representation specified in the format property.

About me