Helo,
How can I get result stress and displacement data for all the nodes as test form or in exel file form.
Thanks in advance
For any type of result, you can select the nodes, right-click, and choose "Inquire Results". On the dialog that appears to show the results, click the "Save Results" button (or whatever the terminology is) and save the results to a text file (.CSV).
For displacement results, you can also use the command "Results Options > Other > Tools > Nodal Results Translator". This standalone program has the flexibility to write out multiple load cases, specific nodes, multiple results at once (X, Y, Z translation), etc. I've heard that it is a nice program.