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
37 votes
7 answers
8k 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 ...
ArgentoSapiens's user avatar
34 votes
6 answers
11k views

Cut and paste data from a spreadsheet

I have a set of data points in two columns in a spreadsheet (OpenOffice Calc): I would like to get these into Mathematica in this format: ...
Lucy Brennan's user avatar
20 votes
1 answer
2k 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'...
kale's user avatar
  • 10.9k
18 votes
2 answers
3k 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 ...
iav's user avatar
  • 2,006
18 votes
2 answers
1k 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 ...
BlueMac's user avatar
  • 711
15 votes
3 answers
4k views

How to write data from Mathematica to an existing formatted Excel file?

I have a sheet in an Excel file already formatted: different colors, fonts, columns width and cells styles. I want to fill-out values from Mathematica into specific cells of that sheets, or use that ...
jss's user avatar
  • 405
15 votes
1 answer
7k 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 doesn'...
Pavithran Iyer's user avatar
15 votes
1 answer
4k views

Export data to Excel with adjusted column size

I'm trying to export some data with formats into Excel. It works ok, but the columns size get not properly adjusted. I don't want to use some complicated solution based on this example. In my tests, ...
Murta's user avatar
  • 26.2k
13 votes
3 answers
5k views

Excel Headers --> Mathematica

I have a large Excel .xls file. Miniature version shown below: (formatting should appear as two columns...) ...
nkormanik's user avatar
  • 309
13 votes
2 answers
6k views

How to dynamically name and date a file for export?

I have various functions that export Excel and text files, and need to have them named with a name based on the content of some variables in the function and the time and date. How can this be done ...
Nothingtoseehere's user avatar
13 votes
3 answers
6k views

Exporting data to a new excel sheet of a pre-existing excel file

...
Amatya's user avatar
  • 6,888
12 votes
3 answers
2k views

Exporting data from Excel into Mathematica using clipboard

I know that it's possible to import Excel data into Mathematica using the Import command, as we can see in this post. But sometimes I need just to do some fast ...
Murta's user avatar
  • 26.2k
11 votes
1 answer
535 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 ...
Murta's user avatar
  • 26.2k
11 votes
2 answers
2k 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: ...
Karsten W.'s user avatar
  • 1,383
9 votes
2 answers
262 views

Problem with Excel operation in NETLink way

I'm using the NETLink package to build a Excel file and trying to fill it with some data as this: ...
Jerry's user avatar
  • 2,459
9 votes
1 answer
4k 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 them, ...
Chris Degnen's user avatar
  • 30.9k
9 votes
1 answer
383 views

Is it possible to construct a function to make a poor man's Mathematica database?

I have a function that is set up to write to a database with 10-20 standard variables with 10 fields each, but the application is going to a place where database access is not available. Can ...
Nothingtoseehere's user avatar
8 votes
2 answers
3k views

Exporting interpolating functions to excel

I have a question about exporting an InterpolatingFunction to Excel. I checked the forum, but I still couldn't completely understand how to solve my problem. Could ...
DumbleKo's user avatar
  • 363
8 votes
3 answers
2k 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 ...
Edmund's user avatar
  • 42.3k
8 votes
2 answers
911 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 ...
Conrad's user avatar
  • 723
8 votes
1 answer
316 views

Mathematica and Excel

I have a number of large data sets in Excel and .dat from OMEdit Modelica that then need to import some or all of it to Mathematica for manipulation and plotting. Importing the data is easy enough ...
Chris B's user avatar
  • 111
8 votes
1 answer
1k views

Importing Excel Spreadsheet containing Array Formulas

Bug introduced in ?.?.? and fixed in 11.0.0 Has anyone had any success with importing an Excel Spreadsheet holding an array formula into Mathematica? The Syntax I'm using is ...
Jonie's user avatar
  • 1,199
8 votes
1 answer
407 views

Error while exporting to Excel with named sheets

Using Mathematica v9.0.1 This example is from the docs: ...
Dr. belisarius's user avatar
8 votes
1 answer
3k views

Why does Export drop namespace prefixes in the exported XML file?

I am trying to generate an Excel-compatible XML file from Mathematica. First, I created a test XML file by saving a Microsoft Excel workbook as "XML Table". Then I ...
Alexey Popkov's user avatar
7 votes
5 answers
695 views

Excel column label from integer

I would like to create a function in Mathematica, which returns the equivalent Excel column label (e.g., A, Z, AA, AZ, and so on) given a column number. I think it can be done with ...
Walter Schrabmair's user avatar
7 votes
2 answers
2k views

Is it possible to export a graph as graphic to Excel?

It is straightforward to export lists to Excel with Export. Can I export a graphic image, too? This does not work: ...
Karsten W.'s user avatar
  • 1,383
7 votes
2 answers
1k views

CSV vs XLS for import

I need to import data from various database sources. At the moment I plan on importing files via a CSV file or XLS. All the data if in XLS would be on one sheet (notebook). Are there any advantages ...
David Kerr's user avatar
7 votes
1 answer
4k views

Export Table from Mathematica into specific cells Excel

How can I export a table to Excel - to specific cells, e.g. D1-E2? Background: I want to compare results, and it's easier to have the results on one spreadsheet. I'm using Mathematica 6. This is my ...
Stefanie Schubert's user avatar
7 votes
2 answers
8k views

Importing from Excel

I'm trying to import a matrix from Excel to Mathematica. My code is: Import["desktop/stproj.xls", "xls", data, 1] The output is some weird stuff about population ...
user avatar
7 votes
1 answer
511 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 ...
Murta's user avatar
  • 26.2k
6 votes
2 answers
406 views

Fitting an exponential model: Mathematica vs. Excel [closed]

My data is: data = {{0, 0.05}, {40, 0.079}, {80, 0.113}, {120, 0.18}, {160, 0.31}, {200, 0.5}, {240, 0.71}, {280,0.86}, {320, 1.02}}; With Excel we can fit the ...
user avatar
6 votes
2 answers
3k views

Converting numbers to integers

I've read the available documentation but I still haven't found an NumberForm -> Integer function yet. No result in this site's search, either. Does it exist? ...
CHM's user avatar
  • 3,395
6 votes
2 answers
308 views

How can I export a Dataset with graphics as an Excel file?

I would like to export a Dataset to Excel. The Dataset contains graphics. But the following does not work: ...
Shredderroy's user avatar
  • 5,249
6 votes
1 answer
273 views

Can I Import data into Google Spreadsheet using a Wolfram Cloud API?

I would like to use the IMPORTDATA Google Sheets function to load a Wolfram Cloud API into my Spreadsheet. How can I do that?
Murta's user avatar
  • 26.2k
6 votes
2 answers
207 views

extract a mxn matrix

...
Andrea Villabruna's user avatar
6 votes
1 answer
1k 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 ...
Cheng-Sheng Yan's user avatar
6 votes
1 answer
538 views

Problem with Excel export with specific hyperlink

Bug introduced in 8 or earlier and persisting through 12.2 Exporting Hyperlink[] to XLSX works usually just fine, but with this particular link ...
Karsten W.'s user avatar
  • 1,383
6 votes
0 answers
596 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: ...
Michael Stern's user avatar
5 votes
3 answers
4k views

Import specific data from Excel to make a plot

I need some help with this: I have imported data from an Excel file and I need to make a contour plot of it. The data are in table-like form. Here is a sample of the first few 'rows': ...
Nik Gkav's user avatar
5 votes
2 answers
374 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 ...
Mehmet's user avatar
  • 587
5 votes
1 answer
883 views

windrose with data from Excel

How to Import data from excel and use them to Plot windrose instead? Example, {{Strength, Angle(degrees)}..} ...
StartX's user avatar
  • 51
5 votes
2 answers
182 views

Code to emulate what excel does in cells

I would like to generate a code which emulate the calculations that are being perfom in columns A and B and row 7 to 12 in the attached first image. The results of those calculations are those shown ...
John's user avatar
  • 471
5 votes
3 answers
200 views

Help with fitting given data through an exponential function

I am trying to fit some data through the Mathematica function FindFit, however I encounter the errror: FindFit::fmgz: ...
user52467's user avatar
5 votes
2 answers
2k 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. ...
bkarpuz's user avatar
  • 809
5 votes
1 answer
183 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: ...
Michael B. Heaney's user avatar
5 votes
2 answers
967 views

Can Mathematica understand Excel dates when in number format?

I have a very large Excel file with dates in the format 2013/01/17 08:02:00 PM which is a custom date format. I have to convert this file to CSV in order to import it into Mathematica because I can't ...
lara's user avatar
  • 1,028
5 votes
2 answers
4k views

Import data from Excel and plot in Mathematica

I'm trying to Plot data in Mathematica that I upload from Excel. The Excel file has 5 columns. The first column I would like to be the x-values, and the remaining ...
Jewell Anne H.'s user avatar
5 votes
2 answers
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 ...
John's user avatar
  • 53
5 votes
1 answer
358 views

How can I export dataset to excel with names

...
HyperGroups's user avatar
  • 8,619
5 votes
1 answer
2k views

Excel DDE Link: reading and writing in real time

I'm wondering if it is possible to link Excel and Mathematica in real time, so that Mathematica can be used as a computing and "storage" tool. Suppose I have an Excel spreadsheet with an active DDE ...
Rod's user avatar
  • 3,318

1
2 3 4 5