Dear MySQL users,
The MySQL Windows Experience Team is proud to announce the
release of MySQL for Excel version 1.3.7. This is a maintenance
release for 1.3.x. It can be used for production environments.
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 which includes a complete set of MySQL products with
their binaries included in the download.
- Web (network install) which will just pull the 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/
The MySQL for Excel product 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.7 (2017-05-24)
Functionality Added or Changed
* The way MySQL for Excel shares data-editing sessions
among users and between computers was improved. (Bug
#25509085, Bug #73314)
* The Append Excel Data to Table operation was updated with
new advanced options to manage the behavior of rows
containing unique key values that are duplicates of those
in the database. (Bug #25479653, Bug #83801)
* Added a new global option that specifies how to format
spatial data as text: Well-Known Text, Keyhole Markup
Language, Geography Markup Language, or GeoJSON. (Bug
#22081263)
* Enhanced the logic that migrates stored MySQL connections
to the MySQL Workbench connections.xml file. In previous
versions, the migration was offered and if not done at
that moment, the dialog to migrate was shown every time
MySQL for Excel was launched. There was no way to choose
to continue storing MySQL connections in the MySQL for
Excel configuration folder, instead of merging them with
MySQL Workbench.
Now, the Connections Migration dialog offers a way to
postpone the migration by one hour, one day, one week,
one month, or indefinitely. If the migration is
postponed, the dialog is shown again after that time
elapses. If the migration is postponed indefinitely, then
an option is added to the Options dialog that permits the
migration of connections to be done manually, as long as
MySQL Workbench is installed.
* Support for MySQL Fabric was removed.
Bugs Fixed
* SSL connections when created with MySQL Workbench should
be inactive within MySQL for Excel, which does not
support SSL connections. (Bug #25962564)
* Selecting a schema containing at least one stored
procedure for a MySQL 8.0 or 8.1 connection emitted an
error. (Bug #25962347)
* Empty string values within Excel column data that were
used in an export or append-data operation caused the
generated SQL queries to have no value, instead of an
empty value corresponding to the data type of the target
column (for example: 0 for Integer; false for Bool if the
column does not allow NULL values, or NULL otherwise).
(Bug #25509312, Bug #84851)
* MySQL data could not be refreshed or edited directly in
an Excel worksheet by different users or from different
computers, which reduced the ability to share
data-editing sessions among users or between computers.
This fix alters the way connection information is stored
by migrating the connection details for related import
and edit-data operations from the user settings file to
the XML parts of a workbook when the workbook is opened,
and if the workbook supports XML parts and the connection
information related to that workbook is found in the user
settings file. (Bug #25509085, Bug #73314)
* User-selected data types that replaced the detected
values of a column were lost when the First Row Contains
Column Names check box was selected or deselected in
preparation for an export-data operation. This fix
retains the selected value when the data type is set
manually to override the automatically detected type and
the check box is selected or deselected. It further adds
a new action to reset the column back to automatic
detection. (Bug #25492772, Bug #84802)
* A portion of the preview area that should be displayed
during import, export, and append data operations was
concealed by other fields. (Bug #25325
