MySQL for Excel 1.2.0 has been released
By Javier Treviño on Jan 31, 2014
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.
also post questions on our MySQL for Excel forum found at http://forums.mysql.com/list.php?172.
Enjoy and thanks for the support!