How to print single quote to excel where it'll be considered as text?

Help Activities
, ,
1

I’m trying to print a number into excel that starts with zeros, something 000123,
the solution I had in mind is that concatenate the number with a single quote, something like SampleInteger + “'”, but when I check the excel file. it displays 123 and no single quote was printed in the cell. How do I achieve this?

the result I’m trying to achieve:
image
image

2

Hi @wdescalsota ,

Could you try this and see if it works out for you?

(From row In dt_sampleData.AsEnumerable()
Let ls = row.ItemArray.ToList()
Let ra = ls.ConvertAll(Function(a) "'"+a.ToString).ToArray()
Select dt_Result.Rows.Add(ra)).CopyToDataTable()

ExcelUnTruncate.xaml (8.5 KB)

Kind Regards,
Ashwin A.K

3

trying, just a sec

5

sorry, currently having issues with my Generate DataTable from Text activity which is having excess rows which is a duplicate of the first row. I’ll get back to you as soon as I fix this and able to test the solution you provided. Thank you for the response, BRB

6

@wdescalsota
try this :

By saving the variable as string.
Screenshot (112)
Uploading: Screenshot (114).png…

7

the single quote trick helps to keep the leading zeros
filling up the number we can do with following:
grafik

8

@wdescalsota

Also try this :
Cint(1).ToString(“D2”)

D2-> digits you required.
Screenshot (116)