Hi Team,
I want to convert a column from general to text type in an excel sheet. Could anyone let me know how to do that in uipath?
Thanks,
Ula
Hi Team,
I want to convert a column from general to text type in an excel sheet. Could anyone let me know how to do that in uipath?
Thanks,
Ula
Can i convert my column format in an excel using invoke code in vb.net?
Hi @Boopathi
yes
Thanks
Ashwin S
Hi @AshwinS2
Thank you. Can you point me the source for that or some site… i am checking in web for that code
Thanks,
Ula
Hi @Boopathi
Check this
Dim Limit As Long
Limit = ActiveSheet.UsedRange.Rows.Count
Range(“M2:M” & Limit).Select
For Each Cell In Selection
Cell.Value = Val(Cell.Value)
Next
Selection.NumberFormat = “General”
Thanks
Ashwin S
Are you facing any error while processing ?
if you face any error please use preserve format option in the properties pane