Episode #125 of the Stack Overflow podcast is here. We talk Tilde Club and mechanical keyboards. Listen now

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
17
votes
2answers
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 ...
12
votes
1answer
5k 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'...
31
votes
6answers
9k 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: ...
8
votes
1answer
2k 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 ...
11
votes
2answers
5k 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 ...
19
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'...
15
votes
3answers
3k 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 ...
7
votes
5answers
584 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 ...
0
votes
1answer
3k 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 ...
6
votes
2answers
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 ...
5
votes
0answers
3k 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
724 views

Converting Excel serial dates with NETLink

Excel serial dates are not straightforward to convert since they include non-existent dates, e.g. {DatePlus[{1990, 1, 0}, 59], DatePlus[{1990, 1, 0}, 60]} {{...
5
votes
1answer
899 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
2answers
193 views

Hard time creating arrays with For/Do

So far this code Prints just a sequence of numbers, as you can see in the "Print"-Line. I would like to export the results in one excel sheet, which has rows "b,l,m,d,p,best n, value" and in each ...
37
votes
7answers
7k 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 ...
12
votes
3answers
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 ...
7
votes
1answer
3k 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 ...
7
votes
2answers
7k 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 ...
7
votes
2answers
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: ...
3
votes
2answers
2k views

Importing .txt or .csv financial data

I am trying to import some financial data exported from Excel. You can find the relevant file here : Text File or CSV File This is what the data looks like in Excel : Using the following code to ...
6
votes
2answers
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? ...
3
votes
1answer
2k views

How to export data from excel specific cells into mathematica?

How to export data from excel specific cells into Mathematica? Given that the spreadsheet tab is named XYZ and that I have several cells at various locations in the same column in Excel that I want to ...
2
votes
2answers
137 views

Create a hyperlink in an array to be exported as Excel file

I want to create an Excel file with some data and hyperlinks to a file. The goal is that in the end you can click in Excel the link and the file opens. The Excel file is to be exported from ...
1
vote
1answer
314 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 ...
18
votes
2answers
841 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 ...
13
votes
3answers
5k views

Excel Headers --> Mathematica

I have a large Excel .xls file. Miniature version shown below: (formatting should appear as two columns...) ...
11
votes
1answer
431 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 ...
13
votes
3answers
5k views

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

...
5
votes
3answers
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': ...
4
votes
1answer
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 ...
3
votes
2answers
511 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 ...
3
votes
1answer
153 views

Problem with Excel export with specific hyperlink

Bug introduced in 8 or earlier and persisting through 12.0 Exporting Hyperlink[] to XLSX works usually just fine, but with this particular link ...
2
votes
1answer
203 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] = Length[...
2
votes
1answer
732 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
0answers
123 views

Merging Excel workbooks into a single workbook using Mathematica

I have several Excel workbooks (in *.xlsx format) that I wish to merge into a single new workbook. The data in the workbooks have exactly the same format; they contain tables similar to this one: I'...
1
vote
2answers
115 views

Embedded data in a notebook

I'm looking for a method to store data which have been exported from an Excel sheet in my notebook. This enables my notenook to be indepent from the Excel sheet once the data have been imported. In ...
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 ...