Mathematica 9 is now available
Student Support Forum
-----
Student Support Forum: 'Importing .xlsx file' topicStudent Support Forum > General > "Importing .xlsx file"

< Previous Comment | Next Comment >Help | Reply To Comment | Reply To Topic
Author Comment/Response
jf
10/01/12 12:55pm

According to http://reference.wolfram.com/mathematica/ref/format/XLSX.html,
you can specify rows to Import, but not columns.

The quick way is probably to import the whole sheet and use Part to pull off the first column.

m[[1;;80,1]]

(translation: matrix m, rows 1 through 80, first column)



URL: ,

Subject (listing for 'Importing .xlsx file')
Author Date Posted
Importing .xlsx file Sanjoy Das 09/29/12 9:13pm
Re: Importing .xlsx file jf 10/01/12 12:55pm
Re: Re: Importing .xlsx file Sanjoy Das 10/02/12 07:47am
Re: Re: Re: Importing .xlsx file jf 10/02/12 11:42am
< Previous Comment | Next Comment >Help | Reply To Comment | Reply To Topic