(adsbygoogle = window.adsbygoogle || []).push({}); Excel Headers --> Mathematica

I have a large Excel .xls file. Miniature version shown below:

Test1 Test2

75 64

58 85

81 55

64 63

70 94

88 90

78 96

96 98

54 97

75 61

I would like to do some statistical analysis on the file in Mathematica 8.0.4.

Additionally I am using Mathematica Link for Excel 3.5.

The issue I'm now attempting to address concerns the "headers," or "column labels."

I need to tell Mathematica to disregard the headers. I want to use each respective header, however, as the name for the "variable stream" (Mathematica-speak for each column of data.)

What might be the best ways of dealing with such headers?

Thanks.

Nicholas Kormanik

**Physics Forums | Science Articles, Homework Help, Discussion**

Join Physics Forums Today!

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

# Excel Headers -> Mathematica

Can you offer guidance or do you also need help?

Draft saved
Draft deleted

Loading...

Similar Threads for Excel Headers Mathematica |
---|

Help with Excel graph please |

Mathematica Storing Mathematica output |

Mathematica Mathematica to MATLAB |

LaTeX Putting Excel graph into LaTeX |

Excel Error Bars |

**Physics Forums | Science Articles, Homework Help, Discussion**