2
$\begingroup$

I'm trying to import a part of an excel, the column 20 and the row between 6-59 in this column. I tried :

tab = Import[
   "file.xlsx"];
time = tab[[20, 6 ;; 59]]

and 

time = Import[
  "D:\Users\martine\Desktop\data\KP\Results largest GFP area \
mean.xlsx", {"Data", 1, {6;; 59}, {20}}]
time = Import[
  "D:\Users\martine\Desktop\data\KP\Results largest GFP area \
mean.xlsx", {"Data", 1, {6:59}, {20}}]

But it doesn't work so apparently I didn't write it the right way.

Thank you in advance

Improve this question
$\endgroup$
2
  • $\begingroup$ try {"Data", 1, 6;; 59, {20}}? $\endgroup$ – kglr Jun 14 '19 at 8:40
  • $\begingroup$ it works ! that was the only one I had not tried ! $\endgroup$ – J.A Jun 14 '19 at 8:49
3
$\begingroup$

You should remove the braces around Span in the second argument of Import, that is, use

{"Data", 1, 6;;59, {20}}
Improve this answer
$\endgroup$

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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