X

MySQL and MySQL Community information

  • January 31, 2014

MySQL for Excel 1.2.0 has been released

The MySQL
Windows Experience Team is proud to announce the release of MySQL for Excel
version 1.2.0
, the  latest addition to the MySQL Installer for
Windows.

MySQL for Excel is an application plug-in enabling data analysts to very easily access and manipulate MySQL data within Microsoft Excel. It enables you to directly work with a MySQL database from within Microsoft Excel so you can easily do tasks such as:

  • Importing MySQL Data into Excel
  • Exporting Excel data directly into MySQL to a new or existing table
  • Editing MySQL data directly within Excel

MySQL for Excel is installed using the MySQL Installer for Windows.

The MySQL installer comes in 2 versions

  • Full (150 MB) which includes a complete set of MySQL products with their binaries included in the download
  • Web (1.5 MB - a network install) which will just pull MySQL for Excel over the web and install it when run.

You can download MySQL Installer from our
official Downloads page at
http://dev.mysql.com/downloads/installer/.


MySQL for Excel 1.2.0 introduces the following features:

  • Edit Connections: MySQL connections can now be
    edited from within the MySQL for Excel plugin by right-clicking and choosing
    Edit Connection. Before, these connections could only be edited with MySQL
    Workbench.
  • Optimistic
    Updates: Previously, only "Pessimistic Updates" were used, which
    means that pressing Commit Changes would overwrite changes performed outside of
    MySQL for Excel for the edited cells. Both options remain available today, and
    optimistic updates are enabled by default. This update type can be set either
    as a preference, or toggled per session.
  • The
    Append Data dialog will now notify you of incompatible types (with visual
    warnings) when mapping source Excel columns to target MySQL columns. If a
    mismatch is discovered, then the column in the source grid that contains the
    mapped Excel data turns red, and selecting this column displays a warning with
    text explaining that the source data is not suitable for the mapped target
    column's data type.
  • New
    preview preferences allow you to enable one of the following three options:
    • Preview
      SQL statements before they are sent to the Server: View (and optionally) edit
      the MySQL UPDATE/INSERT statements before they are committed.
    • Show
      executed SQL statements along with the results: View the statements after they
      are committed, which is the current behavior.
    • Do
      not show the MySQL statements: Only show summary information, such as number of
      affected rows, and not MySQL statements. This is enabled by default.
  • Create
    Table: The Data Export feature now has the option to only create the table
    without inserting the data. To execute, toggle the Export Data button to Create
    Table, and then click.
  • The
    selected schema name is now displayed on top of the MySQL for Excel Database
    Object Selection panel.
  • The
    Advanced Options dialogs opened from the Import, Export and Append Data windows
    now immediately apply the option changes, when before the Advanced Options
    dialog had to be reopened before the changes could be previewed.
  • Edit
    Data sessions can now be saved: Using the new Edit Session preferences, these
    sessions were automatically closed after closing an Excel workbook. This data,
    such as the Workbench
    connection ID, MySQL schema, and MySQL table name, can now be preserved if the
    Excel workbook is saved to disk, and available when the Excel workbook is reopened.
  • Excel
    tables are created automatically for any data imported from MySQL to an Excel
    worksheet with a name like “<schema>.<db_object_name>” where a DB
    object can be a MySQL table, view or stored procedure. Options for the Excel
    tables creation can be found in the Advanced Options of the Import Data dialog.
    The created Excel tables can be referenced for data analysis in Pivot Tables or
    reports.

Also this
release contains the following bug fixes:

  • Fixed code that was not detecting an Excel row
    deletion but instead was detecting an Excel row change. Now after deleting an
    entire row in a worksheet, the row after it would change color to green.
    • Bug # 17852774 - EDIT DATA - DELETING A ROW TRIGGERS A DATA CHANGE IN
      THE FOLLOWING ROW

You can
access the MySQL for Excel documentation at
http://dev.mysql.com/doc/en/mysql-for-excel.html.

You can
find our team’s blog at http://blogs.oracle.com/MySQLOnWindows.

You can
also post questions on our MySQL for Excel forum found at http://forums.mysql.com/list.php?172.

Enjoy and thanks for the support!

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.Captcha
Oracle

Integrated Cloud Applications & Platform Services