.(adsbygoogle = window.adsbygoogle || []).push({});

I have a large Excel worksheet (200 columns, 4,000 rows). Every column has a unique and carefully chosen title/label.

I'm attempting to use it within Mathematica to create a large number of contour plots (1,000) -- using three columns at a time, for x, y, z.

The import, I suppose, occurs. At least it appears to have.

Here's the question:

-- Is Mathematica using my column titles, so that I can refer to them in commands subsequent to import?

-- If not, is there any format I can put my data into to begin with so that Mathematica will readily recognize my named columns?

I certainly wanted to be getting on with the contour plots (SmoothDensityHistogram), but am having trouble getting my data into the required form.

Any help appreciated.

Nicholas Kormanik

nkormanik@gmail.com

.

**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!

# Data format AFTER import into Mathematica from Excel.xls worksheet

Loading...

Similar Threads for Data format import |
---|

Bi-exponential function fitting in Origin Lab SW |

MATLAB Matlab data into bins |

Mathematica Formating fractions |

Mathematica Chisquare fit to multiple data sets |

MATLAB Weighting data points with fitted curve in Matlab |

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