Questions tagged [excel]

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

22 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
5
votes
0answers
455 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
282 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
362 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
598 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
52 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
76 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
582 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
24 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
355 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
146 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
189 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
48 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
34 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
33 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
23 views

Exporting column data to a specific column and row range

When importing from an Excel file for the data contained in column 3 and rows 2 through 58, for example, one can use the following command: ...
0
votes
0answers
39 views

How to use Headers after imported them?

I read this post here, and played a bit with the Import function, so I now have my data imported from xlsx file, which say is a <...
0
votes
0answers
91 views
0
votes
0answers
133 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
123 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
48 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, ...