Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.soft-sys.math.mathematica > #5094
| From | Chris Degnen <degnen@cwgsy.net> |
|---|---|
| Newsgroups | comp.soft-sys.math.mathematica |
| Subject | Re: Changing excel table with Wolfram Mathematica |
| Date | 2011-09-20 10:15 +0000 |
| Organization | Steven M. Christensen and Associates, Inc and MathTensor, Inc. |
| Message-ID | <j59p3u$rg$1@smc.vnet.net> (permalink) |
| 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...@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.
Back to comp.soft-sys.math.mathematica | Previous | Next — Previous in thread | Find similar | Unroll thread
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
csiph-web