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

1
vote
1answer
44 views

how to use loop function to add column heading and row heading

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, .........
1
vote
0answers
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 ...
0
votes
1answer
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 ...
-2
votes
1answer
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 ...
2
votes
0answers
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: ...
3
votes
1answer
71 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 ...
30
votes
5answers
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 ...
0
votes
1answer
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 ...
0
votes
1answer
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 ...
0
votes
1answer
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 ...
4
votes
2answers
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 ...
18
votes
1answer
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'...
3
votes
1answer
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: ...
1
vote
1answer
196 views

ExcelLink: “Choose a Mathlink program to launch” after upgrading from 10.0.2 to 10.1

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 ...
0
votes
1answer
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 ...
1
vote
0answers
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 ...
3
votes
1answer
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, ...
6
votes
3answers
489 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 ...
4
votes
1answer
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 ...
3
votes
2answers
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....
1
vote
0answers
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....
4
votes
0answers
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 ...
0
votes
2answers
81 views

Company headquarters for each cell in a spreadsheet

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 "...
1
vote
1answer
184 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 ...
6
votes
2answers
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 ...
8
votes
1answer
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 ...
1
vote
1answer
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 ...
1
vote
1answer
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 ...
-1
votes
1answer
151 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 ...
0
votes
1answer
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 ...
6
votes
1answer
181 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 ...
10
votes
1answer
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 ...
0
votes
3answers
114 views
1
vote
1answer
311 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 ...
17
votes
2answers
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 ...
4
votes
0answers
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 ...
2
votes
1answer
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 ...
4
votes
2answers
490 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. ...
5
votes
0answers
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 ...
1
vote
1answer
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 ...
11
votes
2answers
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: ...
2
votes
3answers
157 views
0
votes
1answer
86 views

Importing Selected Spreadsheets [duplicate]

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 ...
5
votes
2answers
497 views

Exporting row vector as a column in excel

I want to export a vector in Mathematica to appear as a column in Excel. I am trying A={1, 2, 3}; Export["mfile.xls", {"A" -> A}] But it is showing 1,2,3 in ...
2
votes
4answers
282 views

Import xls data with dates

I have an excel table that have 2 columns, the first one are dates, and the second one are values. I want to plot the value vs the date. I need to: first clean all the non numbers strings like {"Junio"...