MathGroup Archive 1998

[Date Index] [Thread Index] [Author Index]

Search the Archive

RE: Reading Native Excel files

  • To: mathgroup at
  • Subject: [mg15021] RE: [mg14976] Reading Native Excel files
  • From: "Jean-Marie THOMAS" <jmthomas at>
  • Date: Sat, 5 Dec 1998 01:30:23 -0500
  • Sender: owner-wri-mathgroup at

Native Excel files are OS dependant, so they should be as many notebooks
as different OS.
Another problem is Excel version (version 4, version 5, Office95,
Office97, meaning a new version should be expected soon...). The
solution is more in writing a kind of macro in Excel to save files in
.txt or .csv formats, but these formats cannot handle different sheets.
Another trouble comes from the decimal point: "." or "," depending on
the localized OS you use.

Jean-Marie THOMAS
mailto:jmthomas at
Conseil et Audit en Ingenierie de Calcul Strasbourg, France

-----Original Message-----
From: Barthelet, Luc [mailto:lucb at] To: mathgroup at
Subject: [mg15021] [mg14976] Reading Native Excel files

Did anyone write a notebook to read native Excel files in Mathematica?
(*.xls under Windows)

So far I have always forced the users to save the excel files as text
files. It works fine, except it requires an extra step and therefore an
extra opportunity for a human error.

I have used Mathlink for Excel in the past and I do not want to use it
for solving this since the whole point of it is to not require
mathematica on those user machines.


Luc Barthelet
GM the day, Mayor at night

  • Prev by Date: RE: Can Factorial[] be compiled?
  • Next by Date: RE: Reading Native Excel files->Solution
  • Previous by thread: Reading Native Excel files
  • Next by thread: Re: Reading Native Excel files