Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Excel Headers -> Mathematica

  1. Jul 24, 2012 #1
    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?


    Nicholas Kormanik
  2. jcsd
Share this great discussion with others via Reddit, Google+, Twitter, or Facebook

Can you offer guidance or do you also need help?
Draft saved Draft deleted

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