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