Services & Resources / Wolfram Forums / MathGroup Archive
-----

MathGroup Archive 2011

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

Search the Archive

Re: Changing excel table with Wolfram Mathematica

  • To: mathgroup at smc.vnet.net
  • Subject: [mg121574] Re: Changing excel table with Wolfram Mathematica
  • From: Chris Degnen <degnen at cwgsy.net>
  • Date: Tue, 20 Sep 2011 06:10:13 -0400 (EDT)
  • Delivered-to: l-mathgroup@mail-archive0.wolfram.com
  • References: <j577tn$j8q$1@smc.vnet.net>

It may be simplest to import the Excel file into Mathematica, edit the
table in Mathematica, and then export as an Excel file.

A more difficult alternative is to use .Net/Link, as documented here:

http://reference.wolfram.com/mathematica/NETLink/tutorial/CallingNETFromMathematica.html

specifically in the introduction: Calling COM Objects -
ExcelPieChart.nb



On Sep 19, 12:09 pm, "Kuba" <drazen.kubato... at zg.htnet.hr> wrote:
>     I would like to change some cells in Excel table with Mathematica. I
> know that can be done with "Mathematica link for Excel", but is any way how
> can I change this with Mathematica built-in functions? For example:
>
>     Table from A1 to D4
>
> 1 1 1 1
> 1 1 1 1
> 1 1 2 2
> 1 1 2 2
>
> I wont change cells from C3 to D4, to set new value. For example 2 becomes
> 3.
> It is important that all other cells stay untouched.
> Thank you very much.





  • Prev by Date: Re: Compilation: Avoiding inlining
  • Next by Date: Re: boundary conditions
  • Previous by thread: Re: Changing excel table with Wolfram Mathematica
  • Next by thread: Plot axis length and size ratio (TwoPlot revive)