How to format excel sheet data from generic to text

Help Studio
, ,
1

How to format excel sheet data from generic to text

I have an excel where all the data in sheet one is in “Generic” format. I need to change the entire data to “text” format. How can I do that?

I can’t use VBA code since macros are not enabled here due to security reasons. I can’t use balareva or any other packages except uipath or Microsoft packages due to security reasons

2

One way is to utilize the =Text() formula in excel, using that u can convert a cell value to text

Refer this

TEXT function.

You can use write cell under excel application scope to write this formula

Thanks & Regards,
Nived N

3

Hi, i need to do ghe entire sheet… is it possible to do it in one go? Like may be using Vb.bet or any other vb expressions?

4

@Krithi1 Try the below one

5

@ushu

I cant use balareva activities because of security reasons. I can use uipath activities or vb.net

6

(From r in DT.Asenumerable
Let a = r.itemarray.select(Function(v) v.Tostring.Trim).Toarray
Select DT2.Rows.add(a)).copytodatatable

7

@Gangadhar_Athili – could you be able to send me the workflow?