Error in write range

Learning Initatives Automation Starter
1

image
image1177×238 15 KB

i am taking string text and write in excel but its show me error

2

@Kuldeep_Pandey you can not write string, your variable is string type please change it to datatable

3

what i have to write?

4

In write range you can write only datatable, please change Type of out1 to DataTable

5

@Kuldeep_Pandey, Can you elaborate what are you doing and what you want to do.

6

image

image
image1162×179 8.57 KB

i am going on a page and taking one text and write it in a excel sheet

7

@Kuldeep_Pandey Use "Append Line Activity " if you want to add just one text

8

you are getting one text so it will store in String then you can’t use in Write range because Write range is taking input as DataTable. So please use append line activity to write string.

9

how to use give example

10

so i can write the data in excel

11

WriteLine.xaml (7.5 KB)
please follow this one with generic.

Explanation,
1-Build DataTable DT1
2-Give suitable column name
3- after getting text put add data row.
4- give text and datatable DT1 to Adda Data Row Activity
5-Then Write DT1 through Write Range

12

@Kuldeep_Pandey
WriteLine.xaml (7.7 KB)
updated file

13

like i am not able to understand
any simple expression to convert string data into data table?

14

@Kuldeep_Pandey Its simple way, can you share your code please

16

@Kuldeep_Pandey
please run this
Resource Utilization.xaml (169.3 KB)

17

so i have to ADD 3 data row ?

18

becz i want to write 3 text in different column

19

@Kuldeep_Pandey
add two more columns in DT1 by editing build data
pass array like {Out1, Out2,Out3} in data row

20

@Kuldeep_Pandey
Resource Utilization.xaml (169.6 KB)
updated code

21

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.