MySQL for Excel 1.3.6 has been released

The MySQL Windows Experience Team is proud to announce the release of MySQL for Excel version 1.3.6. This is a maintenance release for 1.3.x. It can be used for production environments.

MySQL for Excel is an application add-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 which 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 can also be downloaded by using the product standalone installer found at this link http://dev.mysql.com/downloads/windows/excel/

Changes in MySQL for Excel 1.3.6 (2016-01-07)

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

Functionality Added or Changed

  • A new Generate an INSERT statement for each data row option was added to the Advanced Options dialog for Append and Export Data operations. This is disabled by default. A single INSERT statement is generated that inserts all affected rows, unless this option is enabled. When checked, an INSERT statement for each data row being appended or exported is generated in the resulting SQL query sent to the MySQL server. When unchecked, a single INSERT statement is generated as a bulk data operation, which performs better than multiple INSERT statements. While row-by-row inserts are slower, for debugging errors it could help determine which row causes an error, since the MySQL Server will process them row by row.
  • Added column properties to the Export Data dialog to support the definition of Auto Increment and Default Value for new MySQL tables where the data will be exported. Added a context menu to declare a numeric field to be Unsigned or to have Zero-Fill, accessible by right-clicking the Data Type combo box. Added the TIMESTAMP data type to the full list of valid data types, as it was not being shown before. Added help tool tips to fields in the Export Data dialog that explain in detail how the column properties work in a MySQL database.

Bugs Fixed

  • The Pivot Table feature was updated to work with Excel 2016.
  • Closing the plugin via the Close button in the panel would not toggle the MySQL for Excel checkbox in the Data ribbon.
  • Fixed the content detector for the active Excel cell after importing data and after loading database objects when a database is opened. Now, the data options are not enabled until a table is selected.
  • Append and Export operations would not append/export boolean data.
  • The MySQL for Excel Refresh All function would throw an unhandled exception.
  • With Office 2007, data would not auto-save after closing Excel.
  • Numeric data stored in text columns is now correctly formatted by Excel as text, and not as the “General” format that automatically formats cells as numbers when the data is stored in a text object. This fixes the issue where text columns were formatted as numbers, which stripped leading zeros.
  • Changed settings for containers and forms to let all UI components automatically scale on different DPI settings. Also removed the restriction to resize the MySQL for Excel‘s pane, so in case a different DPI setting is used and the fonts look too big, the pane can be resized to see contents as best as possible.

Quick links:

Enjoy and thanks for the support!