Write Into -Target cell

Help Studio
, ,
1

Hi all,

I have workflow that will write a DataTable into a excel starting from Row 4…

So I’m doing,

For each CurrentRow in MyDataSet
WriteInto “A4” >> ColumnData1.toString() …

Its working fine until when the dataset is larger than the rows visible in my Excel. When column A4 is no longer in view, the WriteInto is stuck as well.

Anyone has workaround or solution on this please ?

Thank you.

2

Hi @jaxng

Can you share the screenshot of the flow or else can you attach the xaml file ?

Regards

3

@jaxng

You need not use a for loop to write the datatable to excel…you can use a write range or append range activity to write the datatable to excel

Cheers

4

This probably my last resort, need to rebuild the flow. Meanwhile trying to see if any quick fix on current design.

5

@jaxng

This is the quickest fix…all the loop and all can be avoided

cheers

6

Hi @jaxng

There is no need of For each loop you just need to use write range activity and pass “A4” in range
It will write the whole data in your excel file and its the quickest one.

Thaks!

7

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