Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.soft-sys.math.mathematica > #11059

Excel Headers --> Mathematica

From Nicholas Kormanik <nkormanik@gmail.com>
Newsgroups comp.soft-sys.math.mathematica
Subject Excel Headers --> Mathematica
Date 2012-07-25 06:33 +0000
Message-ID <juo403$173$1@smc.vnet.net> (permalink)
Organization Time-Warner Telecom

Show all headers | View raw


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
nkormanik@gmail.com

Back to comp.soft-sys.math.mathematica | Previous | Next | Find similar | Unroll thread


Thread

Excel Headers --> Mathematica Nicholas Kormanik <nkormanik@gmail.com> - 2012-07-25 06:33 +0000

csiph-web