Tagged Questions
9
votes
1answer
165 views
Mathematica Functions from VBA
I'm trying to call Mathematica functions from VBA (Excel) using .NETLink without success.
(Yes, I know Mathematica Link for Excel exists. And yes, I know the proper thing to do is buy it. However, ...
2
votes
1answer
54 views
Using NetLink to Import Excel File
I can import an Excel file into Mathematica easily:
But when I try from .Net it fails:
These are the commands and errors I am getting:
...
1
vote
1answer
142 views
Converting Excel serial dates with NETLink
Excel serial dates are not straightforward to convert since they include non-existent dates, e.g.
{DatePlus[{1990, 1, 0}, 59], DatePlus[{1990, 1, 0}, 60]}
...
11
votes
2answers
841 views
Open Excel file with Mathematica
I would like to open an Excel file and manipulate it as a COM object. While I'm able to open an instance of excel with
...
