Questions tagged [excel]

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

23 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
5
votes
0answers
483 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
289 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
431 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
604 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
61 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 ...
2
votes
0answers
78 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
644 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
46 views

How to perform linear extrapolation on scatter plot?

I have five sets of data and I want to see the behavior as the data goes to 0. This is my code so far: ...
1
vote
0answers
86 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 ...
1
vote
0answers
383 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
166 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
223 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
33 views

how to exclude empty cells when Importing from excel?

I am very new to mathematica and I need help importing excel file. The file that I am importing has a bunch of empty cells throughout the column and it is giving me some trouble taking an average of ...
0
votes
0answers
45 views

Import Accuracy/General Accuracy

r[i] = SetPrecision[ Import[epath, {"Data", epath2, 9 + counts + 5*i - 2, excelfile2}], prec]; epath is file name, epath2 is tab, count is row, ...
0
votes
0answers
50 views

Exporting Mathematica data and using it in excel

I run this code: ...
0
votes
0answers
54 views

Loop function for a list of codes

I have a list of codes that start with importing column D of an excel sheet which has a hyperlink. Then, the code moves onto importing the text version of the hyperlink and further proceeds with ...
0
votes
0answers
44 views

Issue with generating excel File as an output

I am running a script that saves the output in excel format. At the begging, it worked well and generates the excel file; However, after a few times running I got the following message before ...
0
votes
0answers
49 views

Importing Excel Files and Extracting Parts of the Dataset

I'm trying to import two Excel files that have multiple sheets to Mathematica using the following code: ...
0
votes
0answers
101 views
0
votes
0answers
158 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
133 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
49 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, ...