For questions about importing from or exporting to Microsoft Excel sheets, and interfacing to Microsoft Excel using COM or other methods.
11
votes
2answers
847 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
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 ...
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 ...
6
votes
2answers
399 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:
...
10
votes
2answers
495 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 ...
8
votes
3answers
861 views
Excel Headers --> Mathematica
I have a large Excel .xls file. Miniature version shown below:
(formatting should appear as two columns...)
...
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, ...
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 ...
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 ...
1
vote
1answer
142 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]}
...
6
votes
0answers
336 views
4
votes
1answer
501 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 ...
2
votes
1answer
312 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 ...
