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

Post Reply:
Name:
Email Address:

Please send email when my message is replied to.

Url (optional):
Subject:
Message: view original message?
Attachment (optional):
Please answer this:1+3 =



Original Message (ID '43244') By jf:
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}