To copy the contents of an Excel range to a Mathematica notebook: Notes • If the contents of the range were not converted into a Mathematica list, verify Mathematica keyboard shortcuts are enabled in Excel. You can do this under Mathematica Options  Interface. • By default, text cells are copied as Mathematica strings. Only cells formatted as Text are considered to contain Mathematica expressions. See Strings. If needed, you can convert strings to expressions using ToExpression[data]. • Empty cells are copied as the symbol Empty. If needed, you can convert these to a desired default value, such as 0 or "", using ReplaceAll[data,Empty -> val]. |
