Modernview: Excel Write stream or write cell?

Help Studio
1

Hi All,

I am using modernview I am using excel read stream to use data table in for each loop. I am fetching order id from excel and searching in order application search box. If found it iterate the loop. Excel contains 3 column order, id, can number. No header stored. Now I have to add 4th column to update whether it is found or not. I tried write cell and write stream not working. Seeking your expertise please how to sort this scenario out.

2

Hi @Sathish_Ashokan

To add 4th column you can use Add Data Column for that. Specify the column name and to which data table you want to add that column
image

Hope it helps!!
Regards

3

how to add without column name. After add column, write stream to update to excel?

4

@Parvathy Thanks alot it is working perfectly fine.

1 Like
5

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