Questions tagged [excellink]
The excellink tag has no usage guidance.
17
questions
0
votes
0
answers
49
views
How to call a macro name with _ from ExcelLink?
I am running the latest version of ExcelLink` and I am able to call macros with the name like optimize using:
...
- 9,013
1
vote
2
answers
134
views
1
vote
1
answer
38
views
Issue with transferring list with different length to excel
I have two lists with different lengths and would like to transfer them to excel with the titles "Normalx+" and "Normaly+" respectively. I am using the following script, although ...
- 501
1
vote
0
answers
92
views
How do I use Mathematica computation of special functions in Microsoft Excel computation?
I have a model equation which I find somehow easier to compute with some experimental data in Microsoft Excel. I had an initial model which is basically a Bessel function. In Mathematica, I was able ...
- 645
2
votes
0
answers
94
views
Exporting to Excel using Excel Link
I often export results from Mathematica to Excel. Then I have an auxiliary xlsm that formats the export file for me. Would Excel Link allow me to export data to Excel and to format it? The ...
- 3,656
1
vote
1
answer
150
views
ExcelLink stop working after Windows 10 update
After Windows Update KB4508433 & KB4512508, ExcelLink stop to work.
If I uninstall these updates, it work again, but windows return to install them...
...
- 451
5
votes
1
answer
112
views
Problem with inserting a picture into Excel sheet in NETLink way
I'm using the NETLink to work with Excel object, there be differences to write code according to the ...
- 2,399
9
votes
2
answers
253
views
Problem with Excel operation in NETLink way
I'm using the NETLink package to build a Excel file and trying to fill it with some data as this:
...
- 2,399
0
votes
0
answers
81
views
mathematica browser function in excel is empty
I have installed mathematica version 10.4.1.0 (64bit) on Windows 10 and Link for Excel version 3.7.1
Unfortunately I am not able to select any mathematica functions from the browser that I open in ...
0
votes
0
answers
67
views
How to export this data/string more efficiently if possible at all? [duplicate]
Previously I asked a related question about my test data.
Looking at the size of the data
ans // ByteCount
9602605504
...
- 4,966
0
votes
0
answers
157
views
Run Mathematica notebook using VBA
I want to run mathematica notebook using excel vba, can someone help me with a sample code?
- 1
4
votes
2
answers
338
views
ExcelLink: How to change cell properties like font family, size and borders?
I just purchased the Mathematica Link for Excel. I can't figure out how to change the cell properties in excel using ExcelLink package? Can someone please help.
- 9,013
0
votes
1
answer
190
views
How to transfer symbolic expression to code? [closed]
I have a lot of messy things in Mathematica in a form like this:
Mathematica perfectly solves all these symbolic equations. But I'm in trouble when using Excel link with Mathematica. I really need to ...
3
votes
1
answer
455
views
ExcelRun::failed: Type mismatch >> error when calling an Excel macro from Mathematica
I have a macro in a module within an Excel file (called "test.xlsm", saved on my desktop) that takes one argument as a string:
...
- 125
2
votes
1
answer
1k
views
ExcelLink: "Choose a Mathlink program to launch" after upgrading from 10.0.2 to 10.1
After upgrading to 10.1, I now get a prompt "Choose a Mathlink program to launch" when I call code that uses ExcelLink. This code worked prior to the update. I am wondering if this is a ...
- 2,249
4
votes
1
answer
114
views
Control Object Annoyance
This may seem like is a trivial annoyance, but it really is a control object "convenience of use" issue. Example: I want to use a popup menu to determine which Excel worksheet I take data from, as ...
- 5,422
6
votes
2
answers
1k
views
Graphing time-series
I'm currently trying to use data gathered as a function of time (here, the fluorescence of a biological sample), but am new to Mathematica and don't know how to properly specify axis relations (and ...
- 1,137