For questions about importing from or exporting to Microsoft Excel sheets, and interfacing to Microsoft Excel using COM or other methods.

learn more… | top users | synonyms

4
votes
0answers
84 views

MathLink Excel version 3.5 & 3.6 inconsistency

I bought and installed Mathematica Link for Excel 3.6.0. However, after installation, it appears inside Excel as Version 3.5.0. Has anyone seen this issue? I have emailed Wolfram support but have ...
4
votes
0answers
408 views

Retrieving Data from Excel Using NETLink / Pulling data using RTD Link

Reference: I've looked at the posting Open excel file with Mathematica. My intention is to be able to use Excel's RTD capability in order to pull market data into Mathematica. To my knowledge, this ...
2
votes
0answers
737 views

How to Export Data from Mathematica into Excel specific cell

for import,we can do like this Import["XXX.xlsx", {"Data",1,2,3}],Mathematica will get the cell {2,3} of the "sheet1" in "XXX.xlsx". But if we want to export data from Mathematica to one Excel ...
1
vote
0answers
75 views

decimal point changes in mathematica after importing data from excel

I am trying to import data from excel into mathematica. It works fine except that the values of all the variables after the import into mathematica change at 6th decimal point. For example, variable ...
1
vote
0answers
67 views

Import Excel data from within Manipulate

I am processing a set of data using Manipulate, as I need some user input as well and the whole code must be delivered as .cdf . The set of data should be imported from an Excel file which is selected ...
1
vote
0answers
106 views

MathLink error msg: Libraries are not installed or outdated

I installed Mathematica 10.2.0.0, Excel 2013 32-bit, and MLink for Excel 3.6.0. In Excel, I added Mathematica Link in Add-Ins, and included the C:\ProgramData\Mathematica\ folder as a Trusted Location....
0
votes
0answers
30 views