Changing Excel file column value

I have one excel file with some columns.
I am reading the few columns from that excel file and writing it to a new sheet.
But my problem is i want to change all the values of one column in to negative values.
Thanks in advance…

1 Like

Buddy
kindly follow the below steps to resolve your issue @monishankar

  1. use excel application scope to read the excel
  2. use read range activity and get the output as outdt
  3. use for each row loop and pass the above variable outdt to it
  4. inside the for each row use a assign activity like this
    row(“Columnname”) = “-”+row(“Columnname”).ToString
  5. This would all the row cell in that particular column a negative one
  6. then you can wirte to a new sheet as you do
    Cheers
    @monishankar
2 Likes

Did that work buddy @monishankar

1 Like

Yeah bro working fine…Not saying thanks to you,as I know i need your suggestion in near future as well.
Cheer to you too!!!

1 Like

sure buddy any time
Cheers @monishankar

1 Like

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