Column not coming in string in excel

Help
1

I have used build data table in which rollno ,i kept string
i add data row
i have again convert that column to string

but still column is coming in int

2

If the values you put in the column are numbers, then excel automaticaly format them as numbers (move them to the right side in the cell. etc.)
If you want to make sure excel does not do this, you could add ’ before the value you put in the cell

so in code you would also have to do this same behaviour
assign:
dt(“column1”)
value:
“'123”

3

can u please provide screenshot

4

If possible can I have a view on the build datatable activity wizard that displays is the column name and Datatype
Cheers
@Ananya1

5

i have used string in that activity

but still im getting int datatype

6

May I know how you are telling that
Cheers @Ananya1

7

by checking downloaded excel sheet

8

image
image1262×648 16.2 KB

datatable has two columns of string
and in add row I add two strings
“'123” and “text”

9

hmm…it would enter as string only if the column we create is of type string
i wonder why so
fine
what is the value mentioned for Rollno column
Cheers @Ananya1

10

254 but its int not string

11

System Argument Exception: Input array is longer than the number of columns in this table.

12

how many columns does your dataTable have
You should make sure the part besteen {} has the same number of elements
so for 1 column {“'1”}
for 3 {“'1”, “'2”, “'3”}

13

4 column
2nd column should be string
plz share screenshot

14

i did this

15

image

could you sare a screenshot of how your datatable is build?

16

Capture4567

17

That is how you assign the value to the datatable
if in_MasterRow(“rollno”).ToString is a number (even when you cast it to string excel will think 123 is a number) you should do it a bit diverent if you want it to look like as string in excel
{in_sub, “'” + in_MasterRow(“rollno”).ToString, in_marks, in_grade}

What I was wondering is how your datatable looked like, to make sure the datatable columns have the datatype I am expecting them to have.
something like this
image

18

im getting same error

19

Thanks ,Its solved

i have 5 columns
{in_srno,in_sub,“'” +in_MasterRow(“rollNo”).toString,In_marks,in_Grade)

but sr_no is not getting updated

20

Glad it is resolved