Group Abstract Group Abstract

Message Boards Message Boards

Creating table of 2 different variable and exporting them to single Excel

Posted 3 years ago
POSTED BY: Magdy Ismail
2 Replies
Posted 3 years ago

Hi Magdy,

X and Rn are pairs of numbers, the first one seems to be an index. To plot the values of X vs. Rn

XvsRn = Transpose[{Last /@ X, Last /@ Rn}]
ListLinePlot[Callout[#, Round[#, .01], Above, LeaderSize -> 18] & /@ XvsRn
 , Mesh -> All
 , MeshStyle -> Directive[PointSize[Medium], Red]
 , FrameLabel -> (Style[#, Black, 14] & /@ {"X", "Rn"})
 , ImageSize -> 600
 , PlotTheme -> "Detailed"]

enter image description here

To export

XvsRn // Prepend[{"X", "Rn"}] // Export["mfile.xlsx", #] &
POSTED BY: Rohit Namjoshi
Posted 3 years ago

Thank you so much; that was very helpful.

POSTED BY: Magdy Ismail
Reply to this discussion
Community posts can be styled and formatted using the Markdown syntax.
Reply Preview
Attachments
Remove
or Discard