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
0answers
48 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
79 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, ...
1
vote
1answer
192 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
146 views
3
votes
1answer
174 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
121 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 ...
3
votes
0answers
63 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 ...
1
vote
0answers
70 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 ...
0
votes
2answers
74 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
130 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
236 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
93 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
145 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
103 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
83 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
148 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
230 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 ...
-1
votes
1answer
130 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
3answers
110 views

Filtering the output from Table and export it into excel

I have the following functions ...
1
vote
1answer
263 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 ...
2
votes
1answer
154 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 ...
1
vote
2answers
370 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
109 views
1
vote
1answer
137 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
150 views

Table is divided into several sheets when imported in excel

i wanted to calculate a Student-t table with ...
0
votes
1answer
81 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
421 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
426 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
258 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 ...
2
votes
2answers
208 views

Problem with exporting lists to Excel

When I use the form Export["file", list, "Table"] to export a list to Excel, I get columns of lists. I want my Excel sheet to have each list element in a separate ...
0
votes
2answers
94 views

Import array indices from Excel

In an Excel file, I have some numbers which I will use as the indices of arrays. I want to read those numbers and assign them as the array indices in Mathematica. For instance, in Excel I have and ...
2
votes
1answer
374 views

Importing data from excel and assigning a variable to each of its columns

How should I assign variables to the data imported from excel containing 3 columns which are time, mean and standard deviation. I want to perform operations on the three variables to get new ...
2
votes
1answer
205 views

Export results to excel

I have the following problem solved in Mathematica ...
3
votes
1answer
234 views

Formatting imported Excel spreadsheet to include tooltips on plot

I have an Excel spreadsheet with numbers on two columns and names in a 3rd. I would like to plot a 2d graph of the first 2 columns and see the respective name from the 3rd column as a tooltip. I ...
0
votes
1answer
119 views

Replicating Excel output using Mathematica

I have 2 columns of data in Excel. One is inputs the other is outputs. I ask Excel to make a graph of that data and to fit the data to a power trendline. Excel does this and it's fine as far as it ...
5
votes
0answers
1k 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 ...
2
votes
1answer
134 views

Naming Excel Sheets automatically

After performing some calculations with excel sheets I end with a tridimensional matrix a to be export to a .xlsx format and a vector q that contains the name of all the sheets (so $Length[q] = ...
7
votes
1answer
2k views

Creating a standalone (executable) from mathematica code

I have written a small mathematica code to input a ".csv" file and output the data in a specific format, in a ".txt" file. I would like to give this program as an executable to my friend as she ...
0
votes
1answer
247 views

Is it possible to convert expressions containing Root objects to Excel formulas?

I am still a beginner and do not fully understand pure functions and root objects. When I tried to calculate the inverse of a function, Mathematica gave me: ...
13
votes
1answer
430 views

Formatting Excel Borders with .Net

I have various tables generated in a Mathematica application and need to export this to MSExcel formatted in a specific way. The ...
0
votes
1answer
1k views

Plotting Surface Graph from Excel Data Import to Mathematica [duplicate]

I am trying to make a surface graph on Mathematica using Excel Data. My x-axis should be the "A" Column and my y-axis should be the "1" Row. The box of data in between the x-axis and the y-axis should ...
2
votes
0answers
606 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 ...
5
votes
1answer
407 views

windrose with data from Excel

How to Import data from excel and use them to Plot windrose instead? Example, {{Strength, Angle(degrees)}..} ...
-3
votes
1answer
864 views

import Excel sheets by name

I'm importing data from Excel. It appears that the sheet number needed in the Import statement is taken from the order that the sheets appear in the open Excel file. I need to import 2 of the sheets ...
8
votes
1answer
308 views

Error while exporting to Excel with named sheets

Using Mathematica v9.0.1 This example is from the docs: ...
2
votes
1answer
2k views

Having Problem with Importing Excel file to Mathematica Notebook?

I have solved some equations and exported the final results, which they are several Matrices, as a EXCEL file ( .Xls ). Now, I want to use these EXCEL files as my inputs to solve some other equations. ...
6
votes
1answer
2k views

Possible to export Excel formulas?

I would like to export an .XLS file complete with data and formulas. Is this possible using Export? For example, here is data and a formula :- I can import ...
8
votes
1answer
643 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
4answers
341 views

Calculating difference ratios (Δβ/Δρ) from a data set

I am little bit confused about how to calculate δβ/δρ value if I have set of values like this. I have the values of β and ρ like this. ...
4
votes
0answers
373 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 ...