How should i format a column

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 @Ula

Use Convert.ToString(Dt.Columns(“Column1”).ToString

Thanks
Ashwin.S

Can i convert my column format in an excel using invoke code in vb.net?

Hi @Ula
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 @Ula

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