3363838a-aca6-487c-9e59-3e2fd839ef60.jpg

Hexaware is a global leader and the fastest growing next-generation provider of IT, BPO and consulting services. We are a team of seasoned IT practitioners, distinguished engineers and ‘Automateers’ (our employees with a deep-rooted passion for automation), striving as the customers’ trusted partner and delivering the best possible solutions using digital technologies.

System Analyst

4d19ff2e-fe98-4584-bfe7-067819bf702a.png

This package contains the following activities:

  

*   **Read PowerPoint** - Returns text from all slides.

Input:

a. FilePath

b. Password

  

Output: OutputText as string

  

*   **Read slide** - Returns text from a given slide.

Input:

a. FilePath

b. SlideIndex (comma separated, default all)

c. Password

  

Output: OutputText as List

  

*   **Delete slide** - Delete slide from PPT.

Input:

a. FilePath

b. SlideIndex

c. Password

  

  

*   **Get slide count** - Return total number of slides available in PPT.

Input:

a. FilePath

b. Password

  

Output: SlideCount

  

*   **Export PPT to PDF** - Export PPT to a PDF file.

Input:

a. OutputFilePath

b. PPTFilePath

c. Password

  

  

*   **Insert new slide** - Insert new slide in PPT.

Input:

a. FilePath

b. SlideIndex

c. LayoutSlideIndex

d. Password

  

Output: OutputText as string

Set of activities to work with PowerPoint.

This activity has been built to adjust Excel column width.

The following activities are available:

*   All column autofit: Sets auto fit to the entire column in the provided Excel sheets.

Input:

A. ExcelPath: Full path of the Excel file.

B. SheetName: Add the sheet name separated by commas. If left blank it will consider all the sheets available in the Excel.

*   Column autofit: Sets auto fit to the provided column range in the Excel sheet.

Input:

A. ExcelPath: Full path of the Excel.

B. ColumnRange: Enter the column range that needs the width to be set as autofit.

e.g. – “A1:A1” , “A1:C1”

C. SheetName: Add the sheet name separated by commas. If left blank it will consider all the sheets available in the Excel.

*   Set column width: Set a fixed width to specific columns.

Input:

A. ExcelPath: Full path of the Excel.

B. ColumnName: Add the column name separated by commas.

C. SheetName: Add the sheet name separated by commas. If left blank it will consider all the sheets available in the Excel.

D. Width: Width of the column.

Excel column width adjustor as per requirements

About me