I am Reading a column in Excel & I have given out argument & I can read the data successfully, but entering those values into other excel getting error writing like"System.Object[]"

output Excel
image

Hi @Manju_Reddy_Kanughula

Add the extracted data in another dataTable and then use write range to write the data table into another Excel file.

Hope it helps,

2 Likes

Hello @Manju_Reddy_Kanughula ,

Please share the screenshot of the Write range Activity.
(Make sure after reading you assigned to DataTable variable and you have used DataTable variable in write range as well)

Regards,
Rohith

image

I Could read the data also

image

@Manju_Reddy_Kanughula

You are reading column values and storing the data in IEnumerable
and while writing u need to loop through these items (to update 1 value per cell.

Use for loop and loop through items of OT_Rate (IEnumerable)
and inside for loop use write cell to write each item in a cell.

Let me know if you need an example for this.

Regards,
Rohith

what should I type in variable section

image

Hello @Manju_Reddy_Kanughula ,

Use Write cell instead of Write Range.
image

It coming blank

image

image

@Manju_Reddy_Kanughula - Make sure you have used the correct Index (As you have mentioned Column U in your code).
Also you have to increment the int_RowIndex value, while updating the value in next cell else it will over write in the same cell.

Try using write line and print the value of item.ToString and int_RowIndex+5.

Every Time U5 only it is taking

image

@Manju_Reddy_Kanughula
In for each Create a Index variable (Type Int32)

In Wrote cell use : ā€œUā€+(Index+2).ToString
as given in below image it will work for you.

Excel file where i need to write but it is not writing

For eac h activity

able to read the data & Row

image

@Manju_Reddy_Kanughula - Everything looks good here, even the cell index and values are printing.

just verify the file name / path is correct and it is the one which you are referring now.
(Put a message box and print)