Mathematica 9 is now available
Student Support Forum
-----
Student Support Forum: 'mathematica excel import' topicStudent Support Forum > General > "mathematica excel import"

Next Comment >Help | Reply To Topic
Author Comment/Response
andrew
08/27/12 05:45am

Hi

I am importing a spreadsheet to a symbol and then i would like to plot a graph of two columns within the imported data.

so i can access a specifc row and column like:

myData = Import["myfile.xls", {"Sheets", 1}]
myData[[1,2]]

and that outputs row 1 column 2 and i can output 2 rows like:

myData[{1,2}]

But i can not work out how to output column 2 for multiple rows or a range of rows?

As then i want to output columns 1 and 2 for example and plot a graph.

URL: ,

Subject (listing for 'mathematica excel import')
Author Date Posted
mathematica excel import andrew 08/27/12 05:45am
Re: mathematica excel import Bill Simpson 08/27/12 1:21pm
Next Comment >Help | Reply To Topic