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

< Previous CommentHelp | Reply To Comment | Reply To Topic
Author Comment/Response
jf
10/02/12 11:42am

In Response To 'Re: Re: Importing .xlsx file'
---------
Sorry. Import for XLSX puts each sheet of the XLS file into a separate sublist of an outer list for the whole file.

First sheet, rows 1-80, column 1:

In[2]:= x[[1, 1 ;; 80, 1]]

Out[2]= {0.5421, 0.5359, 0.5173, 0.4896, 0.4571, 0.4248, 0.398, 0.381, 0.3772, \
0.3874, 0.4096, 0.4397, 0.4719, 0.5004, 0.5207, 0.53, 0.5272, 0.5132, 0.4907, \
0.4633, 0.4353, 0.4111, 0.3947, 0.3891, 0.3955, 0.4126, 0.4373, 0.4647, 0.49, \
0.5091, 0.5191, 0.519, 0.5089, 0.4909, 0.468, 0.4438, 0.4222, 0.4065, 0.3997, \
0.403, 0.4158, 0.4357, 0.4588, 0.481, 0.4988, 0.5093, 0.5112, 0.5045, 0.4906, \
0.4718, 0.4511, 0.4319, 0.4171, 0.4094, 0.41, 0.4189, 0.4344, 0.4535, 0.4729, \
0.4893, 0.5001, 0.5038, 0.5001, 0.4898, 0.4748, 0.4574, 0.4404, 0.4266, \
0.4182, 0.4166, 0.4222, 0.4339, 0.4494, 0.4661, 0.4809, 0.4917, 0.4967, \
0.4954, 0.4883, 0.4766}



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 CommentHelp | Reply To Comment | Reply To Topic