Its easy:
just look at the structure of your imported data.
Since you did not provide a file, we will use example data from Wolfram:
tab = Import["ExampleData/elements.xls"]
{{{"AtomicNumber", "Abbreviation", "Name", "AtomicWeight"}, {1., "H",
"Hydrogen", 1.00793}, {2., "He", "Helium", 4.00259}, {3., "Li",
"Lithium", 6.94141}, {4., "Be", "Beryllium", 9.01218}, {5., "B",
"Boron", 10.8086}, {6., "C", "Carbon", 12.0107}, {7., "N",
"Nitrogen", 14.0067}, {8., "O", "Oxygen", 15.9961}, {9., "F",
"Fluorine", 18.9984}}}'
Now you see, there is a first bracket spreading the tables of the spreadsheet. Here only one. Then rows and then columns. Hence, what you want is the first column of the first table in the spreadsheet:
tab[[1, All, 1]]
{"AtomicNumber", 1., 2., 3., 4., 5., 6., 7., 8., 9.}
to look at the example spreadsheet, you can save it by using:
Export["test.xls", Import["ExampleData/elements.xls"]]
Range[len],1
thus this will import first column with row from 1 to thelen
. Although the results is a row, quite strange. $\endgroup$Import["test.xls", {"Data", 1, ;; , 1}]
don't work??? $\endgroup$