Forum Discussion

nimishbhuta's avatar
nimishbhuta
Frequent Contributor
8 years ago

DataSink Issue with writing 2 values in excel

Hello All, 

 

I am facing an issue with DataSink in Ready API. The issue is with respecting to writing values in DataSink - Excel. 

 

 

For example,

 

I have created OrderNo and CustomerPO property in DataSink with the same input and output file. The thing is if I want to put the cell as A1 for CustomerPO  and for OrderNo as B1 then what it does is that it changes the CustomerPO cell to B1. If I change the cell of CustomerPO to A1 then it changes the OrderNo to A1. In short, the last cell which I change is reflected to all the properties. 

 

Currently, I am creating 2 Datasink steps and writing this properties but ideally it should have  only 1 DataSink with these two properties writing in 2 different cell. 

 

Regards,

 

Nimish

 

 

 

  • nimishbhuta's avatar
    nimishbhuta
    Frequent Contributor
    8 years ago

    Additionally, I noticed that if we have 2 different Data Sink to update the same excel file,same sheet and different cell. But it will only the 1st one which is there in the data sink and does not update value from the other data sink. But if we try with 2 different excel then it work fine. 

     

    Not sure, why can't 2 values cane be updated in same excel file. 

     

     

    Regards,

     

    Nimish