Questions tagged [excel]

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

Filter by
Sorted by
Tagged with
1
vote
1answer
231 views

How to plot cumulative stock return using Excel data?

I have an Excel file with daily prices and returns of a number of stocks. I need to plot a cumulative return for each stock. How can i do this, using Excel data, ...
1
vote
2answers
146 views

Printing an array such that the values can be copied and pasted to a Excel Row

Given an array I would like to print it in Mathematica such that the values can be simply copied and pasted into an Excel's row. What is the best approach for this? ...
1
vote
1answer
143 views

Having trouble importing values from Excel into Mathematica [closed]

When I import values from an Excel workbook into Mathematica; for instance: originalvalues = {111011, 111011.03, 112011, 112021, 112031} they are imported as: ...
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
1answer
56 views

Make BarCharts from file CSV

I have a xls file and the data are: Hour Expenses1 Expenses2 17:50 1500 2000 17:55 1750 1830 18:00 1980 1330 There are three columns and I ...
1
vote
1answer
110 views

Import Excel with variable row number [closed]

i am importing some Excel coloumns, what perfectly works. Unfortunatly i am current setting the range Range [2, 50] statically ...
0
votes
3answers
479 views

Read timeseries data from CSV

I am new to Mathematica and have v10. I would like to you use the new TimeSeriesAggregate[tsdata, "Quarter", Total] feature to return aggregated descriptive stats. I import a number of columns of ...
2
votes
0answers
69 views

How do I import an entire column from an Excel Sheet [duplicate]

The Wolfram Documentation gives information on how to import an entire sheet, and an entire row, but not an entire column. Currently, the code I have been trying to contort into a working form is: <...
1
vote
0answers
153 views

decimal point changes in mathematica after importing data from excel [closed]

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 ...
-2
votes
1answer
91 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 ...
1
vote
1answer
104 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, .........
2
votes
0answers
314 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
596 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 ...
3
votes
1answer
235 views

How can I export dataset to excel with names

...
5
votes
1answer
170 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: ...
0
votes
1answer
111 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 to ...
0
votes
1answer
85 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 ...
0
votes
1answer
176 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 ...
4
votes
2answers
304 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 ...
3
votes
1answer
395 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: ...
3
votes
1answer
170 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 ...
4
votes
1answer
263 views

Map if-function on a list [closed]

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, ...
0
votes
1answer
485 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 ...
6
votes
2answers
182 views

extract a mxn matrix

...
0
votes
1answer
137 views

Package to read in data from excel files

I want make a package to add a function to Mathematica that reads all excel files is the working directory that is set after the package is loaded. ...
4
votes
1answer
660 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 ...
4
votes
2answers
227 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....
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 ...
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....
0
votes
2answers
111 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
799 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 ...
7
votes
2answers
777 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 ...
1
vote
1answer
465 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 ...
2
votes
1answer
711 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 ...
1
vote
1answer
189 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 ...
0
votes
1answer
138 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
359 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 ...
11
votes
1answer
427 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
1answer
393 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 ...
-1
votes
3answers
152 views

Filtering the output from Table and export it into excel

I have the following functions ...
5
votes
1answer
890 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 ...
3
votes
1answer
571 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 ...
5
votes
2answers
1k 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. ...
0
votes
1answer
154 views

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

I import an excel file ...
1
vote
1answer
313 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 ...
2
votes
3answers
190 views

Table is divided into several sheets when imported in excel

i wanted to calculate a Student-t table with ...
0
votes
1answer
122 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 ...
6
votes
3answers
1k 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 ...
5
votes
2answers
1k 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
426 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"...