Get all the row text with data table

Help Forum
, , , ,
1

I am using data table and for each row, i need to copy all the row one by one in a excel file

image
image1161×577 18.7 KB

2

You can use Excel Application Scope followed by Append Range activity. But to use that you need to create a temp datatable and add current row to it. Attached is sample workflow.
NewProcess.zip (10.6 KB)

3

i can’t open the workflow

image
image1311×271 52.4 KB

4

are you facing any issues here?

5

Hi @Soudios

Can you give some more details

6

yes can’t open the document so the solution is not found yet

7

i want to get all the row from the data table and paste it in a excel file

8

Hi @Soudios

have you tried using the Write Range Activity or Append Range

9

Search for linq query, Newdt=datatable(function(row) row(“Name”).copytodatatable.

Write range activity, use Newdt

10

i never use linq query can you show me plz

11

Hi there, if you want to copy all the row in data table to an excel file, you just simply use “Write Range” inside “Excel Application Scope” like this
dt img

12

@Soudios Check this,
NewProcess_Legacy.zip (2.9 KB)

13

The result is not an index

image
image1265×833 136 KB

14

Hello Sou,

Sorry, I did not get you. Can you please elaborate?