Tag Info

New answers tagged


If you data is labelled "blah.xls" then your input should be Import["blah.xls"] Just make sure the data file is in the correct directory.


data You need to remove the braces around the individual data elements to obtain a rectangular table. You can do this in a number of ways: dt1 = Join @@@ data; dt2 = Map[Flatten, data, -2]; dt3 = Flatten[data, {3, 1}]; dt4 = data /. {x_?NumericQ} :> x; dt1 == dt2 == dt3 == dt4 (* True *) dt1 Export["test.xls", dt1]

Top 50 recent answers are included