Questions tagged [excellink]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
9
votes
2answers
156 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: ...
5
votes
2answers
779 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 ...
5
votes
1answer
59 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 ...
4
votes
2answers
161 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.
4
votes
1answer
109 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 ...
3
votes
1answer
381 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: ...
2
votes
1answer
680 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 ...
0
votes
1answer
109 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 ...
0
votes
0answers
46 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
0answers
60 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 ...
0
votes
0answers
108 views

Run Mathematica notebook using VBA

I want to run mathematica notebook using excel vba, can someone help me with a sample code?