Re: How Import data from Excel and make a list of numbers

*To*: mathgroup at smc.vnet.net*Subject*: [mg82163] Re: How Import data from Excel and make a list of numbers*From*: Bill Rowe <readnewsciv at sbcglobal.net>*Date*: Sat, 13 Oct 2007 04:01:11 -0400 (EDT)

On 10/12/07 at 2:57 AM, dinodeblasio at gmail.com wrote: >How I can import in Mathematica 6 data from Excel? More in details, >how i can trasform a list of numbers present in one excel columns-> >to one list of numbers in Mathematica 6 in the form: >{1,2,3,4,5,........} You import Excel files with data = Import[filename, "XLS"]; Assuming there is one Excel worksheet, you can get a specific column by doing col = data[[All,n]] where n is the column number. Or you could combine these into one line by doing col = Import[[filename][[All,n]]; Note, this assumes all rows in that worksheet have at least n columns. That is if the worksheet has the form comment blank row blank row a1 a2 a3 ... b1 b2 b3 ... ... you will get an error doing Import[filename,"XLS"][[All,3]] since the first few rows have fewer than three columns. In this case, getting the third column of the data array could be done using col = Cases[Import[filename,"XLS"],_?(Length>3#)][[All,3]] Of course, if you didn't create the Excel file and don't have something that will display the structure of the file, you have no way to know what that structure will be. What I do in those cases is simply data = Import[filename, "XLS"]; then use commands like Dimension, Depth, Length etc to determine the structure. Once that is know, it is a simple matter to extract a particular column using Part, Span etc. -- To reply via email subtract one hundred and four