I have to write in already existing excel in specific coloumn

Help Studio
, ,
1

I got output like

I have to write in already existing excel in my specific coloumn

image

thanks
shaik

2

Hi @shaik.muktharvalli1,

Are you reading your excel file into a DataTable? If so, you could try the following:

image

3

Hi @shaik.muktharvalli1

You can use append range workbook activity to write the append the data in the existing excel.

It’s better to share the input files or images for our better understanding.

4

Not working @mkankatala

1 Like
5

No, take output and feed into specific coloumn

thanks
shaik

6

Could you share the input file and required output for our reference. Then we will get better clarification your requirement… @shaik.muktharvalli1

7

My array of sring output like

1
2
3
4

Then I have to feed into them in specific column

image

In tadig column I have to feed

thanks
shaik

8

Okay @shaik.muktharvalli1

→ Store the Array of items in Array of String datatype variable, let’s call the variable name as Arr_Items.
→ Take an assign activity and create a int32 datatype variable called Count and initialize as 2.

- Assign -> Count = 2

→ Use Excel process scope activity and insert the Use excel file activity and pass the excel file path.
→ Inside Use excel file activity insert the for each activity to iterate the each item in the Array_Items variable. Output of Foreach is CurrentItem.
→ Inside for each insert Write cell activity and in the what to write field pass the CurrentItem and in the Where to write field give the range as below,

Excel.Sheet("Sheet Name").Cell("C"+Count.toString)

→ After write cell activity insert the Assign activity to increment the count.

- Assign -> Count = Count+1

Check the below workflow for better understanding,

Regex_Practice
Regex_Practice848×1523 107 KB

Hope it helps!!