1
$\begingroup$

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?

thanks

$\endgroup$
  • $\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.