navodya1215
(Navodya Sankalpa Matharage Don)
January 14, 2020, 9:00am
1
Hi,
I have a question about excel formatting automation
Given a cell address, I want to strike-through half of the content in that cell.
Ex: C11 cell has the value “AAA BBB”. This should change into " AAA BBB"
Thanks in advance
1 Like
Hi,
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 e…
Go through this it may help you
2 Likes
balupad14
(Balamurugan (BalaReva))
January 16, 2020, 5:10pm
3
Thank you @Pradeep_Shiv ,
Here can get the detail about the activity.
Hi ,
I have developed new activity called “Cell Font” in the version 5.0.0 . In this activity that can able to change the below things inside excel sheet.
Font Name
Font Size
Font Style { None,Regular,Bold,Italic,Underline}
Font Color - System.Drawing.Color
Font UnderLine { None,Double,Double Accounting,Single,Single Accounting }
Strikethrough { None,Yes,No}
Font Script { None, Superscript,Subscript }
Namespace
[image]
Properties :
[image]
Before Sheet :
[image]
After Sheet :
[…
Regards
Balamurugan.S
1 Like
navodya1215
(Navodya Sankalpa Matharage Don)
January 20, 2020, 7:16am
4
Hi @balupad14 ,
Sure I will go through
Thanks
1 Like