MathGroup Archive 2011

[Date Index] [Thread Index] [Author Index]

Search the Archive

Re: Changing excel table with Wolfram Mathematica

  • To: mathgroup at
  • Subject: [mg121593] Re: Changing excel table with Wolfram Mathematica
  • From: Alexey Popkov <lehin.p at>
  • Date: Wed, 21 Sep 2011 05:34:35 -0400 (EDT)
  • Delivered-to:
  • References: <> <j59p4t$rn$>


Very interesting, thank you for pointing this out! But what is about
performance? Is working with Excel file is approximately as fast and
memory efficient as working with Mathematica's built-in SQL database?


P.S. It is quite simple to work with Mathematica's built-in SQL
database by using a set of simple supporting functions presented here
("SQL Approach" section):

On 20 Sep, 14:15, "Hans Michel" <hmic... at> wrote:
> 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:
> 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.kubato... at]
> 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.

  • Prev by Date: Re: Compilation: Avoiding inlining
  • Next by Date: Re: Parallel remote kernel: MathLink connection not active
  • Previous by thread: Re: Changing excel table with Wolfram Mathematica
  • Next by thread: Re: Changing excel table with Wolfram Mathematica