Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.soft-sys.math.mathematica > #5076 > unrolled thread
| Started by | "Kuba" <drazen.kubatovic@zg.htnet.hr> |
|---|---|
| First post | 2011-09-19 11:09 +0000 |
| Last post | 2011-09-20 10:15 +0000 |
| Articles | 2 — 2 participants |
Back to article view | Back to comp.soft-sys.math.mathematica
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
| From | "Kuba" <drazen.kubatovic@zg.htnet.hr> |
|---|---|
| Date | 2011-09-19 11:09 +0000 |
| Subject | Changing 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]
| From | Chris Degnen <degnen@cwgsy.net> |
|---|---|
| Date | 2011-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