What's New in Mathematica Link for Excel 3
New in Version 3.7.3
- Compatibility with Mathematica 12.3, 64-bit installers
New in Version 3.7.2
- Compatibility with Mathematica 12.1
New in Version 3.7.1
- Compatablility with Mathematica 12
New in Version 3.7
- Compatibility with Excel 2016 (including Excel 2010 64-bit version)
Improved in Version 3.7
- Updated Excel UI to support Office Fluent UI
- Improved contextual menu support in Excel 2007 and newer to include a submenu for MathematicaLink in Excel (substituting Shift + right-click to display the Mathematica Context menu in Excel 2007 or newer)
- Other minor improvements and fixes
New in Version 3.6.1
- Compatibility with Mathematica 11
New in Version 3.6
- Compatibility with Mathematica 9 and 10
New in Version 3.5
- Compatibility with Mathematica 8.0
- Compatibility with Excel 2010 (including Excel 2010 64-bit version)
- ExcelShare function allows sharing a kernel between Excel and Mathematica
- VBA support routines: MathematicaSet, MathematicaRun and MathematicaGet
- Support for reading and writing Excel comments (including writing to a range using CellLabel["my comment"])
- Shift-click the Mathematica "Evaluate" button to close link and bring up the Mathematica connection window
- Shift + right-click a range to quickly display the Mathematica Context menu without turning on Mathematica Contexts
Improved in Version 3.5
- Updated toolbar and menu icons
- Improved Mathematica connection management (self-healing link and new connection options window)
- Improved handling of Mathematica connection exceptions and evaluation interrupts
- Improved Mathematica messaging (messages now returned in real time)
- Improved "Display Message Box" option now only applies to Print[] output
- Improved workbook initialization code evaluation and management
- Improved common multi-workbook initialization now supported using an init.m file in same directory
- Improved support for long-running Mathematica macros
- Improved automatic workbook relinking and add-in startup logic
- Other minor improvements and fixes
New in Version 3.2
- Compatibility with Mathematica 7, including Mathematica 7-based icons
- ExcelOpen, ExcelSave and ExcelDialog support for Excel 2007 .xlxs, .xlsm and .xlsb files
- ExcelWrite support for writing
Grid[{{1,2,3},{4,5},{6}}, opts] f.ex.
ANOVATable output
- ExcelFormat ["A:C", "AutoFit"] to automatically adjust column
width
- Support for 64-bit Windows and 64-bit Mathematica connecting
to 32-bit Excel
Improved in Version 3.2
- Improved message print format in Mathematica 6 and 7
- Fixed bug where some workbooks with macro buttons do not relink correctly
- Improved ExcelInstall[Visible -> True] method for launching visible instance of Excel
- Improved Mathematica Macros inserting of code boxes and buttons
- No "kernel connection closed" dialog if initialization code ends with Quit[]
- Other minor improvements and fixes
New in Version 3.1
- Compatibility with Mathematica 6
- Compatibility with Excel 2007
- Compatibility with Windows Vista
- Keyboard shortcuts for Excel toolbar commands
- Additional Excel message-related options
- Restored backward compatibility with Excel 2000
Improved in Version 3.1
- Improved editing of existing functions using the Mathematica function
wizard
- Improved compatibility with workbooks originally built with Version 2.x of
Mathematica Link for Excel
- Improved printable PDF documentation
New in Version 3
- Display of typesetting and formatted output in Excel
- Ability to create Mathematica-based macros
- Suite of Mathematica functions to interact with and
automate Excel
Improved in Version 3
- Improved set of worksheet functions allowing you to build and
evaluate Mathematica expressions in Excel even more easily.
- Increased worksheet function speed. Worksheet functions now
calculate up to eight times faster.
- Increased worksheet function reliability. Worksheet functions are
now robust enough for the most demanding spreadsheet applications.
Automated tests have performed billions of continuous evaluations
without errors.
- Improved worksheet function error handling. Dependent evaluations
are now suppressed through the use of native Excel error codes.
- Improved Mathematica message handling. Messages are now
displayed and stored in a non-modal window. You can leave this window
open, scroll through multiple messages, find the source of a message
and even save messages to a log file.
- Easier linking. If a Mathematica kernel is available on
your machine it is automatically located. The Start/End Link button is
now a more powerful Evaluate button that can be used to reevaluate a
workbook, interrupt current evaluations or, by holding Shift, end a
link without displaying a confirmation dialog.
- Enhanced Mathematica function wizard allows you to browse
for functions by category, explore options and edit existing formulas.
- Standard packages are now automatically declared, by default, and
can be browsed directly within the function wizard. This functionality
replaces the Libraries dialog.
- Improved copying and pasting is faster and more robust. View and
modify your copied data directly in the new Mathematica
clipboard window, which replaces the Kernel dialog. You can also
type Mathematica expressions directly into the clipboard,
evaluate them and paste them wherever needed.
- Improved sharing of workbooks with others—just click Unlink in the Mathematica Options -> Workbook tab. If colleagues have Mathematica Link for Excel, they will be automatically prompted to relink formulas when they open your workbook.
| |
|
|
|
|
|
|