Mathematica Link for Excel 3.6 
User’s Manual 
Reference Guide 
Copyright © 2014 Wolfram Research, Inc.
C# merge pdf pages - Merge, append PDF files in C#.net, ASP.NET, MVC, Ajax, WinForms, WPF
Provide C# Demo Codes for Merging and Appending PDF Document
add pdf together one file; acrobat combine pdf files
C# merge pdf pages - VB.NET PDF File Merge Library: Merge, append PDF files in vb.net, ASP.NET, MVC, Ajax, WinForms, WPF
VB.NET Guide and Sample Codes to Merge PDF Documents in .NET Project
c# merge pdf files into one; best pdf combiner
C# PDF Page Insert Library: insert pages into PDF file in C#.net
how to merge PDF document files by C# code, how to rotate PDF document page, how to delete PDF page using C# .NET, how to reorganize PDF document pages and how
acrobat merge pdf files; reader create pdf multiple files
C# PDF Page Delete Library: remove PDF pages in C#.net, ASP.NET
Provide C# Users with Mature .NET PDF Document Manipulating Library for Deleting PDF Pages in C#. Demo Code: How to Delete Consecutive Pages from PDF in C#.NET.
acrobat split pdf into multiple files; attach pdf to mail merge
TableofContents
Overview
................................................................................................................................... 1
Features
................
1
Changes
.................................................................................................................................... 2
Working inMathematica
GettingStarted
.......................................................................................................................... 6
GeneralPrinciples
..................................................................................................................... 9
AutomatingExcel
...................................................................................................................... 12
CreatingExcelFunctions
.......................................................................................................... 15
CreatingExcelMacros
............................................................................................................... 21
Working inExcel
GettingStarted
.......................................................................................................................... 25
GeneralPrinciples
..................................................................................................................... 32
WorkingwithFunctions
............................................................................................................. 34
WorkingwithMacros
................................................................................................................. 41
LinkManagement
...................................................................................................................... 44
SharingWorkbooks
................................................................................................................... 45
Usingthe Clipboard
LoadingtheAdd-In
....................................................................................................................   47
Copying DatafromExcel
...........................................................................................................   48
Pasting DatatoExcel
.................................................................................................................   49
50
FixingProblematic Data
ExcelLink Reference
ExcelLinkFunction Index
...........................................................................................................   69
Excel Reference
ExcelWorksheetFunctions
.......................................................................................................   52
Toolbar Commands
...................................................................................................................   55
Context Commands
...................................................................................................................   59
KeyboardShortcuts
...................................................................................................................   62
DataTypes
.................................................................................................................................   64
68
NumberFormats
........................................................................................................................
C# PDF File & Page Process Library SDK for C#.net, ASP.NET, MVC
C#: Convert PDF to HTML; C#: Convert PDF to Jpeg; C# File: Compress PDF; C# File: Merge PDF; C# File: Split PDF; C# Page: Insert PDF pages; C# Page: Delete PDF
acrobat combine pdf; pdf combine two pages into one
C# PDF Page Extract Library: copy, paste, cut PDF pages in C#.net
Easy to Use C# Code to Extract PDF Pages, Copy Pages from One PDF File and Paste into Others in C#.NET Program. C#.NET Project DLLs: Copy and Paste PDF Pages.
merge pdf; merge pdf files
VB.NET PDF Page Delete Library: remove PDF pages in vb.net, ASP.
Page: Delete Existing PDF Pages. |. Home ›› XDoc.PDF ›› VB.NET PDF: Delete PDF Page. How to VB.NET: Delete Consecutive Pages from PDF.
scan multiple pages into one pdf; reader merge pdf
VB.NET PDF Page Insert Library: insert pages into PDF file in vb.
you want to read the tutorial of PDF page adding in C# class, we suggest you go to C# Imaging - how Add and Insert Multiple PDF Pages to PDF Document Using VB.
asp.net merge pdf files; reader combine pdf pages
Introduction
Overview
Mathematica Link for Excel consists of two main components:
The ExcelLink package.
The MathematicaLink add-in.
These components work together to provide full two-way connectivity between Mathematica and Excel.
To use the link from Mathematica, you load the ExcelLink package.
To use the link from Microsoft Excel, you load the MathematicaLink add-in.
Features
The ExcelLink package provides:
A set of Mathematica functions that allow you to:
! Read and write data to Excel ranges.
! Display graphics, typeset equations, and formatted output in Excel.
! Create, open, modify, and close Excel files.
! Develop Excel worksheet functions in Mathematica.
! Develop Excel macros in Mathematica.
The MathematicaLink add-in provides:
A set of worksheet functions that allow you to use Mathematica functions in Excel formulas.
Mathematica Function Wizard to help you learn about and enter Mathematica functions.
Mathematica macros window that allows you to turn Mathematica code into Excel macros.
A special Clipboard window that allows you to easily copy and paste data between programs.
A searchable PDF-based manual.
ExcelLink
1
C# PDF Page Rotate Library: rotate PDF page permanently in C#.net
page, it is also featured with the functions to merge PDF files using C# .NET, add new PDF page, delete certain PDF page, reorder existing PDF pages and split
break a pdf into multiple files; combine pdfs online
C# PDF Convert to Jpeg SDK: Convert PDF to JPEG images in C#.net
Output.jpg"); Following demo code will show how to convert all PDF pages to Jpeg images with C# .NET. // Load a PDF file. String
pdf mail merge; append pdf files reader
Changes
Version 3.5
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!"mycomment"").
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, 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 addin startup logic.
Other minor improvements and fixes.
Version 3.2
New in Version 3.2
Compatibility with Mathematica 7.0 including Mathematica 7.0-based icons.
ExcelOpenExcelSave, and ExcelDialog support for Excel 2007 .xlsx, .xlsm, .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.
2
ExcelLink
Improved in Version 3.2
Improved message print format in Mathematica 6 and 7.
Fixed a bug where some workbooks with macro buttons did not relink correctly.
Improved ExcelInstall!Visible %&True" method for launching visible instance of Excel.
Improved Mathematica Macros dialog method of inserting of code boxes and buttons.
No "kernel connection closed" dialog if initialization code ends with Quit!".
Other minor improvements and fixes.
Version 3.1
New in Version 3.1
Compatibility with Mathematica 6.0.
Compatibility with Excel 2007.
Keyboard shortcuts for Excel toolbar commands.
Additional Excel message-related options.
Restored backwards 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 the link.
Improved printable PDF documentation.
Version 3.0
New in Version 3
Display of typesetting and formatted output in Excel.
Creating Mathematica-based macros.
A suite of Mathematica functions to interact with and automate Excel.
Improved in Version 3
Start/End Link button is now an Evaluate button. This button can be used to interrupt current evaluations and re-
evaluate the workbook once changes have been made. To end a link, hold down the 
Shift
key and click the Evaluate
button.
ExcelLink
3
You can now use the Function Wizard to edit existing formulas, select and assign options more easily, and browse for built-
in functions by category.
Standard packages are automatically declared by default and can be browsed directly within the Function Wizard. This
functionality replaces the Libraries Dialog.
Data Copy and Paste commands are now available from a Mathematica Context Menu. You can now see the data you are
copying and pasting using the Mathematica Clipboard window.
Kernel Dialog has now been incorporated into the Mathematica Clipboard window. You can type Mathematica expressions
directly into the Clipboard window, evaluate them, and paste the results somewhere if you choose.
Messages are now displayed and stored to a nonmodal window. Using the window you can scroll through multiple mes-
sages, find the source of a message, and even save the messages to a log file.
Formula Activate/Deactivate/Recalculate commands are available from the Mathematica Context Menu as a Com-
ments toggle and Recalculate command.
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.
To share workbooks with others, you can unlink the workbooks' formulas and macro buttons using the Unlink button in
the Mathematica Options " Workbook tab. If colleagues have the link, they will be automatically prompted to relink
formulas when they open the workbook.
Strings and floating-point numbers can now be specified using the DATA worksheet function.
Obsolete in Version 3
The MATH worksheet functions provided in Version 2 have been superseded by a more flexible set of functions in Version
3. The MATH worksheet functions still work in Version 3. However, there may be slight differences in how results are
returned.
If you would like to convert your existing formulas, here are examples of how they can be mapped.
Version 2
Version 3
#MATH$"Inverse", A1:B2%
#EVAL$"Inverse", A1:B2%
#MATHEXACT$"Inverse", A1:B2%
#EVAL$"InputForm", EXPR$"Inverse", A1:B2%%
#MATHVOLATILE$"Random&'"%
#CALC$EVAL$"Random&'"%%
#MATHDEFINE$"m", A1:C3%
#EVAL$"Set", "m", A1:C3%
#MATHCODE$B1:B10%
initialization code lives is a code box, no formula required
MATHFORMULA & CELL functions
experimental functions no longer supported
MATH function mappings.
4
ExcelLink
The ReadExcel function has been superseded by a new suite of Excel functions. Here is an example of how an improved
ReadExcel function could be defined using the new Excel functions.
ReadExcel!file", sheet", rng"#:$
Module!%book, data&,
If!Not!ExcelCheck!ExcelBook!file###, book$ExcelOpen!file##;
data$ExcelRead!ExcelRange!file, sheet, rng##;
If!ValueQ!book#,ExcelClose!book##;
data
#
This ReadExcel function checks to see if the required file is already open in Excel. If not it opens the file, reads the
required data, and closes the book if it was not already open.
ExcelLink
5
Working in Mathematica: Getting Started
Loading the Package
To start using the link from inside Mathematica, you must first load the ExcelLink package.
In[1]:=
''ExcelLink`
The ExcelLink package provides a library of functions and symbols relating to Excel.
In[2]:=
?ExcelLink`(
ExcelLink`
Excel
ExcelFilter
ExcelRead
ExcelTypeset
ExcelActivate
ExcelForm
ExcelRefresh
ExcelUninstall
ExcelAddress
ExcelFormat
ExcelRename
ExcelUnshare
ExcelBook
ExcelGraphic
ExcelResize
ExcelWrite
ExcelBooks
ExcelInsert
ExcelResult
ImageFormat
ExcelCalculate
ExcelInstall
ExcelRun
MaxCharacters
ExcelCall
ExcelName
ExcelSave
ToExcel
ExcelCheck
ExcelNew
ExcelSelect
$ExcelDialogs
ExcelClear
ExcelObject
ExcelShape
$ExcelDirectories
ExcelClose
ExcelOffset
ExcelShapes
$ExcelGraphic
ExcelContext
ExcelOpen
ExcelShare
$ExcelLink
ExcelDate
ExcelOutput
ExcelSheet
$ExcelOutput
ExcelDelete
ExcelPosition
ExcelSheets
$ExcelResult
ExcelDialog
ExcelRange
ExcelSize
$ExcelShare
ExcelDirectory
ExcelRanges
ExcelStatus
$ExcelTypeset
You can learn more about these functions and symbols by looking up its entry in the Mathematica Reference section of this
information. You can also access this information within Mathematica's help system by looking under Add-Ons.
Assigning and Retrieving Data
In[1]:=
Needs!"ExcelLink`"#
The top-level Excel function provides an easy way to specify a location in Excel, as if it were a variable, then assigns or
retrieves data from it.
In[2]:=
Excel!"A1"#$"hello"
In[3]:=
Excel!"A1"#
Out[3]=
hello
You can also clear data from the Excel location.
In[4]:=
Excel!"A1"#$.
6
ExcelLink
Documents you may be interested
Documents you may be interested