MySQL Forums
Forum List  »  Announcements

MySQL for Excel 1.3.0 Beta has been released
Posted by: Karen Langford
Date: June 06, 2014 11:57AM

Dear MySQL users,

The MySQL Windows Experience Team is proud to announce the release of
MySQL for Excel version 1.3.0.  This is a beta release for 1.3.x.

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

As this is a beta version the MySQL for Excel product can be
downloaded only by using the product standalone installer at this link
http://dev.mysql.com/downloads/windows/excel/


Changes in MySQL for Excel 1.3.0 (2014-06-06, Beta)

   This section documents all changes and bug fixes applied to MySQL
   for Excel since the release of 1.2.1. Several new features were
   added, for more information see What Is New In MySQL for Excel
(http://dev.mysql.com/doc/refman/5.6/en/mysql-for-excel-what-is-new.html).

   Known limitations:

   Upgrading from versions MySQL for Excel 1.2.0 and lower is not
   possible due to a bug fixed in MySQL for Excel 1.2.1. In that
   scenario, the old version (MySQL for Excel 1.2.0 or lower) must be
   uninstalled first. Upgrading from version 1.2.1 works correctly.

   Control + A cannot be used to select all database objects. Either
   shift + Arrow or Control + click must be used instead.

   Excel tables created from external data sources may not refresh if
   the MySQL for Excel add-in is loaded.

   PivotTables are normally placed to the right (skipping one column)
   of the imported data, they will not be created if there is another
   existing Excel object at that position.

   Functionality Added or Changed

     * Imported data can now be refreshed by using the native Refresh
       feature. Fields in the imported data sheet are then updated
       against the live MySQL database using the saved connection ID.

     * Functionality was added to import data directly into
       PivotTables, which can be created from any Import operation.

     * Multiple objects (tables and views) can now be imported into
       Excel, when before only one object could be selected.
       Relational information is also utilized when importing
       multiple objects.

     * All options now have descriptive tooltips. Hovering over an
       option/preference displays helpful information about its use.

     * A new Export Data, Advanced Options option was added that
       shows all available data types in the Data Type combo box,
       instead of only showing a subset of the most popular data
       types.

     * The option dialogs now include a Refresh To Defaults button
       that resets the dialog's options to their defaults values.
       Each option dialog is set individually.

     * A new Add Summary Fields for Numeric Columns option was added
       to the Import Data dialog that automatically adds summary
       fields for numeric data after the last row of the imported
       data. The specific summary function is selectable from many
       options, such as "Total" and "Average."

     * A new collation option was added for the schema and table
       creation wizards. The default schema collation is "Server
       Default", and the default table collation is "Schema Default."
       Collation options may be selected from a drop-down list of all
       available collations.

Quick links:
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.
You can follow our videos on our YouTube channel found at http://www.youtube.com/user/MySQLChannel.


Enjoy and thanks for the support!

The MySQL on Windows team at Oracle. 

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL for Excel 1.3.0 Beta has been released
2091
June 06, 2014 11:57AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.