MathGroup Archive 1998

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

Search the Archive

RE: Reading Native Excel files

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

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 agat.net
Conseil et Audit en Ingenierie de Calcul Strasbourg, France
http://www.agat.net
****************************************

-----Original Message-----
From: Barthelet, Luc [mailto:lucb at ea.com] To: mathgroup at smc.vnet.net
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.

thanks.

Luc Barthelet
GM the day, Mayor at night
http://www.simcity.com



  • 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