I have developed some activities to make easy excel automation.
Package manage Search keyword: Balareva.easyexcel
An activity library that makes Excel automation very easy
This package contains activities that will help automate your work with Excel. The below activities are available:
- ExtractGraphImage - Extracts graphs available in a specific Excel and converts these into images.
- ExtractHyperLinks - Extracts hyperlinks from a specific cell range within a given Excel sheet.
The extracted information will be saved in a given folder.
- MoveSheet - Order or arrange sheets inside a workbook. [optional : Initial Sheet Name (":First"/":Last" ) ]
- ColumnMove - Move the columns inside sheet.
- Paste From Clipboard - It pastes the clipboard data into the excel sheet (like excel data ,sap data or image)
- Copy ToClipboard - It copies the data to clipboard
- Find - It finds text inside excel and return the cell info as array and row index as array
- FindReplace - It replace the text with give the property.
- FindLastRow - It finds the last row of the sheet. I never uses the cell range.
- FindLastColumn - It finds the last column of the sheet. I never uses the cell range.
- CellFont - Change the Font name, Size, Style, Underline, Font Color ,Effects to the cell or cell range.
- Get Table Names - It gets the table from the sheet . It is very useful for sorting data activity.
- Delete Column - It deletes contiguous Columns inside excel sheet.
- Delete Rows - It deletes contiguous Rows inside excel sheet.
- Get TableName - Return table name . it helps to very the table exists or not before do the sorting.
- Cell Font - It is an activity to change the Font Name,Size,Style,Color,Underline,Strike through,Script.
- Refresh all - It refresh the pivotal table.
- Freeze Columns - To freeze and unfreeze the columns
- Freeze Rows - To freeze and unfreeze the rows.
- Insert Hyperlink
- Get Hyperlink
- Remove Hyperlink
- Get Column Index - Get Column index by column name
- Get Column Name - Get Column name by column index
- Sorting - It has a great feature that can do the sorting by multiple columns.
- RemoveFilter - Remove / Clear filter (Table Index : -1 = clear all table filter , 1= clear first table filter)
- RemoveNonTableFilter - Remove / Clear which is not having the table format to filter
- Image Extractor - Extract the images by index
- Image Delete - Delete / remove the image by index
- Image Exists - Verify that the image exists or not by index
- Image Delete - delete the image by index
- Copy As Picture - Copy as Picture to the selected range of cell (Optional: Save as picture file )
- Format Painter - Copy the formatting from one item to another.
- ChartImageExtract - Extract the charts as image with index
- ChartFormat - Align the chart with top, left, height and width.
- ChartDelete - Delete the chart
- ChartCopyToClipboard - copy the chart to clipboard
- ChartEmbedToPowerPoint - Embed the excel chart into PowerPoint.
- Tab Color - Change the tab color
- Freeze Panes - To freeze the column and row
- Select Cell - Select or activate the cell
All the activities work inside the BalaReva Excel Scope. Except for Zesty activities
If the Sheet Name is empty, Automatically it will take the first sheet.
If the Cell Rang is empty. It will take the used range automatically.
Install the package in local :