Write a list of array data in excel file row by row

Help Studio
, ,
#1

Hi
I got struck to print a data in Excel file row by row.
Ex : I have Array list of Data {“Chandu”,“siva”,“Giri”,“chinna”,“Murali”},I need to Write this array list in excel file row by row,Can Any one guide me

Thanks in advance

1 Like
#2

@bujji.chandra97 Use for each activity , inside that use write cell activity. Just increase the row number so that it does for all items in the array.

#3

Hi @Sugumar8785 I have tried this could please check this once

#4

@bujji.chandra97 could you post a screenshot? I am using community forum through mobile.

#5

There are different ways you can use. One is use ,Excel Application Scope activity, inside that add a For Each activity iterating on your array, in the Do part of your For Each, add Write Cell activity. Just remember you also need a variable to work as an incremental element to traverse through the cells.

1 Like
#6

Hi @bujji.chandra97 How many columns do u have in your datatable? If u have 5 columns then use add data row and pass arraystring to add data row.

1 Like
#7

image
image1366×768 67.2 KB

#9

@bujji.chandra97, you have initialized row number as 1. So, It takes row number as 1 every time in the loop. Assign row value the value out of the loop.

I don’t think generate datatable activity is required here.

1 Like
#10

hello,

  • you can try this use Build Data Table activity and create a column and get output as outDataTable after that use For Each Loop inside loop use Add Data Row activity and pass your string like this {item.ToString} to arrayrow property and give Datatablevariable = outDataTable

  • outside For Each Loop use Write Range activity and mention the range as well and pass your outDataTable

cheers
@bujji.chandra97

1 Like
#11

got it…! @Sugumar8785 Tnq u

#12

@bujji.chandra97 If your issue/query is resolved, please mark appropriate reply as solution so that this thread gets closed. If you still have any queries, post it here.

#13

@bujji.chandra97

THIS IS YOUR SOLUTION…

PLEASE MARK AS SOLUTION IF THIS HELPED>>>

Thanks and Regards,
@hacky

@bujji.chandra97_Solution.xaml (8.4 KB)

1 Like