i want to import two coloumns from excel what basically works:

data = Import["/Users/name/file.xlsx", {"Data", 1, All, {1, 2}}]

The main "problem" i got is the data are sorted by a pair like

{{0.579989, 0.192381}, {0.991856, 0.177432}, ....

but i want to have it in one line like

{0.579989, 0.192381 , 0.991856, 0.177432, ...

how do i have to change my command?



closed as off-topic by BlacKow, Young, Jason B., Mr.Wizard Aug 16 '16 at 19:03

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "This question arises due to a simple mistake such as a trivial syntax error, incorrect capitalization, spelling mistake, or other typographical error and is unlikely to help any future visitors, or else it is easily found in the documentation." – BlacKow, Young, Jason B., Mr.Wizard
If this question can be reworded to fit the rules in the help center, please edit the question.

  • $\begingroup$ So you need just one column? Looks like you want to take only first number form each pair... $\endgroup$ – BlacKow Aug 16 '16 at 16:02
  • $\begingroup$ i want to import both excel coloumns but the data should be single and not as a pair of data like above {0.579989, 0.192381 , 0.991856, 0.177432,.... $\endgroup$ – Niklas Hachenburg Aug 16 '16 at 16:05
  • 1
    $\begingroup$ use Flatten... $\endgroup$ – BlacKow Aug 16 '16 at 16:07
  • $\begingroup$ sorry..what is flatten? $\endgroup$ – Niklas Hachenburg Aug 16 '16 at 16:08
  • $\begingroup$ Flatten is a built in function that ... err.. flattens your list:) docs $\endgroup$ – BlacKow Aug 16 '16 at 16:10

Browse other questions tagged or ask your own question.