Hi Dima,
Simple answers:
You can NOT change the direction of edge after importing it.
You CAN change the display of a directed edge, however, by changing the Style of Source Arrow Shape and Target Arrow Shape. See Ruth’s previous responses. This is kind of a hack, since the model of the directed edge is not actually changing.
You CAN import a new network with different edges. See previous responses and attached cys file.
You CAN delete an edge and then add a new edge to replace it. This is advanced and requires familiarity with CyREST, RCy3 or py2cytoscape.
With the xls files you provided the only option is to import each xls as a separate network. You will then have two networks, each with accurate edge directions (see attached cys). We have provided UI and scripting examples already for how to do this.
If you try to load a new xls as edge table data it won’t work. The directionality is permenantly fixed by the name of the edge, for example, "AUD (interacts with) EUR”. You can’t change that for a given edge. If you want the opposite direction IN THE SAME NETWORK, then you have to first delete that edge and then add a new edge. You can not do this by network or table import functions. Alternatively, you can to change the Style of the display of an edge with the hack described above.
Asking the same question again is not going to give you a different answer...