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

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