Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.soft-sys.math.mathematica > #5076 > unrolled thread

Changing excel table with Wolfram Mathematica

Started by"Kuba" <drazen.kubatovic@zg.htnet.hr>
First post2011-09-19 11:09 +0000
Last post2011-09-20 10:15 +0000
Articles 2 — 2 participants

Back to article view | Back to comp.soft-sys.math.mathematica


Contents

  Changing excel table with Wolfram Mathematica "Kuba" <drazen.kubatovic@zg.htnet.hr> - 2011-09-19 11:09 +0000
    Re: Changing excel table with Wolfram Mathematica Chris Degnen <degnen@cwgsy.net> - 2011-09-20 10:15 +0000

#5076 — Changing excel table with Wolfram Mathematica

From"Kuba" <drazen.kubatovic@zg.htnet.hr>
Date2011-09-19 11:09 +0000
SubjectChanging excel table with Wolfram Mathematica
Message-ID<j577tn$j8q$1@smc.vnet.net>
    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. 


[toc] | [next] | [standalone]


#5094

FromChris Degnen <degnen@cwgsy.net>
Date2011-09-20 10:15 +0000
Message-ID<j59p3u$rg$1@smc.vnet.net>
In reply to#5076
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...@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.

[toc] | [prev] | [standalone]


Back to top | Article view | comp.soft-sys.math.mathematica


csiph-web