3
$\begingroup$

I have sheets 100A-100G in Excel with data I want to plot in columns E and H of every sheet. Is there a way I can take the data from each sheet and plot into a separate graph in a simple way through Mathematica?

Thank you for the help!

$\endgroup$

1 Answer 1

6
$\begingroup$

Create an excel workbook with three sheets:

SeedRandom[1]
{data1, data2, data3} = RandomInteger[100, {3, 10, 20}];

Export["data123.xlsx", "Sheets" -> {"data 1" -> data1, "data 2" -> data2, 
   "data 3" -> data3}, "Rules"]

enter image description here

Import columns 5 and 8 from all sheets:

importedcolumns58 = Import["data123.xlsx",
   {"Data", All (* sheets *), All (* rows *), (* and columns *) {5, 8}}];

Plot the imported data:

ListLinePlot[SortBy[First] /@ importedcolumns58, 
 PlotLegends -> {"data1", "data2", "data3"}]

enter image description here

$\endgroup$

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.