# Tagged Questions

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

44 views

I have a raw data xsl file without heading column and column heading I want the A,B,C....J to be question 1, question2.....question J and 1,2,3 ....n to be participant 1, participant2, .........
71 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 ...
148 views

### loops and data file

I have solved a set of equations for a specific given data point and restricted my solutions to 100. then I did TrimmedMean to have the mean value of all 100 ...
43 views

### Calculate column number from alphabetic column reference in Excel [duplicate]

Here's a fun brain teaser. Can you give me a mathematical equation to calculate the column number of a Microsoft Excel column, given the alphabetic column reference? Let X, Y, & Z represent the ...
3k views

...
55 views

### Export a plot to Excel [closed]

I know questions similar to this have been asked before but I couldn't figure it out. These are my hypothetical lines: ...
72 views

### How to Import a password protected Excel (XLSX) file?

I have a password protected Excel (XLSX) file that I would like to Import into Mathematica. Is there a hidden option in Import ...
28 views

...
4k views

### Importing a large Excel file

I'm trying to import a simple Excel file containing 94,000 rows and 52 columns of various types, mostly Reals. It's a 38-MB file. I get this super helpful error ...
119 views

### Why can 10.3.1 import a 2MB excel file, but 10.4.0 cannot, with the same commands and file?

Here is the code: ...
75 views

### How to transfer symbolic expression to code? [closed]

I have a lot of messy things in Mathematica in a form like this: Mathematica perfectly solves all these symbolic equations. But I'm in trouble when using Excel link with Mathematica. I really need ...
473 views

### Exporting BSplineFunction to Excel

I am trying to export the data from a B Spline Function to a table in excel. I have tried exporting as many different file types (.xls, .txt, .dat), but all of ...
58 views

### Make Function from matrix [closed]

I have a set of excel data (time v temperature). When I extract it to mathematica it creates a matrix. I want to put the temperatures into a function that is time dependent, so is there a way to use ...
122 views

### References on time series analysis

I am interested in time series analysis. I used to evaluate my data by means of Excel. However, I found that Mathematica is a powerful tool that can process different kinds of mathematical operations ...
1k 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, it'...
61 views

### ExcelRun::failed: Type mismatch >> error when calling an Excel macro from Mathematica

I have a macro in a module within an Excel file (called "test.xlsm", saved on my desktop) that takes one argument as a string: ...
197 views

After upgrading to 10.1, I now get a prompt "Choose a Mathlink program to launch" when I call code that uses ExcelLink. This code worked prior to the update. I am wondering if this is a ...
221 views

### Sort Excel File Natural Order

Preferable without reading and then rewriting an excel(vs the COMLink) file how might I sort an excel file by Natural Order based on a column? This question is similar although probably not as ...
66 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 ...
99 views

### Map if-function on a list

I need to convert a battery charging mechanism from Excel into Mathematica. This Excel function is about deciding if the charge/decharge rate is positive, then multiply with efficiency factor, ...
152 views

...
490 views

### How to SemanticImport Multiple Excel Sheets

I have an Excel workbook with multiple sheets that I'd like to import into a dataset each. With Import I can target individual sheets by their name into a nested ...
207 views

### how can i associate the headings of columns/rows with content of itself and then recall what i want after i've imported the excel file in mathematica

Hello, i make another try... I have to import a file like this below (it is an excel file, i show you just the beginnig. it should have thousend of rows and columns). After i've imported the file i ...
130 views

### Take a specific part of a matrix imported from a .xls

i would like to know if there are any ways to link headings of a table i had imported with the data in the table itself. I imported a matrix from an excel file and i want to take a specific part of it....
101 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....
79 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 ...
81 views

I have an Excel spreadsheet column with hundreds of company names on it. I need to find the address (or just city if that's easier) The operation for this is simple in wolfram alpha. i.e. typing "...
186 views

### Curve fitting data I imported from excel [closed]

This is my first time posting here, so sorry if I break any rules. There is this excel document from which I imported two columns of data to mathematica. I need to fit the data into a curve so that ...
297 views

### Import data from excel and store it permanently in notebook

I am trying to write the code for doing the following: by clicking a button, import specific data from an Excel file which I select through a dialog window; input a name for the imported data set ...
682 views

### Importing Excel Spreadsheet containing Array Formulas

Has anyone had any success with importing an Excel Spreadsheet holding an array formula into Mathematica? The Syntax I'm using is ...
110 views

### Importing a spreadsheet with infinity values from Excel

I have imported a spreadsheet from Excel that I want to use as an adjacency matrix. I want to use this matrix as the argument in WeightedAdjacencyGraph, so I have ...
116 views

### Importing a 3D table from excel

I have a 3D table that I'm able to plot using ListPlot3D, but when I export the table to an excel file and try to import the saved data, the format is different. The imported table seems to have ...
152 views

### Function for importing and plotting data from excel spreadsheet

I know this must be a very basic question, but I could not find any answers. I need to create a function that: 1) imports data from an Excel Spreadsheet, 2) assign specific information from this xlsx ...
93 views

### Import mixed graph from Excel

I am new to Mathematica. I want to use the software as it allows analysis of mixed graphs (directed and undirected edges). I have my network as an Excel spreadsheet of three columns: source, target ...
182 views

### Using Wolfram Library Reference in Excel VBA

Long time ago I did this question to MathGroup, but without success. In Excel VBA, in Tool/References, there is a option called "Wolfram Mathematica Control 8.0 Type Library" I belive that ...
259 views

### How to access an already opened Excel file in Mathematica?

This post 4594 shows how to open a existent Excel file with Mathematica. And this 6686886 shows how to do what I need, but in C#. This 12282310 is another related one. How can I connect to a ...
114 views

### Filtering the output from Table and export it into excel

I have the following functions ...
312 views

### Cannot import Excel (xls or xlsx) files which have non-ASCII characters in the name

It seems mma9 works fine, but with mma10 it fail to load a file name with Chinese characters. I use MacBook Pro(Retina) with OSX 10.10.2, and Mathematica 10.0.0.0. I need the file name with Chinese ...
2k 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 ...
404 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 ...
187 views

### Export Multiple Arrays Into a Single Worksheet with Column Headers

I'm importing financial data into Mathematica, creating column headers for each array and exporting to Excel. The code below accomplishes most of this, but it creates a different worksheet for each ...
491 views

### Importing numbers from Excel

I guess my problem is very simple but I could not find the solution by searching it. I have a column in excel sheet (Sheet1 in Book1.xlsx) including student numbers as the following. ...
2k views

### Import Large Excel File

Currently, I am working on a large time series dataset, which contains 928,586 rows and 35 time intervals in columns, in excel format (.xlsx) and using Import to ...
117 views

### import from Excel adds a point to each number …How to get rid of it? [duplicate]

I import an excel file ...
167 views

### Exporting to a single spreadsheet in excel

I would like to export the output to excel file. But when I exported,for each value $q$ I am getting a different sheet. Can someone help me how to export it to a single sheet of an excel file. Thanks ...
1k views

### Exporting a .xlsx file with about 500 columns

When I want to Export["text.xlsx", data] where data is a matrix with 500 columns and 10000 rows, I get the error message: ...
157 views

### Table is divided into several sheets when imported in excel

i wanted to calculate a Student-t table with ...
86 views

Consider the PISA study report, which contains dozens separate spreadsheets in each respective excel files (see http://www.oecd.org/pisa/keyfindings/pisa-2012-results-volume-iv.htm) Is there any way ...