Questions tagged [excellink]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1 vote
2 answers
116 views

How to Export a `Dataset` into a single worksheet of Excel

I have a Dataset: ...
user avatar
  • 4,391
1 vote
1 answer
37 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 ...
user avatar
1 vote
0 answers
87 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 ...
user avatar
  • 595
2 votes
0 answers
72 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 ...
user avatar
1 vote
1 answer
139 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... ...
user avatar
5 votes
1 answer
96 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 ...
user avatar
  • 2,379
9 votes
2 answers
225 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: ...
user avatar
  • 2,379
0 votes
0 answers
79 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 ...
user avatar
0 votes
0 answers
66 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 ...
user avatar
0 votes
0 answers
141 views

Run Mathematica notebook using VBA

I want to run mathematica notebook using excel vba, can someone help me with a sample code?
user avatar
  • 1
4 votes
2 answers
268 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.
user avatar
  • 8,075
0 votes
1 answer
179 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 ...
user avatar
3 votes
1 answer
451 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: ...
user avatar
  • 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 ...
user avatar
  • 2,065
4 votes
1 answer
111 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 ...
user avatar
  • 5,300
5 votes
2 answers
986 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 ...
user avatar
  • 1,117