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: [mg121576] Re: Changing excel table with Wolfram Mathematica
  • From: "Hans Michel" <hmichel at cox.net>
  • Date: Tue, 20 Sep 2011 06:10:34 -0400 (EDT)
  • Delivered-to: l-mathgroup@mail-archive0.wolfram.com
  • References: <201109191106.HAA19601@smc.vnet.net>

Appending previous post.

You can also use .NETLink and then use Office SDK object to manipulate an
Excel worksheet.

Hans

-----Original Message-----
From: Kuba [mailto:drazen.kubatovic at zg.htnet.hr] 
Sent: Monday, September 19, 2011 6:06 AM
To: mathgroup at smc.vnet.net
Subject: [mg121576] Changing excel table with Wolfram Mathematica

    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: Styling initialization cells
  • Previous by thread: Changing excel table with Wolfram Mathematica
  • Next by thread: Re: Changing excel table with Wolfram Mathematica