Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.soft-sys.math.mathematica > #5095
| From | "Hans Michel" <hmichel@cox.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 | <j59p4t$rn$1@smc.vnet.net> (permalink) |
| References | <201109191106.HAA19601@smc.vnet.net> |
Every once in a while someone asked this question.
No is the answer to your constrained question: using Mathematica Built-In
functions to update just a few Excel worksheet cells in an Excel workbook
without overwriting the file on using Export.
Without your constraints you can Import the entire worksheet, make changes
to the values you need, Export the entire worksheet out. OR
You can use DatabaseLink. Treat Excel file as a database. You would use a
JDBC (ODBC) connection to the Excel worksheet. Then using Excel's SQL-like
language you can Update the required cells.
It is very hard to provide details of using DatabaseLink in this way,
because depending on platform and user's skill set and level of experience
using ODBC it is a painful process to explain and work through.
But this is where I would point you towards to start:
http://reference.wolfram.com/mathematica/DatabaseLink/tutorial/DatabaseConne
ctions.html#27756
In "Setting Up the Connection" section the image of the ODBC Datasource
Administrator (depending on your system)
"Excel Files" is a choice. So one can connect to an Excel file.
If the poster pursues the DatabaseLink route, I would advise the poster to
first make a successful ODBC connection to an Excel file and do an update of
a cell and close the connection. Do this if time permits using external
tools Java program. When you get familiar with the concept and its use I
would say then you are ready to use DatabaseLink. Otherwise there will be a
barrage of questions stemming from rookie mistakes such as ("Now I can't
open my Excel file?" Did you close the connection.)
("It is not working?" Do you have the correct ODBC-JDBC Driver for the
application your are connecting.)
If you understand what I am pointing towards then go ahead and jump right
into DatabaseLink.
Hans
-----Original Message-----
From: Kuba [mailto:drazen.kubatovic@zg.htnet.hr]
Sent: Monday, September 19, 2011 6:06 AM
Subject: 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.
Back to comp.soft-sys.math.mathematica | Previous | Next — Next in thread | Find similar | Unroll thread
Re: Changing excel table with Wolfram Mathematica "Hans Michel" <hmichel@cox.net> - 2011-09-20 10:15 +0000 Re: Changing excel table with Wolfram Mathematica Alexey Popkov <lehin.p@gmail.com> - 2011-09-21 09:40 +0000 Re: Changing excel table with Wolfram Mathematica "Hans Michel" <hmichel@cox.net> - 2011-09-22 11:35 +0000
csiph-web