How to write extracted data in particular row of excel

Learning & Development Programs Automation Starter
1

Hi all,

Data extracted and writing in excel file but its not writing in specific row.
Say I have 2 rows of data 1st row is header and next 2 rows are extracted data.
Column D is my extracted data column, it should write on D2 and D3 but its writing on D4 & D5.

write range is inside for each loop.
And i have used 2 read range. 1 is Dt-temp, another is Input_DT.
{“”,“”,“”,GetText_EN.Trim.ToString} => array row.

What changes i need to do, please help.

Thanks,
Lakshmi

2

Hey!

Have you checked the data table before writing it in to excel?

Are we getting the data in the D2 and D3?

Use Output DataTable and pass the input as extractedDataTable and output as String…

Now you can use Write text file activity and check whether it is extracting the data or not?

Regards,
NaNi

1 Like
3

Hi @THIRU_NANI ,
Data is extracting perfectly, but writing on D4 , D5 where D2, D3 are blank

Regards,
Lakshmi

4

Hey ,

You want to write for particular Column with particular cell then you can use write cell activity
and you can set the counter for each column.

It will work

Thanks

1 Like
5

Hi @lakshmi.mp

You can use the For Each Row in Data Table activity to iterate through each row of the table in which you want to insert the extracted data

Inside the For Each Row Scope use the assign activity to provide the extracted value to the respective column

image

Use the Write Range Activity to write the data table to the excel file

Refer the xaml

WriteExtractedDataInRow.xaml (8.7 KB)

1 Like
6

Hi,
Its working now. @kumar.varun2 , thanks for providing solution.

Thanks,
Lakshmi

7

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