Mathematica 9 is now available
Services & Resources / Wolfram Forums / MathGroup Archive
-----

MathGroup Archive 2009

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

Search the Archive

How to modify an Excel file

  • To: mathgroup at smc.vnet.net
  • Subject: [mg95276] How to modify an Excel file
  • From: ADL <alberto.dilullo at tiscali.it>
  • Date: Wed, 14 Jan 2009 05:51:59 -0500 (EST)

Dear group, I am using Mathematica 6/7 export/import capabilities of
Excel files, and they work fine. The only problem is that, as far as I
understood, they cannot work with cell formats. This means that I
could not find a way to import an Excel file, modify a cell and then
export it in a new file with the same formatting as the original.

Is there, to your knowledge, a way to let Mathematica write a value in
a cell of an existing Excel file without using "Excel Link" and
without modifying the cell's format?

I have both Mathematica and Excel installed on my PC.

Hope some of you has a solution!

Thank you in advance


  • Prev by Date: Re: Is this so hard?
  • Next by Date: Re: printing symbols at as a table
  • Previous by thread: Re: NEWBIE QUESTION - How to create a barchart with two data sets.
  • Next by thread: Re: How to modify an Excel file