From where you are populating this excel,
Through regular expression I’m writing into Excel.
You have activity called Formet Cells in Modern Excel
To enable Modern
Go to → Activities Panel → Click on Filter → Select Show Modern.
Use this in source
Excel.Sheet("SheetName").Range("A:A")
Regards
Sudharsan
how can i take dynamic Range?
You can use LookupRange Activity and search for the Column header @Manju_Reddy_Kanughula
Lookuprange will get you the address of the column like A1 from that string you will get only the alphabet and giving it as range
Excel.Sheet("SheetName").Range(System.Text.RegularExpressions.Regex.Match(String2,"\D+").ToString+":"+System.Text.RegularExpressions.Regex.Match(String2,"\D+").ToString)
Here String2 is the Variable from the Lookup range
Regards
Sudharsan
It can be easily done using the VBA code.
For that we should enable the developer access to Excel application in the environment.
-
The design for your requirement
-
Save the VBA code in your location with extension .vba [Ex: ConvertSpecificColumnTONumberFormat.vba]
Code:
Function ConvertColumnToNumberFormat()
ActiveSheet.Select
[A:A].Select
With Selection
.NumberFormat = "General"
.Value = .Value
End With
End Function
[A:A] is your column where you need to convert the column to number format.
Please let me know if your need additional details.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.