For questions about importing from or exporting to Microsoft Excel sheets, and interfacing to Microsoft Excel using COM or other methods.
1
vote
0answers
48 views
Exporting Specific Cells of Many Workbooks into One using Mathematica
I currently have a large number of detailed files from which I would like to extract certain cells' information to make an Archive spreadsheet.
There are approximately 9 parameters of each ...
9
votes
1answer
166 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, ...
2
votes
1answer
55 views
Using NetLink to Import Excel File
I can import an Excel file into Mathematica easily:
But when I try from .Net it fails:
These are the commands and errors I am getting:
...
-4
votes
2answers
75 views
Ploting from Matrix [closed]
I use Import function from excel in order to get my data. My data contains 3 columns.
...
-4
votes
1answer
99 views
Export plot to Excel
Very new to Mathematica. Used the code to solve for the response of a system of spring mass dampers but would like to export the data to Excel.
...
2
votes
5answers
110 views
Creating ordered triplets from an Excel sheet
I have an Excel sheet of the form:
" " a b c
1 R S T
2 U V W
3 X Y Z
Where every entry is a number (except the blank quotes, ...
4
votes
2answers
109 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 ...
0
votes
0answers
105 views
Export data from Excel not working for vlookup data
I have a cell in Excel in which this value is obtained by using the vlookup function (=vlookup(n,table range, column number) ). ...
1
vote
1answer
144 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]}
...
7
votes
2answers
368 views
How to write data from Mathematica to an existing formated Excel file?
I have a sheet in an Excel file already formated: 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 ...
3
votes
1answer
141 views
-4
votes
1answer
129 views
How to export data to specific rows and columns in XL file from Mathematica?
I have an XL File with data like :
{{1,2,3},{4,5,6},{7,8,9}}
That XL file name as ...
5
votes
1answer
335 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 some times, I need just to do some fast ...
2
votes
1answer
313 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 ...
6
votes
0answers
190 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, ...
1
vote
1answer
201 views
6
votes
0answers
339 views
0
votes
1answer
223 views
How to specify DataRange in a ListPlot with an imported set of data
So I've been trying to import a large set of data (6900 point pairs) from an excel (.xls) file. The Exel file has 2 columns of numeric data. I've also been trying to plot this data, but when I do, it ...
4
votes
1answer
504 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 ...
8
votes
3answers
864 views
Excel Headers --> Mathematica
I have a large Excel .xls file. Miniature version shown below:
(formatting should appear as two columns...)
...
2
votes
2answers
341 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?
...
6
votes
2answers
400 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:
...
8
votes
1answer
302 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 ...
5
votes
0answers
213 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 ...
10
votes
2answers
496 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 ...
11
votes
2answers
848 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
...
3
votes
2answers
2k 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 ...
3
votes
2answers
804 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 ...
