Questions tagged [excel]

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

15 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
5
votes
0answers
412 views

Exporting *formatted* Excel workbooks

I export Mathematica tables to Excel every day, for sharing reports with non-Mathematica users. It exports the values without flaw, but ignores any formatting. Consider the following: ...
5
votes
0answers
270 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
297 views

How to OpenSQLConnection with JDBC for “Microsoft Excel”?

I have a very large Microsoft Excel file that will not Import even after setting a 5GB heap size for Java as follows. ...
4
votes
0answers
581 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
71 views

Excel file reference disappears after `Import`; how to avoid this?

EDIT An excel file reference in a formula like =[source.xlsx]Sheet1!A1 will be replaced by [1]Sheet1!A1 after 'Import'. How do ...
2
votes
0answers
477 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....
2
votes
0answers
1k 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
62 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... ...
1
vote
0answers
277 views

What could be wrong when using Import for an XLSX?

I am using MMA 11.2.0.0 on Win7X64. Import["combined_analysis.xlsx", {"sheet1"}] Import::noelem: The Import element "sheet1" is not present when importing as ...
1
vote
0answers
119 views

Merging Excel workbooks into a single workbook using Mathematica

I have several Excel workbooks (in *.xlsx format) that I wish to merge into a single new workbook. The data in the workbooks have exactly the same format; they contain tables similar to this one: I'...
1
vote
0answers
141 views

Transform Mathematica formula into ExcelForm for copy and paste to Excel cell

What I need is a function ExcelForm[expression] which transforms a given expression into a form, which I could just copy and paste into an Excel cell. Just like TeXForm[expression] does for TeX.
0
votes
0answers
74 views
0
votes
0answers
107 views

Import element from large excel file

I am trying to import some rows and columns from a large excel file, but I get this error There was insufficient Java heap space for the operation. Try increasing the Java Virtual Machine heap ...
0
votes
0answers
111 views

Run Mathematica notebook using VBA

I want to run mathematica notebook using excel vba, can someone help me with a sample code?
0
votes
0answers
46 views

Merging Excel workbooks into a single workbook using Mathematica (Redux)

In reference to: "Merging Excel workbooks into a single workbook using Mathematica" the only solution that has worked for me so far is: `setDir:=Quiet@Check[SetDirectory@DirectoryName@$InputFileName, ...