Changing Excel file column value

Help
1

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
2

Hi
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
3

Did that work @monishankar

1 Like
4

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
5

sure any time
Cheers @monishankar

1 Like
6

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